Thankyou Joachim and Kish. You were right I was using Interactive tab. I found the srcipt center can execute multiple stmts/cmds. But I'm facing another problem. Do any given statement or command must appear in single line(without wraping) to exceute it as scripts under SCRIPT tab or Script Schedule ?,
for example if i try to execute an sql statement like this in script tab it executes successfully: "create table x ( col1 char(10) not null, col2 smallint not null)" if I wrap the stmt and try this way it fails "create table x ( col1 char(10) not null, col2 smallint not null)" (((((((it fails with following mesg: create table x ( col1 varchar(128) not null, DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "," was found following "archar(128) not null". Expected tokens may include: ")". SQLSTATE=42601)))))))) I tried UPDATE COMMAND OPTIONS n ON and OFF, but didnt help. Any ideas to execute wraped statements/commands via command center Script tab ? Thanks in advance Bala ----- Original Message ----- From: "Joachim Mueller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 09, 2001 7:05 PM Subject: Antwort: DB2EUG: a basic problem with UDB 7.1 command center Bala, if you use the interactive tab in the Command Center you can only execute one sql statement. Use the script tab and you can execeute a lot of sql statements sepereated by a semicolon. best regards Joachim M�ller -------------------------------------------------------- Datenbanken DOUGLAS Informatik & Service GmbH Kabeler Stra�e 4 D-58099 Hagen Tel.:+49-2331-690-249 Fax:+49-2331-690-78-249 Mobile: +49-170-2221-249 mailto:[EMAIL PROTECTED] http://www.douglas-informatik.de "Bala Rajagopal" <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] Gesendet von: Kopie: [EMAIL PROTECTED] Thema: DB2EUG: a basic problem with UDB 7.1 command center a.best.com 09.10.2001 14:41 Bitte antworten an db2eug 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 ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
