Google Groups Home
Help | Sign in
ANSI Dynamic SQL syntax in DB2 [789] for z/OS
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Gary  
View profile
 More options May 9, 4:39 am
Newsgroups: comp.databases.ibm-db2
From: Gary <postmas...@127.0.0.1>
Date: Fri, 09 May 2008 09:39:12 +0100
Local: Fri, May 9 2008 4:39 am
Subject: ANSI Dynamic SQL syntax in DB2 [789] for z/OS
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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google