Re: RHEL4 Linux/MF CObol precompiler question-

"Yah Navatkah" <edison_at_newpaltz.edu> schreef in bericht news:lY6dndRnX9pQP5rVnZ2dnUVZ_oGjnZ2d_at_sunynewpaltz...
> 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:
>
> -----------------------------------------------------------------------------
> Error at line 1081, column 12 in file SZBDBRG.pco
> 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
>

Looks like you have to add: select stvsubj_code into <soome_dummy_var> to your statement.
Must be some version difference, did you check if this compiled in your 'old' version? Do you have more selects without 'into' in your code that DO work?

Shakespeare Received on Thu Apr 17 2008 - 15:02:30 CDT