Re: Multi command files and running them from the command prompt

#1

Use the -td§ option [where § is the desired character]. Details are in the
section titled Command Line Processor Options in the Command Reference.

"Derek Clarkson" <dclarkson (AT) waterwerks (DOT) com.au> wrote

Quote:

Hello,
I have a problem. I have a number of functions which I need to
load.
However these functions contain embedded semi-colons. For example

(1) CREATE FUNCTION REVERSE(INSTR VARCHAR(4000)) RETURNS VARCHAR(4000)
(2) begin atomic
(3) return 'ABC';
(4) end

The problem is that if I have a .sql file containing this function and run
it like this:

db2 -t -f script.sql

Then db2 gets to the semi-colon at the end of line 3 and assumes it is the
end of the create function command. Which generates an error. If I run the
script without the -t flag then DB2 gets to the end of the first line and
assumes thats it, resulting in another error.

The only way we have found to run this is to apply back slashes to each
line, resulting in:

(1) CREATE FUNCTION REVERSE(INSTR VARCHAR(4000)) RETURNS VARCHAR(4000) \
(2) begin atomic \
(3) return 'ABC'; \
(4) end

Our preferred way would be to not have the back slashes and use
semi-colons
to delimit commands. However the DB2 interpreter seems to not be able to
handle nested statements in functions like this.

How have you guys handled this situation ? any thoughts or experience
would
be appreciated.

cio
Derek.

#2

Thanks guys, -td@ worked just fine.

cio
Derek.

Derek Clarkson wrote:

Quote:

Hello,
I have a problem. I have a number of functions which I need to
load.
However these functions contain embedded semi-colons. For example

(1) CREATE FUNCTION REVERSE(INSTR VARCHAR(4000)) RETURNS VARCHAR(4000)
(2) begin atomic
(3) return 'ABC';
(4) end

The problem is that if I have a .sql file containing this function and run
it like this:

db2 -t -f script.sql

Then db2 gets to the semi-colon at the end of line 3 and assumes it is the
end of the create function command. Which generates an error. If I run the
script without the -t flag then DB2 gets to the end of the first line and
assumes thats it, resulting in another error.

The only way we have found to run this is to apply back slashes to each
line, resulting in:

(1) CREATE FUNCTION REVERSE(INSTR VARCHAR(4000)) RETURNS VARCHAR(4000) \
(2) begin atomic \
(3) return 'ABC'; \
(4) end

Our preferred way would be to not have the back slashes and use
semi-colons to delimit commands. However the DB2 interpreter seems to not
be able to handle nested statements in functions like this.

How have you guys handled this situation ? any thoughts or experience
would be appreciated.

cio
Derek.

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

Re: Multi command files and running them from the command prompt

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: Multi command files and running them from the command prompt - 08-18-2003 , 02:04 AM

Re: Multi command files and running them from the command prompt - 08-18-2003 , 09:26 PM