Change SQL Terminator for SPUFI

[Mortimer]

Hi,
I hope someone can help. I can't seem to find the answer to this
anywhere. I need to change the SQL terminator from a semicolon (;) to
an exclamation point within SPUFI in order to process a file of SQL
statements. The reason I need to make the change is the SQL contains
imbedded semicolon characters within text values. There are also
imbedded double-quotes and text values are enclosed within
single-quotes.

As far as I can tell, SPUFI will only allow me to change the default
terminator (;) to a single-quote or a double-quote. I am using SPUFI
via ISPF panels on an MVS/OS390 system. I know I can run SPUFI via
batch but I'm not sure how to tell SPUFI to change the terminator
there.

If anyone can tell me how best to accommodate this, I would surely
appreciate it. If there is another method of getting this SQL into the
DB other then SPUFI, which is as easy as SPUFI, I would entertain that
option also.

TIA,
John Wood

[Mark A]

"Mortimer" <mo**************@hotmail.com> wrote in message
news:21**************************@posting.google.c om...

Hi,
I hope someone can help. I can't seem to find the answer to this
anywhere. I need to change the SQL terminator from a semicolon (;) to
an exclamation point within SPUFI in order to process a file of SQL
statements. The reason I need to make the change is the SQL contains
imbedded semicolon characters within text values. There are also
imbedded double-quotes and text values are enclosed within
single-quotes.

As far as I can tell, SPUFI will only allow me to change the default
terminator (;) to a single-quote or a double-quote. I am using SPUFI
via ISPF panels on an MVS/OS390 system. I know I can run SPUFI via
batch but I'm not sure how to tell SPUFI to change the terminator
there.

If anyone can tell me how best to accommodate this, I would surely
appreciate it. If there is another method of getting this SQL into the
DB other then SPUFI, which is as easy as SPUFI, I would entertain that
option also.

TIA,
John Wood

There is an DB2I panel that allows you to change the SPUFI defaults,
including termination character. It should be easy to find. It is documented
in the Application Programming and SQL Guide.

[Mortimer Schnurd]

Regarding <_K*****************@news.uswest.net>
Mark A wrote:

"Mortimer" <mo**************@hotmail.com> wrote in message
news:21**************************@posting.google. com...

Hi,
I hope someone can help. I can't seem to find the answer to this
anywhere. I need to change the SQL terminator from a semicolon (;) to
an exclamation point within SPUFI in order to process a file of SQL
statements. The reason I need to make the change is the SQL contains
imbedded semicolon characters within text values. There are also
imbedded double-quotes and text values are enclosed within
single-quotes.

As far as I can tell, SPUFI will only allow me to change the default
terminator (;) to a single-quote or a double-quote. I am using SPUFI
via ISPF panels on an MVS/OS390 system. I know I can run SPUFI via
batch but I'm not sure how to tell SPUFI to change the terminator
there.

If anyone can tell me how best to accommodate this, I would surely
appreciate it. If there is another method of getting this SQL into the
DB other then SPUFI, which is as easy as SPUFI, I would entertain that
option also.

TIA,
John Wood

There is an DB2I panel that allows you to change the SPUFI defaults,
including termination character. It should be easy to find. It is documented
in the Application Programming and SQL Guide.

