Re: SQLTYPE and BLOBs

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Paul,

The 500 in your example is the length of the BLOB.  (This BLOB can store 
up to 500 bytes... which seems silly to me, why bother with a BLOB for 
such a tiny amount of data?  But, anyway...)  Yes, it is the upper 
limit.  Under the covers, RPG will generate a data structure containing 
a 'LEN' field and a 'DATA' field, the LEN field will be 10U 0 and will 
indicate the length of the data... the DATA field will be 500A in RPG in 
this example.

For details, take a look here:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajp/rzajpirpglobhost.htm

There's really not a lot to it.


On 11/26/2015 10:30 AM, Paul Jones wrote:
> 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.