We upgrade db2 on z/os from v7 to v8. Our development environment is in compatibility mode, newfun(no).
I have sql stored procedure.
(1) When it is compiled in developmet (db2 v8 compatibility no fun), the C compiler complains about may characters.
I changed ccsid to 4133 and that solve the compiler problem.
But, when I call this routine from .NET application, it doesn't return any data.
I think it doesn't even reach the stored procedure.

Example of compiler error
ERROR CCN3275 SYS09288.T170654.RA000.CLINTRD.DSNHOUT.H01:4347 Unexpected text '|' encountered.

What I missing here?
what value this ccsd should be set to?
where is the sample compilation jcl for v8?

(2) When compile with newfun(yes) and ccsid 500, I got -471. I couldn't catch the reason code.

Your help is truly appreciated

Hi,

this is a mail I wrote to some of my colleguages back in 2007 when we migrated to v8.

Things might have changed since then but i might give you an idea where to digg for more information

Regards, Christer J

PS I remember that the use of |-sign was discused as a problem in v8 in some conferances back in 2005/2006 but we do not use it in Sweden so.. Ds

----- message -----
From: Johansson, Christer
Sent: den 31 august 2007 10:12
Subject:SQL PL, v8 and the C compiler


Hi,

I'm writing this with a little blush in my face.

Yesterday afternoon, after googeling for an hour, I did withdraw myself to a quiet spot with my file with v8 information and start to go through it. And after a while I found a page that I hade marked. It was this:


DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More

12.1.2 Other prerequisites
...
..
"C/C++

When coding in C or C++, make sure to use any of the following products:
C/C ++ (with or without Debug Tool), optional feature of z/OS
SAA AD/Cycle C/370 Compiler V1.2 (5688-216)

DB2 UDB for z/OS V8 does not yet support the coprocessor or precompiler services with C or
C++. Use of DB2 precompiler services with C requires, the DB2 coprocessor provided with
z/OS V1.5 and the DB2 UDB for z/OS and OS/390 V7 libraries. For use of DB2 UDB for z/OS
V8 function, use the precompiler as an alternative.

DB2 also supports programming languages such as Java, FORTRAN, Assembler, and
REXX. To find out what products are required, refer to the IBM software announcement letter
for DB2 Version 8, 204-029 for the US, or equivalent for other countries.

For additional information about supported coprocessor options, see also informational APAR
II13782."
..
..


Well, my memory isn't that good any longer, unfortunately.

So it seams as we have continue using v7 libraries. At least as long as we are on zOS 1.4

Regards, Christer

Thank you for the advice
The sql stored procedure is compiled okay with older version of load libraries. When execute from .NET, still, doesn't return any data and doesn't generate and sql error.
I can see the connection happened between .NET and z/os db2 through host integration server.
-Where can I find sample jcl to compile sql db2 stored procedure for db2 v8 on z/os.
-What precompile/compile option need to be set.
Appreciated