IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Storing a BLOB/CLOB in PL/I


IBM Mainframe Forums -> PL/I & Assembler
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Zilla

New User


Joined: 03 Jun 2023
Posts: 11
Location: india

PostPosted: Wed Aug 16, 2023 5:32 pm
Reply with quote

Hi Team, Any idea how can I store an extra large object in PL/I variable? I know there is a limit of 32766 chars in PL/I, what if I want to store 500,000 bytes of data? Is there is any way? I have this CLOB data in one of the table column with 500,000 bytes which I want to read in PL/I host variable. Thanks in advance.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1313
Location: Vilnius, Lithuania

PostPosted: Thu Aug 17, 2023 11:11 am
Reply with quote

Code:
dcl array(5000000) char(1);
Back to top
View user's profile Send private message
Zilla

New User


Joined: 03 Jun 2023
Posts: 11
Location: india

PostPosted: Thu Aug 17, 2023 11:26 am
Reply with quote

thanks prino for this. It gives me "Unsupported use of aggregate expression." because I want to use INDEX function on array variable and it seems is not allowed. Even I tried a slight variation thinking I will be able to use array as a combined variable with all concatenated values but same issue "Unsupported or invalid use of structure expression."
Code:
dcl 1 array,
              5 a(500000) char (1);
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1313
Location: Vilnius, Lithuania

PostPosted: Thu Aug 17, 2023 11:53 am
Reply with quote

Actually, nowadays in Enterprise PL/I there's an option to allow for very big character strings. RTFM, because I don't have the inclination to do it for you.
Back to top
View user's profile Send private message
Zilla

New User


Joined: 03 Jun 2023
Posts: 11
Location: india

PostPosted: Thu Aug 17, 2023 12:14 pm
Reply with quote

no worries, I will check it out, thanks
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PL/I & Assembler

 


Similar Topics
Topic Forum Replies
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Storing SORTOF files in a PDS SYNCSORT 3
No new posts CLOB Column data to External File usi... DB2 9
No new posts Ccompar BLOB (images of type jpg) on ... DB2 0
No new posts Storing huge volume of data, compare ... All Other Mainframe Topics 3
Search our Forums:

Back to Top