Re: DB2 DDL
The DB2 z/OS documentation can be found on the Web, at http://www-01.ibm.com/support/docview.wss?rs=64uid=swg27011656 -- find the SQL Reference manual there, I recommend searching the PDF version for the CREATE STOGROUP statement. The information you are looking for is in Chapter 5, STATEMENTS, on page 1086 (p. 1112 in the PDF's own numbering system). -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Lim Ming Liang Sent: Saturday, April 07, 2012 12:33 PM To: IBM-MAIN@bama.ua.edu Subject: DB2 DDL Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
On 09-Apr-12 10:56 PM, Sevetson, Phil wrote: The DB2 z/OS documentation can be found on the Web, at http://www-01.ibm.com/support/docview.wss?rs=64uid=swg27011656 -- find the SQL Reference manual there, I recommend searching the PDF version for the CREATE STOGROUP statement. The information you are looking for is in Chapter 5, STATEMENTS, on page 1086 (p. 1112 in the PDF's own numbering system). -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Lim Ming Liang Sent: Saturday, April 07, 2012 12:33 PM To: IBM-MAIN@bama.ua.edu Subject: DB2 DDL Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. Hi Phil, I got it. Thanks. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
DB2 DDL
Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
There is a DB2 newsgroup. They can probably answer you better. Goto www.idug.org and join up Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Lim Ming Liang Sent: Saturday, April 07, 2012 9:33 AM To: IBM-MAIN@bama.ua.edu Subject: DB2 DDL Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
On 4/7/2012 10:33 AM, Lim Ming Liang wrote: Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. IBM docs on the Web; start with: http://www.ibm.com/systems/z/os/zos/bkserv/ scroll down until you see: z/OS platform publications z/OS Parallel Sysplex z/OS software products Book | PDF click on the 'PDF' link scroll down to: DB2 10 for z/OS PDFs (DISC 2) click on that link You probably want the SQL Reference, p. 1276. ... or ... we'd be happy to send our DB2 author over to Malayasia to teach some classes. :-) -- Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-355-2752 http://www.trainersfriend.com * To get a good Return on your Investment, first make an investment! + Training your people is an excellent investment * Try our tool for calculating your Return On Investment for training dollars at http://www.trainersfriend.com/ROI/roi.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
On 08-Apr-12 4:22 AM, Steve Comstock wrote: On 4/7/2012 10:33 AM, Lim Ming Liang wrote: Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. IBM docs on the Web; start with: http://www.ibm.com/systems/z/os/zos/bkserv/ scroll down until you see: z/OS platform publications z/OS Parallel Sysplex z/OS software products Book | PDF click on the 'PDF' link scroll down to: DB2 10 for z/OS PDFs (DISC 2) click on that link You probably want the SQL Reference, p. 1276. ... or ... we'd be happy to send our DB2 author over to Malayasia to teach some classes. :-) Hi Steve, Ok, let me do another search of the PDF Doc, I did try that before. I'll keep that in mind, if I hear any DB2 users here require any training I'll let you know. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
On 08-Apr-12 11:04 AM, Lim Ming Liang wrote: On 08-Apr-12 4:22 AM, Steve Comstock wrote: On 4/7/2012 10:33 AM, Lim Ming Liang wrote: Hi, I am new in DB2. Looking for the reference documentation on DB2 DDL, I am looking for the syntax of Creating Storgrp. I am searching through the IBM DVD Docs on DB2, no luck. IBM docs on the Web; start with: http://www.ibm.com/systems/z/os/zos/bkserv/ scroll down until you see: z/OS platform publications z/OS Parallel Sysplex z/OS software products Book | PDF click on the 'PDF' link scroll down to: DB2 10 for z/OS PDFs (DISC 2) click on that link You probably want the SQL Reference, p. 1276. ... or ... we'd be happy to send our DB2 author over to Malayasia to teach some classes. :-) Hi Steve, Ok, let me do another search of the PDF Doc, I did try that before. I'll keep that in mind, if I hear any DB2 users here require any training I'll let you know. FOUND that in DB2 Version 9.1 for z/OS SQL Reference, Chapter 5 Statements. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
Some of the DB/2 Redbooks are excellent if you need more info... In a message dated 4/7/2012 10:41:27 P.M. Central Daylight Time, limm...@unifi.my writes: FOUND that in DB2 Version 9.1 for z/OS SQL Reference, Chapter 5 Statements -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN
Re: DB2 DDL
On 08-Apr-12 11:43 AM, Ed Finnell wrote: Some of the DB/2 Redbooks are excellent if you need more info... In a message dated 4/7/2012 10:41:27 P.M. Central Daylight Time, limm...@unifi.my writes: FOUND that in DB2 Version 9.1 for z/OS SQL Reference, Chapter 5 Statements -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN I have a Redbook DVD, let me search for some good info there too. Thanks. -- Regards Lim ML -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN