The maximum size of your BLOB is restricted to 500 Byte.
If you want to process larger BLOBS, it is possible to change the maximum
size.
The maximum size a LOB Variable can have, depends on the RPG restrictions
for character fields. Before Release 6.1 the maximum size was restricted to
65535 bytes. Since release 6.1 the maximum size can be 16 MB.
If you need to access larger (Binary) Large Objectc, you either have to work
with LOB-Locatores or LOB-File Reference Variables.
BTW the redbook Stored Procedures, Triggers and User Defined Functions is
currently reworked and according to Jim Denton at the Common Fall
Conference, the reworked version will be published this year.
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 [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Paul
Jones
Gesendet: Thursday, 26.11 2015 17:30
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQLTYPE and BLOBs
Hi. I've seen a few examples of using BLOBs and I can get it working, but I
can't find details about the syntax for SQLTYPE.
In this example, what does the number 500 represent?
D MYBLOB S SQLTYPE(BLOB:500)
In a CLOB, I'd expect it to be the number of characters, but for a BLOB is
it the number of bytes?
Is this a fixed size for the object? Or an upper limit? Or just an initial
allocation and then the system uses as much space as required?
Any idea how big this number can be before we have to consider the impact on
the system?
I realise it depends on our hardware and the number of jobs we're running...
but is 500000 big? Or 5000000?
The reason for asking is that we generally expect small PDFs but it's
possible to have repeating sections so in rare cases we get very large
files.
Thanks.
________________________________
Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts
Festival.
Registered Address: Ageas House, Hampshire Corporate Park, Templars Way,
Eastleigh, Hampshire, SO53 3YA Registered Number: 354568 England
Authorised by the Prudential Regulation Authority and regulated by the
Financial Conduct Authority and the Prudential Regulation Authority
This e-mail together with any attachments are intended for the addressee
only and may be private and confidential. If you are not the intended
recipient, or the person responsible for delivering it to the intended
recipient, you must not open any attachments, or copy, disclose, distribute,
retain or use this e-mail, including any attachments, in any way whatsoever;
please return it to us immediately using the reply facility on e-mail.
Consider the environment and think before you print this email.
--
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
