In command center click the "tools settings" icon and select the "use statement termination character", see the default ";" there.
In CLP write "db2 -t -f D:\mysqldir\filename.sql"to tell the processor to use the default ";" teminator with "-t" anf to read a file with "-f".
Good luck
Juan Lanus
TECNOSOL
Bala Rajagopal wrote:
[EMAIL PROTECTED]">Hi,I'm trying to configure UDB client. I'm unable to execute more than one sql statement from my command center. If I seperate multiple stmts with semicolon, it stops after the first statement. What i can I do to avoid this and execute multiple stmts separated by semicolon. I tried LIST COMMAND OPTIONS and UPDATE COMMAND OPTIONS but couldnt find a solution. Pleasee help.Bala
