AS/400 SQL BLOBS

25 pts.
Tags:
AS/400
AS/400 SQL
BLOB
SQL
I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible?

Software/Hardware used:
AS/400SQL

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes you can if you use embedded SQL in your RPG program to do the file access.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Yorkshireman
    Actually folks, RPG fields are 64k - this form the 5r4 manual RPG IV Restrictions Function Restriction Array/table input record length for compile time Maximum length is 100 Character field length Maximum length is 65535 bytes Graphic or UCS-2 field length Maximum length is 32766 bytes Control fields (position 63 and 64 of input specifications) length Maximum length is 256 Named data structure length Maximum of 65535 Unnamed data structure length Maximum of 9999999 Data structure occurrences (number of) Maximum of 32767 per data structure Edit Word Maximum length of 115 Elements in an array/table (DIM keyword on the definition specifications) Maximum of
    5,580 pointsBadges:
    report
  • Cwc
    In 6.1 of the operating system, the RPG limits have been significantly increased, such as field sizes up to 16MB. What release is your system on?
    4,290 pointsBadges:
    report
  • Newsqluser
    We are currently at v5r4 and will be going to v6r1, but I'm trying to get my head around how to read a 100MB field into an RPGSQL program. I've seen some examples using the BLOB locator, and I think that this is the way to do it, but I guess I need to research a little more. I appreciate all of your comments.
    25 pointsBadges:
    report
  • Cwc
    In case you haven't seen this already, here's a good article about dealing with BLOBs and CLOBs within RPG with SQL. http://www.ibmsystemsmag.com/ibmi/developer/8394p1.aspx
    4,290 pointsBadges:
    report
  • Cwc
    Well, links don't seem to work here for the time being. Hopefully, this URL will go through legibly, to where you can copy and paste it. http://www.ibmsystemsmag.com/ibmi/developer/8394p1.aspx
    4,290 pointsBadges:
    report
  • Newsqluser
    Cwc, I think your links gave me the information I have been looking for. This should help alot. To all those that took the time to add their comments, thank you.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following