I need to "import" a text file located in the user computer to a DB2 table in the database. What's the best way to do this?
You have a couple of options: You could create a table with a CLOB column, store the text file in that column, and use LOB Locators to access the data.
For more information on this technique, consult the Redbook "DB2 UDB for AS/400 Object Relational Support"
Another option would be to copy the text file to a stream file on the IFS and use the CPYFRMIMPF command.
Example: CPYFRMIMPF FROMSTMF('/testdir/fromfile.txt') TOFILE(QGPL/TOFILE) MBROPT(*REPLACE) RCDDLM(*ALL) STRDLM(*NONE)
This was first published in November 2005