RE: Beginning SQL question

Charles,
Thanks you nailed it somehow my RSE was showing the libraries
even with a refresh but I went and added it again just to make sure and
it worked. Ass I said it is a real Dark Monday here in Ohio

Again Thanks

Bob
IT Guy


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Monday, August 20, 2007 4:19 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Beginning SQL question

Bob,

No, that's not the problem.

There's no operational difference between DDS created files and SQL DDL
created files.

I'd guess you've got a library list problem. I know you said you
checked, but you need to double
check.

Is this interactive, or batch? If batch, is the library list from the
JOBD being used and is it
correct?

Charles

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Anderson
Sent: Monday, August 20, 2007 3: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

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.