Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Load BLOB into DB2
Thanks Mercury2 for the post. Yes. The flat file is on IFS. We are using BLOBs since we receive xml data in the BLOBS. Also doing some research I found out that we cannot use CPYFRMIMPF command to import files containing BLOBS. Db2 load and import utilities seem to be other options. I am... -
Load BLOB into DB2
Hi Thanks a lot for your response... The matching column in DB2 is also a BLOB. I ran the following sql to create the table I am trying to populate as: CREATE TABLE PROGC( COMXYZABCD_ID FOR COLUMN I_COM00001 INTEGER NOT NULL , FA_ID VARCHAR(4) CCSID 37 NOT NULL , COMXYZABCD_DATA FOR... -
Load BLOB into DB2
Hi I am trying to load a flat file containing BLOBs into DB2 V8 on iSeries V5R3. Is there a way I can use CPYFRMIMPF to get the data loaded? Please advice. I am new to iSeries and DB2. Any help is much appreciated.
