Urgent - Multiple SQL in UDB Command Center.

Deepak Kini M

Urgent - Multiple SQL in UDB Command Center.
Dear List:

Is there a way to run Multiple SQL queries in UDB Command Center?.
We have generated SQL from ERD automatically from a tool and we need to
create physical database using these quries for which, we are planing
to use Script/interactive in UDB Command center.
But further to this when I tried to execute 2 quries in Script or
Interactive it errors out saying cannot execute multiple quries!!!
Is there a way to handle this?

Your help is appriciated!@
Thanks
Deepak


Srikanth (Cognizant) Chavali

Re: Urgent - Multiple SQL in UDB Command Center.
(in response to Deepak Kini M)
Hi Deepak,
You should be able to execute multiple SQL statements in
UDB Command center by ending each single statement with a semi-colon ( ; ).

Regards,
Srikanth

> -----Original Message-----
> From: Deepak Kini M [SMTP:[login to unmask email]
> Sent: Tuesday, December 18, 2001 12:07 PM
> To: [login to unmask email]
> Subject: Urgent - Multiple SQL in UDB Command Center.
>
> Dear List:
>
> Is there a way to run Multiple SQL queries in UDB Command Center?.
> We have generated SQL from ERD automatically from a tool and we need to
> create physical database using these quries for which, we are planing
> to use Script/interactive in UDB Command center.
> But further to this when I tried to execute 2 quries in Script or
> Interactive it errors out saying cannot execute multiple quries!!!
> Is there a way to handle this?
>
> Your help is appriciated!@
> Thanks
> Deepak
>
> << File: Wipro_Disclaimer.txt >>

Jeremy Schleicher

Re: Urgent - Multiple SQL in UDB Command Center.
(in response to Srikanth (Cognizant) Chavali)
Make sure that you set a statement terminator. If not it won't understand
what the ; is. I had a problem with 7.1, the default does not use a
statement terminator.



From: "Chavali, Srikanth (Cognizant)" <[login to unmask email]>@RYCI.COM
on 12/18/2001 01:18 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: Urgent - Multiple SQL in UDB Command Center.


Hi Deepak,
You should be able to execute multiple SQL statements in
UDB Command center by ending each single statement with a semi-colon ( ; ).

Regards,
Srikanth

> -----Original Message-----
> From: Deepak Kini M [SMTP:[login to unmask email]
> Sent: Tuesday, December 18, 2001 12:07 PM
> To: [login to unmask email]
> Subject: Urgent - Multiple SQL in UDB Command Center.
>
> Dear List:
>
> Is there a way to run Multiple SQL queries in UDB Command Center?.
> We have generated SQL from ERD automatically from a tool and we need to
> create physical database using these quries for which, we are planing
> to use Script/interactive in UDB Command center.
> But further to this when I tried to execute 2 quries in Script or
> Interactive it errors out saying cannot execute multiple quries!!!
> Is there a way to handle this?
>
> Your help is appriciated!@
> Thanks
> Deepak
>
> << File: Wipro_Disclaimer.txt >>

(See attached file: InterScan_Disclaimer.txt)