AW: Stored Procedure with a very large data type

The parameter is defined as CLOB (Character Large Object) and not as CHAR
(Character field).
The maximum length a character field can have in SQL is 32.767 Byte.
If you want to define a host variable in RPG that can exchange information
with the Stored procedure it must be defined as CLOB variable and NOT as
Character field.
For defining a host variable as large object you need the keyword SQLTYPE.

D MyClobVar S
SQLTYPE(CLOB: 60000)


Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von RPGLIST
Gesendet: Tuesday, 17.9 2013 20:42
An: RPG programming on the IBM i (AS/400 and iSeries)
Betreff: Re: Stored Procedure with a very large data type

Yes I would say it does since the stored procedure is actually referencing
an RPGLE

Does this have anything to do with RPG? Perhaps it should have been
posted to Midrange-L...

;-)

- sjl


"RPGLIST" wrote in message
news:mailman.8275.1379444579.9013.rpg400-l@xxxxxxxxxxxx...

One of our c# programmers is attempting to call a stored proedure and
pass me a large data set (approx 60,000 bytes) in a field defined as a
clob (iSeries DB2) but we're getting an SQL error that the string
length is too long, but I believe that a CLOB has a max size of 2gb,

The error is: "String constant beginning with .1.....' too long.

Cause: The string constant beginning with .1...." is larger than 32740.

suggestons?

--
This is the RPG programming on the IBM i (AS/400 and 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.

--
This is the RPG programming on the IBM i (AS/400 and 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.