[SPAM] Re: SYSIBM.SYSDUMMYU

Daniel Luksetich

[SPAM] Re: SYSIBM.SYSDUMMYU
Yeah, VALUES is only supported in the body of a trigger on z/os.
Dan

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Frank Swarbrick
Sent: Friday, December 31, 2010 6:38 PM
To: [login to unmask email]
Subject: [SPAM] Re: SYSIBM.SYSDUMMYU

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
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.872 / Virus Database: 271.1.1/3350 - Release Date: 12/31/10
01:34:00

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Srinivas Gopala

Re: SYSIBM.SYSDUMMYU
(in response to Daniel Luksetich)
Hi,

Thanks to all who replied. I found the DDLs in DSN910.SDSNSAMP(DSNATMMC).



Regards,
Srinivas G

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Peter Suhner
Sent: Saturday, January 01, 2011 5:58 AM
To: [login to unmask email]
Subject: Re: [DB2-L] SYSIBM.SYSDUMMYU

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]<mailto:[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***


________________________________
[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org/ >
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________
[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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