Hello All,

Well the Heading looks like it says it all, What I would like to know is How to read/transfer coma separated data from a text file into an existing table in db2 database.Also using a command in the dos window will do.

Thanks All

this page has it all
IMPORT
db2 import from xx.yy of del insert into schema.table(cols)

Thanks prytula_guy

but me also what to know how to write in a txt file, i.e I would like to create a log file, while executing the procedure so after running some part of code in the procedure i need to write out some information on to the log file, please let me know about this i had a look with export, do you think by creating a temp table and inserting the process in this table and at the end of the procedure, use this export command to export all records to a text file,

if possible also provide me with some links to where i can find more information about this.

:-)

from import you can not write to a log file, only the import messages can be saved to a message file. if custom messages are needed, try using a stored proc and write message to a file as described here
Yet Another Article on Advanced Scripting