Hi all,

I am using this load statement to insert 70 lakh rows inside a table,But its throwing me an error...(in the Db2cmd prompt)

db2 load from C:\123\<file_name.txt> of del Modified by COLDELX09 Messages c:\123\error1.log insert into <table_name>

error SQL3025N A parameter specifying a filename or path is not valid.

Can anyone help me in rectifying the same pls

Hi,

I guess the target database is on a remote server while your data is on your local Window$ system? Then you'll need to do a "Load Client From mytxtfile OF Del ...".

Regards

Bernd