You cannot define a CLOB-Variable in this way, due to the RPG restrictions
(maximum length for an RPG variable is 16MB - since Release 6.1) so the
maximum length of a CLOB variable is 16MB.
If you need to access CLOB-Data up to 2 GB, you either have to use a
CLOB_LOCATOR or if you want to access data in the IFS a LOB Reference File
CLOB_FILE.
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 Peter Connell
Gesendet: Wednesday, 05.2 2014 12:01
An: RPG400-L@xxxxxxxxxxxx
Betreff: SQLTYPE syntax for 2GB clob
I once spotted the correct for specifying a gigabyte clob but can't find it
again
Something like SQLTYPE(CLOB: 2G) but that doesn't work as a D-spec
############################################################################
#########
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately delete it from your system and
notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be the
views of Veda.
If you need assistance, please contact Veda on either :- Australia
1300-762-207 or New Zealand +64 9 367 6200
--
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.
midrange.com
