Unix Technical Forum

SEO

vBulletin Search Engine Optimization


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-10-2008, 02:03 PM
Gary
 
Posts: n/a
Default 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:06 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145