[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
- Subject: SQR error on AS/400
- From: Deepak Joshi <djoshi@ERAC.COM>
- Date: Mon, 12 Apr 1999 08:05:46 -0500
- Organization: Enterprise Rent-A-Car
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