vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
| |