Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ANSI Dynamic SQL syntax in DB2 [789] for z/OS

0 views
Skip to first unread message

Gary

unread,
May 9, 2008, 4:39:12 AM5/9/08
to
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:
"<identifier>".

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

0 new messages