Is the above available?
I've been looking at ISO/IEC 9075-2:2003 and the dynamic SQL syntax
contained there works fine on Oracle when embedded in a COBOL
application but I get errors such as:
43 SQL0104N An unexpected token "'inlist'" was found
following "ALLOCATE". Expected tokens may include:
"<identifie r>".
When trying to do this:
exec sql allocate descriptor 'inlist' end-exec.
Using DB2 LUW 9.1 on Linux - I really want it to work on z/OS though (we
don't yet have 9 running on z/OS, but we could if we had to. We have 8
on z/OS at the moment).
In the past I've found DB2 to be more ANSI than Oracle if you like.
Am I missing something or has this ANSI syntax not been implemented yet
in DB2?
Thanks
Gary
I've been looking at ISO/IEC 9075-2:2003 and the dynamic SQL syntax
contained there works fine on Oracle when embedded in a COBOL
application but I get errors such as:
43 SQL0104N An unexpected token "'inlist'" was found
following "ALLOCATE". Expected tokens may include:
"<identifie r>".
When trying to do this:
exec sql allocate descriptor 'inlist' end-exec.
Using DB2 LUW 9.1 on Linux - I really want it to work on z/OS though (we
don't yet have 9 running on z/OS, but we could if we had to. We have 8
on z/OS at the moment).
In the past I've found DB2 to be more ANSI than Oracle if you like.
Am I missing something or has this ANSI syntax not been implemented yet
in DB2?
Thanks
Gary