RE: SQL JSON_TABLE using CLOB_FILE limitations

I guess I should have added that was what I expected but mine abended on a
1.5G IFS file. It processed fine when I cut it back to .5G. Maybe I'll
continue to play and see if I can figure out why it died on the 1.5G.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Birgitta
Hauser
Sent: Saturday, November 7, 2020 5:31 AM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL JSON_TABLE using CLOB_FILE limitations

The maximum length of a CLOB File is 2 GB (which is also the maximum for an
IFS file).
The Number or entries and elements per entries are AFAIK not restricted.

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!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
smith5646midrange@xxxxxxxxx
Sent: Freitag, 6. November 2020 22:43
To: Midrange RPG List <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL JSON_TABLE using CLOB_FILE limitations

I am playing with the SQL JSON_TABLE using a CLOB_FILE for input. I wanted
to see what it was capable of and I think I have brought this little machine
to its knees. However, it hasn't blown up so maybe that's good news.



Does anyone know if/what limitations there are for this function such as

1. Maximum size for the IFS file to be processed?
2. Maximum number of entries in the table?
3. Maximum number of elements per entry?





--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com