Blob data storage on the iSeries

Tags:
AS/400
What would be the best way to store and retrieve Blob(jpg etc) images on the iSeries so we could access them through a web page interface using v5r3 of RPGLE and cgi? I know how to do it through the IFS. Is there a way to store Blobs in the iSeries native file system?

Answer Wiki

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

To answer your second question, here’s the database reference at the Information Center on data types:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/db2/rbafzmstch2data.htm

Scroll down to Binary Strings and Large Objects.

Here’s the URL to the CREATE TABLE function where you can also look at the syntax for setting up the BLOB column in a table:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/db2/rbafzmsthctabl.htm

As to the first question, that would depend on many factors. Other people might be able to offer a more expert opinion.

Discuss This Question: 2  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
  • JPLamontre
    the answer is mainly in the question : a BLOB (binary Large Object) is a type of SQL column. So the best way to store or retrieve is a SQL call. Direct call or stored procedure depending on your architecture, or if not, on samples you will find. And storage of BLOB inside the database or outside (ie if IFS) also : depends of your architecture or found samples. some month ago I have read some docs on BLOBs but don't remember where I found it. Look at ibm infocenter (SQL Reference InfoCenterinfodb2rbafzmst.pdf), or in search400 or on the web.
    0 pointsBadges:
    report
  • TomLiotta
    I agree that the 'answer is in the question'. If it's a BLOB, then it's already in the native file system. Otherwise it's not a BLOB -- it's a streamfile. Tom
    125,585 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