Re: Problem in Dynamic SQL

Will it accept a datastructure?
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzajp/rzajpmst132.htm#HDRHOSTSTRUCIRPG

Because, according to the docs, a larger variable is generally supported, 
and data structures should only be necessary for older versions of RPG 
which did not support character variables larger than 256 bytes.  Perhaps 
VARPG falls into that constraint.
I could find nothing specific regarding the PREPARE statement.

Is this unique to VARPG, and not other RPG?  Then perhaps some assistance 
may be from 
http://lists.midrange.com/mailman/listinfo/code400-l

What message are you receiving?  Message id too, if you can.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Mahesh Pawar <mahesh@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/22/2004 01:13 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Problem in Dynamic SQL






Hi,
: I am connecting to US Server from India. For getting the data I am using 
DB2 connect with dynamic SQL in VARPG. But I am facing a problem in the 
Prepare statement. The prepare statement does not accept the length of the 
variable (in which full select statement is given) from which it is 
prepared, more than 254 characters, and my select statement has more than 
1000 characters.
: Pls. help me on this.


Thanks & Regards
Bhooshan Malhotra
Software Programmer

System & Software,
SDF IV,Unit 123, Seepz,
Mumbai, India.
Phone# : 0091-22-28290075,28291824
Fax #:     0091-22-28292578(Fax)
Visit us on :www.systsoft.com 

_______________________________________________
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.