Re: to use wildcard characters in JCl
On Mon, 28 Jul 2014 17:13:22 -0700, Frank Swarbrick wrote: That's not really 'wildcarding'.� In any case, I use MacKinney Software's JES Report Broker for this.� Would be nice of the IBM FTP client had an option to append values based on symbols/variables, but it doesn't. ALLOCATE DD(INPUT) to a file and tailor that. But you lose any interaction with command status. I understand there's a Rexx API to FTP. I haven't used it. I imagine it should have all the string manipulation capability of Rexx. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
On Mon, 28 Jul 2014 23:18:16 -0500, Ed Gould wrote: I think if you need to use system symbols you need the C/I and that means no SVC 99 support either. I thought z/OS 2.1 had the ability to export symbols from JCL to the job step program(s). I've neither studied it nor tried to use it. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Based on the DFSORT example provided: you can use another way to substitute System symbols and pass the output to FTP //MODIFY EXEC PGM=EZACFSM1 //SYSINDD * ftp statements PUT 'default_file_name' LYYMMDD_LHR.LMIN..txt other ftp statements //SYSOUT DD DSN=amp;FTP,DISP=(,PASS), //SPACE=(TRK,(1,1)),UNIT=SYSALLDA, //DSORG=PS,RECFM=FB,LRECL=80 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Look at the JZOS sample program ZipDataSets. It uses Z/os catalog services and allows wild card patterns to be specified for the input datasets (passed in the parm field) which can be either MVS or HFS files. The output is a zip file which can be ftp’d http://www.ibm.com/developerworks/java/zos/javadoc/jzos/SDK7/index.html (select ZipDatasetsSource from the sidebar to see the doc) -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Rajesh Janakiraman Sent: Saturday, July 26, 2014 3:03 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: to use wildcard characters in JCl Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.zamailto:elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edumailto:lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edumailto:lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
In 019f01cfa8dd$76f35110$64d9f330$@mindspring.com, on 07/26/2014 at 07:25 AM, Lizette Koehler stars...@mindspring.com said: It might be possible to have a program (Cobol, pl/1, etc.) or script (REXX, clist, Unix Perl, etc.) generate the JCL and create the wild card function that way. ISPF File Tailoring is probably the best way to go for generating JCL. -- Shmuel (Seymour J.) Metz, SysProg and JOAT ISO position; see http://patriot.net/~shmuel/resume/brief.html We don't care. We don't have to care, we're Congress. (S877: The Shut up and Eat Your spam act of 2003) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
That's not really 'wildcarding'. In any case, I use MacKinney Software's JES Report Broker for this. Would be nice of the IBM FTP client had an option to append values based on symbols/variables, but it doesn't. From: Rajesh Janakiraman raj.janaki...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Saturday, July 26, 2014 1:02 PM Subject: Re: to use wildcard characters in JCl Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Frank: I think if you need to use system symbols you need the C/I and that means no SVC 99 support either. Ed On Jul 28, 2014, at 7:13 PM, Frank Swarbrick wrote: That's not really 'wildcarding'. In any case, I use MacKinney Software's JES Report Broker for this. Would be nice of the IBM FTP client had an option to append values based on symbols/ variables, but it doesn't. From: Rajesh Janakiraman raj.janaki...@gmail.com To: IBM-MAIN@LISTSERV.UA.EDU Sent: Saturday, July 26, 2014 1:02 PM Subject: Re: to use wildcard characters in JCl Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht - - For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM- MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: To use wildcard characters in JCL
Hi Rajesh Scheduling products are not my area of expertise but I do recall that they have symbol substitution capabilities ahead of job submission, and I think date and time options fall within their realm. If this is the case and this is a production job it may be worth talking to the Scheduling Team about what any product you have may do for you, it should negate any need for code in any language if my memories are accurate. Note that others have pointed out that wildcards are not pertinent to JCL, and in fact is an incorrect term as wildcard is generally associated with some form of filter process, whereas your require appears to be variable substitution within a DD Statement for which the correct term would be symbols (or in the IBM JCL manual Symbol Parameters) Kind Regards - Terry Director KMS-IT Limited 228 Abbeydale Road South Dore Sheffield S17 3LA UK Reg : 3767263 Outgoing e-mails have been scanned, but it is the recipients responsibility to ensure their anti-virus software is up to date. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
On Sat, 26 Jul 2014 07:25:34 -0700, Lizette Koehler wrote: If the request is to have jcl like the following, then there is no current process in z/OS JCL to do that //DD1 DD DISP=SHR,DSN=*.MYDSN.LIST Collect all datasets that end in MYDSN.LIST One can do something similar with ISPF DSLIST with pattern **.MYDSN.LIST, but performance is abysmal. I suspct that any technique that relied on catalog search would be little better. On Sat, 26 Jul 2014 16:31:11 -0500, John McKown wrote: You can do something equivalent in REXX too. But it takes two steps. And the REXX program must reside in a PDS, not be in stream. ... It has been discussed on these lists that the Rexx program can be instream by invoking IRXJCL with a member name of 8x'00'. I've not tried this; I suspect it's unsupported. I doubt that IBM would commit either to documenting it as supported or to making the code changes needed to prohibit it. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Using GDGs or PDSEs, the members of which can have long, sometimes very long, aliases would probably yield better results than these fiddles with JCL. Extracting bits and pieces of a sequential file is always possible, but it is usually neither neat nor efficient. John Gilmore, Ashland, MA 01721 - USA -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
On Sun, Jul 27, 2014 at 11:43 AM, John Gilmore jwgli...@gmail.com wrote: Using GDGs or PDSEs, the members of which can have long, sometimes very long, aliases would probably yield better results than these fiddles with JCL. Extracting bits and pieces of a sequential file is always possible, but it is usually neither neat nor efficient. Too true! But, if the OP can get it done, it is _simple_ to do with a UNIX file. Just do an ftell() when you're process runs out of data in the file. Write than value into another file. The read that checkpoint file later; do an fseek() to the offset; then process from there. I think this is what the UNIX command tail -f does. Of course, in many cases, trying to convince z/OS people to use UNIX facilities rather than legacy facilities is like trying to get me want to use Windows grin/. Just not worth the time and effort. John Gilmore, Ashland, MA 01721 - USA -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
On Sat, 26 Jul 2014 11:28:17 +0530, Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. Thanks in advance. Know more about us on www.hdfcbank.com. Connect with us on Facebook at www.facebook.com/hdfcbank Mostly, you can't. if you use PGM=BPXBATCH,PARM='SH ...' you can use shell's wildcard facilities. From what source data are you extracting? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
If you could provide us with an example of what you are looking to do it would help. z/OS has SYMBOLS, and there are ways to use UNIX. If you could show some details, it will help. In z/OS you can at a TIME Symbol that the operating system supports. Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Rajesh Janakiraman Sent: Friday, July 25, 2014 10:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: to use wildcard characters in JCl Dear Mates, If you have any idea about using wildcard characters in JCL, kindly let me know. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. Thanks in advance. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
I agree with Gil, but wlll also mention mention that the BPXBATCH he was talking about runs a UNIX program, not normal z/OS batch programs. And can only generate UNIX file names, not legacy data set names (DSN=). If you're thinking of what the Windows cmd prompt, or a UNIX shell can do, where you can wild card to match multiple files in a given directory (or folder in Windows-speak), then you simply can't do that with z/OS JCL. This wild carding is sometimes called file globbing in UNIX and z/OS JCL does not have _anything_ like that for JCL in the DSN= of a DD, or in a PARM=, or anywhere else. The closest for z/OS batch might be the LISTCAT command in the IDCAMS program, but that doesn't help you directly. And that wild carding is done by the IDCAMS program internally. There is not a z/OS system API call to do it for you. At least not directly. And, again, not in JCL. JCL is _primitive_! The best z/OS can do, and it's none too good, is what is called GDG-ALL processing. A pretty technical explanation is given here: http://www-01.ibm.com/support/docview.wss?uid=isg1II08285 A nice tutorial on GDG data sets is here: http://www.simotime.com/gdgone01.htm I include the above only for completeness, just in case you are not familiar with GDGs. On Sat, Jul 26, 2014 at 12:58 AM, Rajesh Janakiraman rajesh.janakira...@hdfcbank.com wrote: Dear Mates, If you have any idea about using wildcard characters in JCL, kindly let me know. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. Thanks in advance. Know more about us on www.hdfcbank.com. Connect with us on Facebook at www.facebook.com/hdfcbank Disclaimer: The information contained herein (including any accompanying documents) is confidential and is intended solely for the addressee(s). If you have erroneously received this message, please immediately delete it and notify the sender. Also, if you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this message or any accompanying document is strictly prohibited and is unlawful. The organization is not responsible for any damage caused by a virus or alteration of the e-mail by a third party or otherwise. Regd. Office : HDFC Bank Ltd., HDFC Bank House, Senapati Bapat Marg, Lower Parel (W), Mumbai - 400 013. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
Rajesh, there are various methods to create JCL (and parameters therein) using various programming languages, REXX being one of several possible methods. Various members of this list have favorite methods, again REXX being quite popular. How proficient are you in coding REXX? Are you proficient in any other programming languages? On Sat, 26 Jul 2014 14:02:49 -0500, Rajesh Janakiraman raj.janaki...@gmail.com wrote: Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Using Opera's mail client: http://www.opera.com/mail/ -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
The statement you provided as a sample *//PUT 'default_file_name' date_time.txt* Would not be a valid JCL statement. If this is inside your INPUT DD * statement in an FTP Jobstream, that maybe different. Perhaps if you provided the full JCL and control cards for what you are using now, it will help If you are trying to do this within the //INPUT DD statement in FTP, then you may have to find another way. The following is a sample of FTP JCL and control cards Code: //STEP1EXEC PGM=FTP,REGION=8M, // PARM='ftp site you are going to' == Destination //STEPLIB DD DSN=As your shop //SYSTCPD DD DSN=As your shop //SYSFTPD DD DSN=As your shop //SYSPRINT DD SYSOUT=* //OUTPUT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //INPUT DD * Userid password ascii cd path where you need to put the file PUT 'host file name' destination file name QUIT Or you might be using //STEP1EXEC PGM=FTP,REGION=8M, // PARM='ftp site you are going to' == Destination //STEPLIB DD DSN=As your shop //SYSTCPD DD DSN=As your shop //SYSFTPD DD DSN=As your shop //SYSPRINT DD SYSOUT=* //OUTPUT DD SYSOUT=* //SYSUT1 DD DISP=SHR,DSN=MY.OUTBOUND.DATA //SYSUT2 DD DSN=MY.INBOUND.DATA,DISP=(,CATLG,DELETE),... //INPUT DD * Userid password ascii get filename //DD:SYSUT2 put //DD:SYSUT1 filename QUIT Please show what you are trying to do Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Rajesh Janakiraman Sent: Saturday, July 26, 2014 12:03 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: to use wildcard characters in JCl Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
On Sat, Jul 26, 2014 at 2:02 PM, Rajesh Janakiraman raj.janaki...@gmail.com wrote: Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM Ah! Much easier question to answer //PS001 EXEC PGM=BPXBATCH,REGION=0M //STDOUT DD SYSOUT=* //STDERR DD SYSOUT=* //STDIN DD PATH='/dev/null', // PATHOPTS=(ORDONLY) //STDPARM DD * SH filename=$(date +'%y%m%d_%H%M') \ echo EOF \ userid \ password \ put 'INPUT.DATASET.NAME' ${filename}.txt \ EOF | ftp server_name /* // The above shows how to ftp a specific z/OS sequential dataset whose name is INPUT.DATASET.NAME into a file on the server whose file name is of the form yymmdd_hhmm.txt where the things in marks are the date and time when the step runs. You can do something equivalent in REXX too. But it takes two steps. And the REXX program must reside in a PDS, not be in stream. It would create an output DSN which you could then concatenate into the //INPUT DD statement of the FTP step later in the job. But I need to get ready to leave for a couple of hours, so I won't try to fake up the REXX program. snip -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! John McKown -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
It sounds like what he has is some sort of log file that is written to all the time and then every hour he wants to select the records written in the past hour and ftp them to somewhere else. If this is the case, he's going to need some sort of non-JCL solution. A program of some sort to read this log file and select the last hour's entries and create a temporary file which is then passed to ftp for transmission. As some have suggested, a rexx, perl, java, etc type of program, that would read a parameter indicating the period to be selected which creates a file that is transmitted. C- Charles (Chuck) Hardee Senior Systems Engineer/Database Administration CCG Information Technology Thermo Fisher Scientific 300 Industry Drive Pittsburgh, PA 15275 Direct: 724-517-2633 FAX: 412-490-9230 chuck.har...@thermofisher.com -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Rajesh Janakiraman Sent: Saturday, July 26, 2014 3:03 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: to use wildcard characters in JCl Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Regards, *Rajesh Janakiraman* -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: to use wildcard characters in JCl
If you are running your REXX in batch, any DDs and DSNs that are not coded in the JCL can be allocated (and then deallocated) in REXX itself, e.g. as: IF SYSDSN(DSN) = OK THEN ALLOC FI(||FILE||) DA(DSN) SHR (where 'DSN' exists and is generated with a date/time-stamp in it, and 'FILE' is whatever DDname this DSN is to be associated with.) Next, invoke your program from your REXX. It will use the DDs and DSNs already hard-coded in your JCL + also those allocated in your REXX. Finally, code FREE FI(||FILE||) after your program has executed and before your REXX terminates (or let MVS deallocate it for you at end of jobstep, if you prefer). Rajesh Janakiraman wrote: Hi Elardus, There is a dataset which get updated every hour in our production system, actually i need to ftp that particular dataset every one hour. For now i'm submitting the job manually by changing the date and time for every one hour. I'm not clearly aware of wildcard datasets that can be given as a input DSN in JCL. Input dataset name is same, but I need to get output using wildcard in JCL with different time on hourly basis. for example, in ftp sysin *//PUT 'default_file_name' date_time.txt* date_time.txt should be like 140727_0900.txt @ 09:00 AM If possible kindly let me know wildcard details for REXX program, this may be useful for me in future. On Sat, Jul 26, 2014 at 8:11 PM, Elardus Engelbrecht elardus.engelbre...@sita.co.za wrote: Rajesh Janakiraman wrote: If you have any idea about using wildcard characters in JCL, kindly let me know. What wildcards? Please give examples. Lizette Koehler also asked for examples/samples. I need to get an extract file for every one hour and I need to add the job in OPCA, so that by using wildcard characters for every one hour the extract may get genrated automatically. Just what wildcards for hourly works? Your request is too wide for us to interpret. is it Dataset names, input in source DD? etc? Please let me kow the detailed explanation i.e. wildcard characters that is found in JCL to describe a dataset. You cannot use wildcards in a JCL for dataset, only symbols which can be substituted by SET statements or z/OS symbols. Only possible wildcards for datasets are in RACF profiles or DFDSS statements or such and then only in SYSIN or such DD statements. You can always use Automation package or write out a REXX/Assembler/COBOl/etc program to expand wildcards to fully expanded datasets. Groete / greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN