db2clp

Joshua Lee · #1 (**permalink**) 12-05-05, 03:41

Hi Grofaty,

I tried using the db2clp command in batch file and run on dos prompt, it works. However if I re-start my PC and re-run again, it hit 'DB21061E Command line environment not initialized.'

Please advise how you resolved this error? To what I know the db2clp no. is always changing once the PC was re-started.

Thank you very much.

Regards,
Joshua

wangzhonnew · #2 (**permalink**) 12-05-05, 07:13

executed db2cmd?

grofaty · #3 (**permalink**) 12-05-05, 07:41

Joshua Lee,

Here is a sample for exporting one table to IXF format using batch files. There is also an IF logic if something goes wrong. All messages are recorded into commands.log LOG file to see the results.

Contents of run.bat is:

Code:

db2cmd /i /c commands.bat

Contents of commands.bat is:

Code:

db2 connect to sample user db2adim using db2adin >> commands.log 
if not %errorlevel% == 0 goto error

db2 export to c:\table.ixf of ixf select * from db2admin.table >> commands.log
if not %errorlevel% == 0 goto error

db2 connect reset >> commands.log
if not %errorlevel% == 0 goto error
goto end

:error
echo "Error" >> commands.log
exit

:end
echo "OK" >> commands.log
exit

You will need to modify commands.bat file according to your needs. Then execute run.bat file to let commands.bat be executed.

Hope this helps,
Grofaty

gardenman · #4 (**permalink**) 12-05-05, 09:49

look at db2clpex.exe as well

)

Joshua Lee · #5 (**permalink**) 12-05-05, 21:38

Hi gardenman,

Thank you so much.
I used the following to run on dos command prompt and it worked:

db2clpex cmd /i /c ap_stmt_upload_isin

Thank you once again.

Yours sincerely,
Joshua Lee

Internet Services

Web Development

Digital Marketing

Consumer Tech