× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.