View previous topic :: View next topic |
Author |
Message |
NorthernDancer Beginner
Joined: 01 May 2007 Posts: 44 Topics: 22 Location: DOWNTOWN BUFFALO, NY
|
Posted: Tue Nov 20, 2007 10:55 am Post subject: DB2 COMPILE ERROR |
|
|
CAN ANYONE SEE WHAT THE PROBLEM IS WITH THIS PARAGRAPH ?? i CANNOT SEE ANY COMMA ITS COMPLAINING ABOUT??
Code: |
007713** PTTEST 2374-DELETE-CLMNFS.
007714** PTTEST EXEC SQL
007714==> IGYPS0226-E DSNH104I DSNHPARS ILLEGAL SYMBOL ",". SOME SYMBOLS THA
ARE: <END-OF-STATEMENT>
007715** PTTEST DELETE FROM CLM_NOTIF
007716** PTTEST WHERE SCCF_ID
007717** PTTEST = :CIADBK-SCCF-SERIAL-NUMBER
007718** PTTEST AND BUS_OWNER_ID
007719** PTTEST = '0001'
007720** PTTEST END-EXEC.
007721** PTTEST*
007722** PTTEST 2374-DELETE-EXIT.
007723** PTTEST EXIT.
007724** PTTEST*
|
|
|
Back to top |
|
 |
jsharon1248 Intermediate
Joined: 08 Aug 2007 Posts: 291 Topics: 2 Location: Chicago
|
Posted: Tue Nov 20, 2007 11:54 am Post subject: |
|
|
It's hard to tell from the post, but are you starting the EXEC SQL and DELETE statement in column 12 or beyond? Also, is it possible you missed an END-EXEC on a previous statement? Or maybe even an unmatched quote? |
|
Back to top |
|
 |
Terry_Heinze Supermod
Joined: 31 May 2004 Posts: 391 Topics: 4 Location: Richfield, MN, USA
|
Posted: Tue Nov 20, 2007 6:07 pm Post subject: |
|
|
Are there any commas on line 7714 to the right of the partial screen you showed us? _________________ ....Terry |
|
Back to top |
|
 |
|
|