Thanks, but as I stated in my post, the panel only allows the use of
"default", single-quote ('), and double-quote("). And, as I stated, I
cannot use any of those.
--
John Wood a.k.a. Mortimer Schnurd
mo**************@hotTAKETHISOUTmail.com

[Mark A]

> >> Hi,

I hope someone can help. I can't seem to find the answer to this
anywhere. I need to change the SQL terminator from a semicolon (;) to
an exclamation point within SPUFI in order to process a file of SQL
statements. The reason I need to make the change is the SQL contains
imbedded semicolon characters within text values. There are also
imbedded double-quotes and text values are enclosed within
single-quotes.

As far as I can tell, SPUFI will only allow me to change the default
terminator (;) to a single-quote or a double-quote. I am using SPUFI
via ISPF panels on an MVS/OS390 system. I know I can run SPUFI via
batch but I'm not sure how to tell SPUFI to change the terminator
there.

If anyone can tell me how best to accommodate this, I would surely
appreciate it. If there is another method of getting this SQL into the
DB other then SPUFI, which is as easy as SPUFI, I would entertain that
option also.

TIA,
John Wood

There is an DB2I panel that allows you to change the SPUFI defaults,
including termination character. It should be easy to find. It is documentedin the Application Programming and SQL Guide.

Thanks, but as I stated in my post, the panel only allows the use of
"default", single-quote ('), and double-quote("). And, as I stated, I
cannot use any of those.
--
John Wood a.k.a. Mortimer Schnurd

You are looking at the SQL STRING DELIMITER on the DB2I Default Panel, and
not looking at the SPUFI Default Panel (DSNESP02).

In DB2 for OS/390 Version 7, you can change the SPUFI delimiter to any
character EXCEPT the following:

blank X'40'
comma X'5E'
double quote X'7F'
left parenthesis X'4D'
right parenthesis X'5D'
single quote X'7D'
underscore X'6D'

This is documented in the manual I referred to above. You do read manuals,
don't you? DB2 manuals can be downloaded from the IBM website.

[Mortimer Schnurd]

On Fri, 23 Jan 2004 05:36:06 -0700, "Mark A" <[e-mail]>
wrote:

>> Hi,
>> I hope someone can help. I can't seem to find the answer to this
>> anywhere. I need to change the SQL terminator from a semicolon (;) to
>> an exclamation point within SPUFI in order to process a file of SQL
>> statements. The reason I need to make the change is the SQL contains
>> imbedded semicolon characters within text values. There are also
>> imbedded double-quotes and text values are enclosed within
>> single-quotes.
>>
>> As far as I can tell, SPUFI will only allow me to change the default
>> terminator (;) to a single-quote or a double-quote. I am using SPUFI
>> via ISPF panels on an MVS/OS390 system. I know I can run SPUFI via
>> batch but I'm not sure how to tell SPUFI to change the terminator
>> there.
>>
>> If anyone can tell me how best to accommodate this, I would surely
>> appreciate it. If there is another method of getting this SQL into the
>> DB other then SPUFI, which is as easy as SPUFI, I would entertain that
>> option also.
>>
>> TIA,
>> John Wood
>
>There is an DB2I panel that allows you to change the SPUFI defaults,
>including termination character. It should be easy to find. It isdocumented >in the Application Programming and SQL Guide.
> Thanks, but as I stated in my post, the panel only allows the use of
"default", single-quote ('), and double-quote("). And, as I stated, I
cannot use any of those.
--
John Wood a.k.a. Mortimer Schnurd

You are looking at the SQL STRING DELIMITER on the DB2I Default Panel, and
not looking at the SPUFI Default Panel (DSNESP02).

In DB2 for OS/390 Version 7, you can change the SPUFI delimiter to any
character EXCEPT the following:

blank X'40'
comma X'5E'
double quote X'7F'
left parenthesis X'4D'
right parenthesis X'5D'
single quote X'7D'
underscore X'6D'

You could have stopped here and your help would have been appreciated.
But no, you had to go and be a pompous ass. How about you? Can you
read BETWEEN THE LINES. Then read this!
This is documented in the manual I referred to above. You do read manuals,
don't you? DB2 manuals can be downloaded from the IBM website.

[Mark A]

"Mortimer Schnurd" <fu**********@hotsmail.com> wrote in message
news:mi********************************@4ax.com...

You could have stopped here and your help would have been appreciated.
But no, you had to go and be a pompous ass. How about you? Can you
read BETWEEN THE LINES. Then read this!

How come my help was not appreciated the first time I answered your question
correctly?

I don't think asking people to read the manual is out of line, especially
when I point out the exact manual and chapter to look at. I would really
like to hear what explanation you have for not reading the manual that I
mentioned.