4/14/2021 0 Comments Update Blob Field In Db2 Sql
The current search engine is no longer viable and we are researching alternatives.As a stop gap measure, we are using Googles custom search engine service.What happens in the future when you need to access the data in the BLOB You simply write the file back out of the IFS.Just use the appropriate file options to instruct the program to go the other direction.
Blob Field In Db2 Sql Free Myfilefo SQLFILEOVERWRITED c const(16) free myfilefo SQLFILEOVERWRITE; myfilename home2011DataFinancials2011.xls; myfilenl len(trimr(myfilename)); exec SQL SELECT docblob INTO:myfile FROM QGPLDOCREPOS WHERE DocTitle 2011 Financials Spreadsheet; return; end-free On Wed, Mar 13, 2013 at 10:56 AM, wrote: Ok, you have BLOB columns, character columns, numeric columns, etc. What is another type Datalink Now, Ive never used them, but is there some way to move a blob column to a data link column Rob Berendt -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 From: Jack Prucha To: MIDRANGE-Lxxxxxxxxxxxx, Date: 03132013 10:51 AM Subject: Move SQL Blob field (PDF) to IFS folder - How Sent by: midrange-l-bouncesxxxxxxxxxxxx Am writing an external stored procedure (rpgle) to read a bunch of db2 sql tables populated by a web process. Part of what the procedure is being asked to do is move a pdf, which is stored as a blob in one of the tables, onto a folder so it can be processed by Content Manager (our imaging system). The web guys (Java WAS) can and have dropped all sorts of objects on the IFS, but prefer that the stored procedure does it in this application. Ive searched this list and the internet in general and dont know where to begin. Blob Field In Db2 Sql Code Running OnTheres little Java application code running on the iSeries so a Java solution would be a maintenance issue. Id appreciate any help. TIA. Jack This email, including any documents, files, or previous email messages attached to it, has been sent from an email account of College Foundation Inc., (CFI) and may contain confidential, proprietary, or legally privileged information belonging to CFI. If you are not the intended recipient, any dissemination, distribution, or copying of this email or its attachments is strictly prohibited. Blob Field In Db2 Sql Archive Is CopyrightThis mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |