SEO

#1 (**permalink**) 02-28-2008, 05:01 AM

All the time I'm working with DB2 I feel that DB2 authers just hate
their customers and users of their products...

The last example - I want to create a stored procedure in the script,
use it to add data to database inside this script and then drop this
procedure. And I want this script be able to run as a script and also
just copied to Command Editor.

But it is impossible!

You just cannot change statement termination char by something like
UPDATE COMMAND OPTIONS -t @! Statement termination char can be defined
only before the whole script execution - either in db2 -td @ or in
spetial options of the editor you are using. What a hell...

I hope I'm wrong. Does anybody know how to solve it?

#2 (**permalink**) 02-28-2008, 05:01 AM

bespridannik@gmail.com wrote:
> You just cannot change statement termination char by something like
> UPDATE COMMAND OPTIONS -t @! Statement termination char can be defined
> only before the whole script execution - either in db2 -td @ or in
> spetial options of the editor you are using. What a hell...
>
> I hope I'm wrong. Does anybody know how to solve it?
--#SET TERMINATOR @

I will contact the ID folks....

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3 (**permalink**) 02-28-2008, 05:01 AM

Serge Rielau wrote:
> bespridannik@gmail.com wrote:
>> You just cannot change statement termination char by something like
>> UPDATE COMMAND OPTIONS -t @! Statement termination char can be defined
>> only before the whole script execution - either in db2 -td @ or in
>> spetial options of the editor you are using. What a hell...
>>
>> I hope I'm wrong. Does anybody know how to solve it?
> --#SET TERMINATOR @
http://publib.boulder.ibm.com/infoce...c/r0010410.htm

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#4 (**permalink**) 02-28-2008, 01:59 PM

On Feb 28, 2:50*am, Serge Rielau <srie...@ca.ibm.com> wrote:
> Serge Rielau wrote:
> > bespridan...@gmail.com wrote:
> >> You just cannot change statement termination char by something like
> >> UPDATE COMMAND OPTIONS -t @! Statement termination char can be defined
> >> only before the whole script execution - either in db2 -td @ or in
> >> spetial options of the editor you are using. What a hell...
>
> >> I hope I'm wrong. Does anybody know how to solve it?
> > --#SET TERMINATOR @
>
> http://publib.boulder.ibm.com/infoce...ic/com.ibm.db2....

Thank you for help!

And it works in DB2 CLP also as in Command Editor!

Example:

Next commands can be executed in DB2 CLP also as in Command Editor:

--#SET TERMINATOR ;
select count(*) from user;
select count(*) from user;
--#SET TERMINATOR %
select count(*) from user%
select count(*) from user%
--#SET TERMINATOR ;
select count(*) from user;
select count(*) from user;

> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

#5 (**permalink**) 02-28-2008, 01:59 PM

Bespridannik wrote:
> On Feb 28, 2:50 am, Serge Rielau <srie...@ca.ibm.com> wrote:
>> Serge Rielau wrote:
>>> bespridan...@gmail.com wrote:
>>>> You just cannot change statement termination char by something like
>>>> UPDATE COMMAND OPTIONS -t @! Statement termination char can be defined
>>>> only before the whole script execution - either in db2 -td @ or in
>>>> spetial options of the editor you are using. What a hell...
>>>> I hope I'm wrong. Does anybody know how to solve it?
>>> --#SET TERMINATOR @
>> http://publib.boulder.ibm.com/infoce...ic/com.ibm.db2....
> And it works in DB2 CLP also as in Command Editor!
I admit I wasn't sure about the command editor ;-)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Why DB2 developers could not make it possible to change statementtermination character dynamically?