Re: Updating a record containing a BLOB
Bruce Vining <bvining-r/[email protected]> Sat, 19 May 2007 08:06:26 -0500
| Newsgroups | gmane.comp.lang.as400.mi |
|---|---|
| Message-ID | <OF6F380223.AF9A312E-ON862572E0.0047DFA7-862572E0.004814A8@us.ibm.com> |
There is no support, using standard data management, to open a file containing LOB data and then be able to access the LOB data by way of a read operation. This support is only provided using SQL interfaces. Bruce Vining Allen Hartley <[email protected]> Sent by: mi400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 05/18/2007 06:02 PM Please respond to MI Programming on the AS400 / iSeries <mi400-Zwy7GipZuJhWk0Htik3J/[email protected]> To MI400-Zwy7GipZuJhWk0Htik3J/[email protected] cc Subject [MI400] Updating a record containing a BLOB I have a problem updating a file that contains a BLOB field. I open the file that contains a BLOB and the data that is returned in the BLOB field is a block of nulls followed by *POINTER instead of the actual pointer value. The problem is when I update the record, it is being updated with a null pointer. Is there any way to get around this other than using SQL to do the update. Allen Hartley _______________________________________________ This is the MI Programming on the AS400 / iSeries (MI400) mailing list To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mi400 or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mi400. _______________________________________________ This is the MI Programming on the AS400 / iSeries (MI400) mailing list To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mi400 or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mi400.