RE: SQL and qualified DS

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

Yes, I ran into this problem in the past (it is in the archives). You can't
use qualified DS for SQL.

Mike Wills
Taylor Development
Lawson Administrator/Programmer
Ph. (507) 386-3187

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Frank.Kolmann@xxxxxxxxxx
Sent: Thursday, May 27, 2004 7:27 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL and qualified DS





Hi Everyone

I  did a  SQL PREPARE  to set up and SQL insert with parm markers.
Then an SQL EXECUTE USING and I tried a qualified DS to pass variables.
Program compiled but when it ran it did not work properly.

I am confused.
The archives have examples that seem to show that qualified DS can be used
with SQL but the heading reads as SQL precompiler does not support qualified
variables .

Are there issues with SQL and qualified DS.
we are on V5R2.

Regards
Frank Kolmann


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.