SYSIBM.SYSDUMMYU

Srinivas Gopala

SYSIBM.SYSDUMMYU
Hi,

I need to recreate SYSIBM.SYSDUMMYU . Where will I get the create statement?
Unable to find it in DSNTIJSG.

Regards,
Srinivas G

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any damage
you may sustain as a result of any virus in this e-mail. You should carry out your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lizette Koehler

Re: SYSIBM.SYSDUMMYU
(in response to Srinivas Gopala)
If you Google SYSDUMMYU you come up with article http://ibmsystemsmag.blogs.com/db2utor/2008/04/the-origins-of.html



In that article is a reference APAR that may provide what you want.



Lizette





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of SrinivasG
Sent: Friday, December 31, 2010 9:54 AM
To: [login to unmask email]
Subject: [DB2-L] SYSIBM.SYSDUMMYU



Hi,



I need to recreate SYSIBM.SYSDUMMYU . Where will I get the create statement?

Unable to find it in DSNTIJSG.



Regards,

Srinivas G


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Jim Tonchick

Re: SYSIBM.SYSDUMMYU
(in response to Lizette Koehler)
Have you tried a full scan of SDSNSAMP using ISPF option 3.14?





-----Original Message-----
From: SrinivasG <[login to unmask email]>
To: DB2-L <[login to unmask email]>
Sent: Fri, Dec 31, 2010 8:55 am
Subject: [DB2-L] SYSIBM.SYSDUMMYU



Hi,

I need to recreate SYSIBM.SYSDUMMYU . Where will I get the create statement?
Unable to find it in DSNTIJSG.

Regards,
Srinivas G



**************** CAUTION - Disclaimer *****************
his e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
or the use of the addressee(s). If you are not the intended recipient, please
otify the sender by e-mail and delete the original message. Further, you are not
o copy, disclose, or distribute this e-mail or its contents to any other person and
ny such actions are unlawful. This e-mail may contain viruses. Infosys has taken
very reasonable precaution to minimize this risk, but is not liable for any damage
ou may sustain as a result of any virus in this e-mail. You should carry out your
wn virus checks before opening the e-mail or attachment. Infosys reserves the
ight to monitor and review the content of all messages sent to or from this e-mail
ddress. Messages sent to or from this e-mail address may be stored on the
nfosys e-mail system.
**INFOSYS******** End of Disclaimer ********INFOSYS***





The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Peter Suhner

Re: SYSIBM.SYSDUMMYU
(in response to Jim Tonchick)

If you don't find it there, check this PDF:
http://dtsc.dfw.ibm.com/MVSDS/'HTTPD2.DB2710.PUBLIC.PDF(PUT0403B)'

The default TS names have changed to SYSTSUNI for SYSDUMMYU
and SYSTSASC for the SYSDUMMYA table meanwhile.





Best regards,
Peter

_______________________
Peter
Suhner
[login to unmask email]


Please consider
the environment instead of printing this message


Date: Fri, 31 Dec 2010 16:23:09 -0500
From: [login to unmask email]
Subject: Re: [DB2-L] SYSIBM.SYSDUMMYU
To: [login to unmask email]

Have you tried a full scan of SDSNSAMP using ISPF option 3.14?












-----Original Message-----

From: SrinivasG <[login to unmask email]>

To: DB2-L <[login to unmask email]>

Sent: Fri, Dec 31, 2010 8:55 am

Subject: [DB2-L] SYSIBM.SYSDUMMYU











Hi,





I need to recreate SYSIBM.SYSDUMMYU . Where will I get the create statement?


Unable to find it in DSNTIJSG.





Regards,


Srinivas G





**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any damage
you may sustain as a result of any virus in this e-mail. You should carry out your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***








The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.







The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Frank Swarbrick

Re: SYSIBM.SYSDUMMYU
(in response to Peter Suhner)
Interesting.

Still don't understand why DB2 on z/OS does not support the values clause for a fullselect, ie:

EXEC SQL
VALUES CURRENT SERVER
INTO :current-server
END-EXEC

Just checked DB2 10, thinking I might luck out with the new release, but no dice.

I also hate the fact that when I use SYSIBM.SYSDUMMY1 I always get a translator warning:
DSNH083I DSNHSM3 LINE 26 COL 209 IBM SQL RESERVED WORD "SYSIBM" SPECIFIED AS AN IDENTIFIER NAME

Ugh!

Oh well...

Frank
--

Frank Swarbrick
Applications Architect - Mainframe Applications Development
FirstBank Data Corporation - Lakewood, CO USA
P: 303-235-1403


On 12/31/2010 at 8:46 AM, in message
<007d01cba901$f4926f50$ddb74df0$@mindspring.com>, Lizette Koehler
<[login to unmask email]> wrote:
> If you Google SYSDUMMYU you come up with article
> http://ibmsystemsmag.blogs.com/db2utor/2008/04/the-origins-of.html
>
>
>
> In that article is a reference APAR that may provide what you want.
>
>
>
> Lizette
>
>
>
>
>
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of SrinivasG
> Sent: Friday, December 31, 2010 9:54 AM
> To: [login to unmask email]
> Subject: [DB2-L] SYSIBM.SYSDUMMYU
>
>
>
> Hi,
>
>
>
> I need to recreate SYSIBM.SYSDUMMYU . Where will I get the create statement?
>
> Unable to find it in DSNTIJSG.
>
>
>
> Regards,
>
> Srinivas G
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information.
> *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> Mentoring should be a rewarding experience for everyone...
> IDUG is offering up to 80% off when you both come to the conference!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's Listserv

>>>

The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Frank Swarbrick

Re: SYSIBM.SYSDUMMYU
(in response to Frank Swarbrick)
Well, since I can't retract it...

I guess this *is* supported, using VALUES INTO:
EXEC SQL
VALUES (CURRENT SERVER)
INTO :current-server
END-EXEC

Maybe it's just not supported in dynamic SQL?
Hmmm, I'll have to research futher.
After removing foot from mout.


On 12/31/2010 at 5:34 PM, in message <[login to unmask email]>,
Frank Swarbrick <[login to unmask email]> wrote:
> Interesting.
>
> Still don't understand why DB2 on z/OS does not support the values clause
> for a fullselect, ie:
>
> EXEC SQL
> VALUES CURRENT SERVER
> INTO :current-server
> END-EXEC
>
> Just checked DB2 10, thinking I might luck out with the new release, but no
> dice.
>
> I also hate the fact that when I use SYSIBM.SYSDUMMY1 I always get a
> translator warning:
> DSNH083I DSNHSM3 LINE 26 COL 209 IBM SQL RESERVED WORD "SYSIBM" SPECIFIED
> AS AN IDENTIFIER NAME
>
> Ugh!
>
> Oh well...
>
> Frank

>>>

The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv