Doh... Never mind.... No F spec.......
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of DeLong, Eric
Sent: Monday, August 20, 2007 3:17 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Beginning SQL question
It would most likely need a RENAME option on the F-spec. SQL defined tables will name the record format the same as the table name. This is not acceptable to RPG, which needs uniquely named resources...
Eric
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Bob Anderson
Sent: Monday, August 20, 2007 2:38 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Beginning SQL question
As a follow-up I changed the EXTNAME to another file from MAPICS and the
compile is clean.
I believe the problem lies in the fact that the IMPPOHDR table is a true
SQL Table that was created by an SQL Script versus being created via
DDS. Is that possibly the problem, that the precompiler doesn't know
how to get the file definition.
How do I correct that
Bob
IT Guy
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Anderson
Sent: Monday, August 20, 2007 1:42 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Beginning SQL question
Charles,
The SQL1001 is happening on the External DS and since it occurs
there the SQL0312 happens because of it I think.
The Library list lists KENTWEB then KENTWEBF and IMPPOHDR is a table
in KENTWEBF
Thanks
Bob
IT Guy
-----Original Message-----
From: rpg400-l-bounces+banderson=kentwatersports.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+banderson=kentwatersports.com@xxxxxxxxxxxx] On
Behalf Of Wilt, Charles
Sent: Monday, August 20, 2007 1:14 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Beginning SQL question
When I compile in WDSC it give me 2 errors as follows:
SQL0312 Position 66 Variable POHREC not defined or not usable.
This usually means the variable is either not defined, or defined in
more than one place possibly with
different attributes.
The SQL precompiler expects globally unique variables.
This was relaxed somewhat in newer release so that you could have the
same variable defined locally in
a procedure, but you have to have the same attributes for that variable
everywhere. The precompilier
ignores a variables scope in RPG IV.
SQL1001 External file definition for IMPPOHDR not found.
Are you getting this on the DECLARE CURSOR or on the external DS?
The declare cursor is specifying a library of KENTWEBF, does the file
exist there?
HTH,
Charles
This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not
a named addressee you are hereby notified that you are not authorized to
read, print, retain, copy or disseminate this communication without the
consent of the sender and that doing so is prohibited and may be
unlawful. Please reply to the message immediately by informing the
sender that the message was misdirected. After replying, please delete
and otherwise erase it and any attachments from your computer system.
Your assistance in correcting this error is appreciated.
midrange.com
