Skip to Content
0
Former Member
Dec 20, 2007 at 05:20 PM

SQL commands in loadercli command files

221 Views

Hello,

i want to write a script which i could use for exporting / importing database tables from one db to another.

the script should export selected tables from the source db, delete the data in the selected tables in the destination db, and then import the selected data from the export files.

it could be that there are no records in the destination table, so the delete statement would fail:

aportal@server:~/install/dbscripts> /opt/sdb/programs/bin/loadercli -n localhost -u dbadmin,dbadmin -d ap_testu -b aportal-i.cmd

Loader protocol: '/home/aportal/sdb/server/loader/log/loader.log'

Loader packages: '/home/aportal/sdb/server/loader/packages'

User DBADMIN connected to database AP_TESTU schema DBADMIN on localhost.

use user aportal aportal

Successfully executed

SET MAXERRORCOUNT 3

Successfully executed

delete from aportal.tabelle

Error during execution

-->-25010

SQL error 100 = Row not found (error position: 1)

Defined maximum number of errors (1) reached

1 error(s) while processing command file 'aportal-i.cmd'.

---> See Loader log file for more information.

i thought to increase the maxerrorcount value, but this doesn't work. is there another possibility to delete empty tables?

thx