Re: SQR error on AS/400

[Les Hancock <les_hanc@YAHOO.COM>]

Try using

\$whereclause\

instead of

[$whereclause]


IBM Mainframes (and I guess AS/400) don't like the
brackets.





--- Deepak Joshi <djoshi@ERAC.COM> wrote:
> I am trying to run the following SQR on the AS/400.
> But when I call the
> SQR, I get an error during pre-run time.
>
> The code and the error is as given below,
> CODE
> Begin-Procedure Get-Legacy-Values
>
> Begin-Select     loops=100
> A.HMRCCD
> A.HMRNID
> ... More fields
>
> .... Some Let's and Do's
>
> FROM       HR006P A
> [$WhereClause]
> END-SELECT
>
> End-Procedure  !Get-Legacy-Values
>
> **The $whereclause is defined elsewhere in the
> program and contains
> Where (A.HMRGP = '01' or A.HMRGP = '15')
>
> ERROR
> I get the following error
> SQR V4.1.3
> Copyright (C) SQRIBE Technologies, 1994-98.  All
> Worldwide Rights Reserved.
> (SQR 5528) DB2 SQL PREPARE/DECLARE error -104 in
> cursor 4:
> (SQR 5536) Unknown error message number: -104.
> SQL: select A.HMRCCD, A.HMRNID,  other fields
> FROM
>      HR006P A [?
> Error on line 300:
>    (SQR 3716) Error in SQL statement.
> Errors were found in the program file.
> SQR: Program Aborting.
> Press ENTER to end terminal session.
>
>
> I get this error when I use the STRSQR command on
> the AS/400. Any
> assistance to correct the problem will be
> appreciated. Do not know what I
> am doing wrong. When I replace the [$whereclause]
> with the actual value the
> program works. What is the problem ?
>
>
> Thanks, Deepak
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com