Re: IBM DB2 Version 9 for z/OS
I'd like to clarify my note to Steve which I hadn't meant to send to the list - The PA meetings are not better (how would I know if I hadn't been to Columbia), but based on topics presented in the meeting notices, the topics in Harrisburg have been more interesting to me. Didn't mean to disparage the Balt-DC DB2 users group. Jim Harrison wrote: Steve, is this for the Balt-DC DB2 user group?? I work about 15 minutes from there. I've never been to their meetings - where I live it's move convenient to attend the PA meetings in Harrisburg, which are free and usually better. But if you are presenting, I may take the day and go to Columbia. Steve Comstock wrote: I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Roland Schiradin wrote: Haven't tried but the DB2 LOAD support paths for LOB columns. Roland Dear all, Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for z/OS) a file from Unix Filesystem? I mean can a PATH parameter be given to the DD statement refering a file in a zFS instead of having a normal MVS dataset? I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] Here's a cut from the job I ran: //STEP1 EXEC DSNUPROC,UID=SCOMSTO.LOADLOB //SYSUT1 DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SORTOUT DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SYSINDD * LOAD DATA RESUME NO REPLACE CONTINUEIF(72:72)='X' INTO TABLE ITEMS (PARTNO POSITION (01) CHAR(9), DESCRIPTION POSITION (10) CHAR(30), QOH POSITION (42) INTEGER EXTERNAL(2), PICTURE POSITION (80) CHAR(30) BLOBF ) //SYSREC DD * Part00105Keys to the Kingdome 001075003483X /u/scomsto/blobs/part00105.bmp Part00240Overtime Hours00175288X /u/scomsto/blobs/part00240.bmp Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques == Check out the Trainer's Friend Store to purchase z/OS == == application developer toolkits. Sample code in four== == programming languages, JCL to Assemble or compile, == == bind and test. == == http://www.trainersfriend.com/TTFStore/index.html== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Do you really mean Kingdome? Wasn't that the stadium in Seattle that got imploded a couple of years ago. Keys to the Kingdom Alan :) -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Steve Comstock Sent: Tuesday, October 14, 2008 15:42 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: IBM DB2 Version 9 for z/OS Roland Schiradin wrote: Haven't tried but the DB2 LOAD support paths for LOB columns. Roland Dear all, Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for z/OS) a file from Unix Filesystem? I mean can a PATH parameter be given to the DD statement refering a file in a zFS instead of having a normal MVS dataset? I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] Here's a cut from the job I ran: //STEP1 EXEC DSNUPROC,UID=SCOMSTO.LOADLOB //SYSUT1 DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SORTOUT DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SYSINDD * LOAD DATA RESUME NO REPLACE CONTINUEIF(72:72)='X' INTO TABLE ITEMS (PARTNO POSITION (01) CHAR(9), DESCRIPTION POSITION (10) CHAR(30), QOH POSITION (42) INTEGER EXTERNAL(2), PICTURE POSITION (80) CHAR(30) BLOBF ) //SYSREC DD * Part00105Keys to the Kingdome 001075003483X /u/scomsto/blobs/part00105.bmp Part00240Overtime Hours00175288X /u/scomsto/blobs/part00240.bmp Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques == Check out the Trainer's Friend Store to purchase z/OS == == application developer toolkits. Sample code in four== == programming languages, JCL to Assemble or compile, == == bind and test. == == http://www.trainersfriend.com/TTFStore/index.html== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Field, Alan C. wrote: Do you really mean Kingdome? Wasn't that the stadium in Seattle that got imploded a couple of years ago. Keys to the Kingdom Alan :) No, I really meant Kingdome. Most of the stuff we teach can be a little boring so we try to slip in surprises in the data to see if anyone catches it. It's not a big laugh, but every bit helps. :-) -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Steve Comstock Sent: Tuesday, October 14, 2008 15:42 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: IBM DB2 Version 9 for z/OS Roland Schiradin wrote: Haven't tried but the DB2 LOAD support paths for LOB columns. Roland Dear all, Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for z/OS) a file from Unix Filesystem? I mean can a PATH parameter be given to the DD statement refering a file in a zFS instead of having a normal MVS dataset? I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] Here's a cut from the job I ran: //STEP1 EXEC DSNUPROC,UID=SCOMSTO.LOADLOB //SYSUT1 DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SORTOUT DD UNIT=UNIT,SPACE=(TRK,(20,20)) //SYSINDD * LOAD DATA RESUME NO REPLACE CONTINUEIF(72:72)='X' INTO TABLE ITEMS (PARTNO POSITION (01) CHAR(9), DESCRIPTION POSITION (10) CHAR(30), QOH POSITION (42) INTEGER EXTERNAL(2), PICTURE POSITION (80) CHAR(30) BLOBF ) //SYSREC DD * Part00105Keys to the Kingdome 001075003483X /u/scomsto/blobs/part00105.bmp Part00240Overtime Hours00175288X /u/scomsto/blobs/part00240.bmp Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques == Check out the Trainer's Friend Store to purchase z/OS == == application developer toolkits. Sample code in four== == programming languages, JCL to Assemble or compile, == == bind and test. == == http://www.trainersfriend.com/TTFStore/index.html== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Steve, is this for the Balt-DC DB2 user group?? I work about 15 minutes from there. I've never been to their meetings - where I live it's move convenient to attend the PA meetings in Harrisburg, which are free and usually better. But if you are presenting, I may take the day and go to Columbia. Steve Comstock wrote: I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Jim Harrison wrote: Steve, is this for the Balt-DC DB2 user group?? I work about 15 minutes from there. I've never been to their meetings - where I live it's move convenient to attend the PA meetings in Harrisburg, which are free and usually better. But if you are presenting, I may take the day and go to Columbia. Steve Comstock wrote: I have; works fine for BLOBs anyway. I'm giving a talk on it in Columbia, MD on Thursday, so I thought it'd be good to test it out. [Actually, I put the path on the data statements.] Jim, No, it's for Vicom International. It's by invitation, but you might be eligible. I'm forwarding this note to John Cress who is in charge of the program. I'm doing all morining on DB2 V9 and all afternoon on Enterprise COBOL. If you want the details, drop John a note. Tell him who you work for, since the audience is culled from his client and prospect list, so that might make a difference. If you prefer to call him, you can reach him at 410-707-9522. Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques == Check out the Trainer's Friend Store to purchase z/OS == == application developer toolkits. Sample code in four== == programming languages, JCL to Assemble or compile, == == bind and test. == == http://www.trainersfriend.com/TTFStore/index.html== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Steve Comstock wrote: - Sent that last one to the list instead of to the poster, sorry about that. Kind regards, -Steve Comstock The Trainer's Friend, Inc. 303-393-8716 http://www.trainersfriend.com z/OS Application development made easier * Our classes include + How things work + Programming examples with realistic applications + Starter / skeleton code + Complete working programs + Useful utilities and subroutines + Tips and techniques == Check out the Trainer's Friend Store to purchase z/OS == == application developer toolkits. Sample code in four== == programming languages, JCL to Assemble or compile, == == bind and test. == == http://www.trainersfriend.com/TTFStore/index.html== -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
IBM DB2 Version 9 for z/OS
Dear all, Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for z/OS) a file from Unix Filesystem? I mean can a PATH parameter be given to the DD statement refering a file in a zFS instead of having a normal MVS dataset? Thank you in advance, Best regards, Florian -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: IBM DB2 Version 9 for z/OS
Haven't tried but the DB2 LOAD support paths for LOB columns. Roland Dear all, Is it possible to use for the DB2 LOAD UTILITY (DB2 Version 9 for z/OS) a file from Unix Filesystem? I mean can a PATH parameter be given to the DD statement refering a file in a zFS instead of having a normal MVS dataset? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html