Load syntax help!!!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ananthaisin
    New Member
    • Aug 2008
    • 15

    Load syntax help!!!!

    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_na me.txt> of del Modified by COLDELX09 Messages c:\123\error1.l og 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
  • docdiesel
    Recognized Expert Contributor
    • Aug 2007
    • 297

    #2
    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

    Comment

    Working...