Birgitta,
I was attempting to accommodate receiving a file of up to 2GB and storing each in a DB2 file as a CLOB.
I now realize that using embedded SQL to read the data from a stream file via a CLOB_FILE data type and write it directly into the 2GB CLOB column is the answer.
It was interesting to debug and observe the write operation take about 80 secs for a 0.7 GB file.
I have not yet been able to find again the material that describes the abbreviated nomenclature for specifying the size of LOBs in units other than bytes like K, M or G
Thanks, Peter
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Thursday, 6 February 2014 12:17 a.m.
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: AW: SQLTYPE syntax for 2GB clob
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.
--
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 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
midrange.com
