Re: RHEL4 Linux/MF CObol precompiler question-

On Apr 21, 1:06 pm, "Shakespeare" <shakespe..._at_mi5.uk.com> wrote:
> "Shakespeare" <what..._at_xs4all.nl> schreef in berichtnews:4807acc8$0$14361$e4fe514c_at_news.xs4all.nl...
>
>
>
>
>
>
>
> > "Yah Navatkah" <edi..._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

So the next not-so-lazy person can be rewarded for doing some research. And the one after that. And...

jg

--
@home.com is bogus.
http://science.nasa.gov/headlines/y2008/21apr_ducttape.htm?list39638