RHEL4 Linux/MF CObol precompiler question-

Hi-

   We're migating our OS from AIX (Oracle 9.2.0.6 & MF Cobol) to RHEL 4 (Oracle 10.2.0.1, also MF Cobol). Every program that compiles and runs on AIX seems to do the same on RHEL4. Every program except one, where the precompiler seems to be having a problem rejecting some (but not all!) sql exec directives:

            exec sql
...........1

PCB-S-00576, PLS-428: an INTO clause is expected in this SELECT statement Error at line 1081, column 12 in file SZBDBRG.pco

            exec sql
...........1

PCB-S-00576, PLS-0: SQL Statement ignored Error at line 1097, column 12 in file SZBDBRG.pco

            exec sql
...........1

the source code segment:

01078       *     move ws-spriden-id to stuid.
01079            move ws-sourceid to ws-instid.
01080
01081            exec sql
01082              select stvsubj_code
01083              from   stvsubj
01084              where  rpad(stvsubj_code,4,' ') =:ws-shrtrce-subjcode
01085            end-exec.
01086            if sqlcode <> 0
01087              move 'N' to inst-validflag
01088              string 'Subject code not found in STVSUBJ table:' ',
01089              ws-shrtrce-subjcode delimited by size into ws-table
0---------------------------------------------------------------------------

Not sure what's going on..any ideas?

thanks in advance...
bill Received on Thu Apr 17 2008 - 14:26:01 CDT