|
Hi James,
the SQLStmt can be varying.
You have to use the SQLDA.
We've build a procedure and we use it in this way
eval statement = ......
dow sql_statement(statement)
eval filexyz_ds = sqldata_ds
...
enddo
-----Ursprüngliche Nachricht-----
Von: James Rich [mailto:james@eaerich.com]
Gesendet: Mittwoch, 15. August 2001 22:53
An: rpg400-l@midrange.com
Betreff: RE: if defined syntax in sql rpg?
On Wed, 15 Aug 2001, Phil wrote:
> D SQLStmt s 1024 varying
> D
> C eval SQLStmt = 'CREATE INDEX ' + %trim(lN) +
> C '/' + %trim(idxN) + ' ON ' +
> C %trim(lN) + '/' + %trim(fN) +
> C ' (' + %trim(idx) + ')'
Does SQLStmt have to be varying? I'm on V4R1M0 and last I checked I
couldn't use varying.
James Rich
james@eaerich.com
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
As an Amazon Associate we earn from qualifying purchases.
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.