[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR error on AS/400



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