Re: RHEL4 Linux/MF CObol precompiler question-

From: Shakespeare <shakespeare_at_mi5.uk.com>
Date: Mon, 21 Apr 2008 22:06:10 +0200
Message-ID: <480cf3b2$0$14345$e4fe514c@news.xs4all.nl>

"Shakespeare" <whatsin_at_xs4all.nl> schreef in bericht news:4807acc8$0$14361$e4fe514c_at_news.xs4all.nl...
>
> "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
>\

I often wonder what's the use of answering questions here if there's no response at all..........

Shakespeare Received on Mon Apr 21 2008 - 15:06:10 CDT

Original text of this message