V6 - Cursor names with dashes

Suresh Sane

V6 - Cursor names with dashes
Hello list,

I recall reading that V6 (DB2 UDB OS/390)would disallow cursor names with
dashes. The SQL Ref manual states that it can a "long identifier"
containing alphabetic, digits and underscore (only?). We are on May Refresh
tape and finding that cursor names with dashes are indeed allowed -
precompile of new sql as well as bind of an existing dbrm still work. Was
this fixed along the way somewhere or was my orifinal info incorrect?

Any input would be appreciated.

Thanks,
Suresh


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



Walter Janißen

Re: V6 - Cursor names with dashes
(in response to Suresh Sane)
We've had problems with dashes in cursor-names in Version 5 only when we
did a remote bind and we had to change all programs using cursor names with
dashes, because all our production binds are remote.

But if I remember it rigth there was a PTF for version 6 which does allow
dashes in SQL-identifiers even for remote bind. I think if I'm not rigth,
someone will correct me.

Hope this helps



Tim Lowe

Re: V6 - Cursor names with dashes
(in response to Walter Janißen)
Walter,
You are correct, Apar PQ31209 / V6 PTF UQ36980 resolves the problem with
remote bind of Cobol programs that contain hyphen in cursor identifiers.




Walter Janissen
<[login to unmask email] To: [login to unmask email]
CTORIA.DE> cc:
Sent by: DB2 Data Subject: Re: V6 - Cursor names with dashes
Base Discussion
List
<[login to unmask email]>


01/05/2001 05:00 AM
Please respond to
DB2 Data Base
Discussion List






We've had problems with dashes in cursor-names in Version 5 only when we
did a remote bind and we had to change all programs using cursor names with
dashes, because all our production binds are remote.

But if I remember it rigth there was a PTF for version 6 which does allow
dashes in SQL-identifiers even for remote bind. I think if I'm not rigth,
someone will correct me.

Hope this helps








Suresh Sane

Re: V6 - Cursor names with dashes
(in response to Tim Lowe)
Walter & Tim - Thanks for the update.

I am still confused about IBM's long term direction on this. The SQL Ref
says that only alpha/digits/underscore are allowed in a long identifier. We
will be OK with the PTF but will IBM be disabling such support in the
future? If so, I want to clean those we have and prevent any future
programs containing cursors with dashes. If not, perhaps the manual should
be changed? Will local binds be OK all the time?

Any help, especially from IBM, would be appreciated.

Thanks,
Suresh


>From: [login to unmask email]
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: V6 - Cursor names with dashes
>Date: Fri, 5 Jan 2001 09:29:34 -0600
>
>Walter,
>You are correct, Apar PQ31209 / V6 PTF UQ36980 resolves the problem with
>remote bind of Cobol programs that contain hyphen in cursor identifiers.
>
>
>
>
> Walter Janissen
> <[login to unmask email] To: [login to unmask email]
> CTORIA.DE> cc:
> Sent by: DB2 Data Subject: Re: V6 -
>Cursor names with dashes
> Base Discussion
> List
> <[login to unmask email]>
>
>
> 01/05/2001 05:00 AM
> Please respond to
> DB2 Data Base
> Discussion List
>
>
>
>
>
>
>We've had problems with dashes in cursor-names in Version 5 only when we
>did a remote bind and we had to change all programs using cursor names with
>dashes, because all our production binds are remote.
>
>But if I remember it rigth there was a PTF for version 6 which does allow
>dashes in SQL-identifiers even for remote bind. I think if I'm not rigth,
>someone will correct me.
>
>Hope this helps
>
>
>
>
>
>
>
>
>
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com