Loading Ascii file

Posted January 13th, 2010 by Rams

Hi,
i am loading the Ascii file into db2 database. my requirement is every time i will load the new data, that time existing data will removed and insert the new data. i tried with out put mode as "replace file/table", but i got failed its error throwing number is 25507.please suggest to me , how to achive this.....

‹ Please clarify the below questions Sequencing by field ›

RE: Loading Ascii file

On January 13th, 2010 jterrell said:

Hi Rams,

An error 25507 usually means you are either not connected to the database (in your case IBM DB2) or that the database login credentials that you are using does not have permissions to create tables in the database.

First, be sure the IBM DB2 client drivers are installed and configured properly on the workstation where DataTools is installed.

Second, refer to the documentation that describes the exact steps for connecting to an IBM DB2 database, and be sure you are entering all of the connection information correctly on the Target Connection tab.

Let us know if you need further assistance.

- Jo

Hi Jo, Every time, i need

On January 19th, 2010 Rams said:

Hi Jo,

Every time, i need delete the old recors and to insert the new data into my existing target table, what output mode should be used in this case.please clarify.