Re: DFSort query

2024-05-22 Thread Ron Thomas
My Apologies Kolusu for wrong details inputted Thanks Much for the sample job and it is working good for my requirement. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

DFSort query

2024-05-21 Thread Ron Thomas
Hi All- In the below Data we need to extract with in the cross ref nbr , if seq Nbr =1 get Pacct_NBR and its related acct nbrs from the set In the below dataset for cross ref nbr = 24538 we have 2 sets of data and 24531 we have 1 set . Acct _NBR Pacct_NBR LAST_CHANGE_TS

DFsort error message

2024-03-26 Thread Ron Thomas
Hi All - We are getting a sort error on a huge file . Below are the details from log Parm cards used SORT FIELDS=COPY Error Log details ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT SELECTED ICE252I 1 PARMLIB OPTIONS WERE MERGED WITH INSTALLATION MODULE DEFAULTS

Re: Dfsort Overlay error

2023-08-14 Thread Ron Thomas
Thanks a lot Kolusu. Sorry i didn't articulate what is documented in the user guide in the right way . Anyway thanks again for all the help .. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions,

Re: Dfsort Overlay error

2023-08-11 Thread Ron Thomas
Hi Kolusu - Here is what i am getting . Could you please let me what changes to be made ? ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4 - 13:36 ON FRI AU OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'',

Re: Dfsort Overlay error

2023-08-11 Thread Ron Thomas
Thanks Kolusu for sharing the link . still i am not able to figure out the same . Modified as below and still not working OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'', AND,25,10,CH,GT,X''), OVERLAY=(35:25,10,Y4T,ADDDAYS,+120))

Dfsort Overlay error

2023-08-11 Thread Ron Thomas
Hi - I have a file of LRECL 44 and need to overlay a date in Position 35 by adding 120 days to the date at position 25 The overlay to be done based also on condition . Coded as below OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'',

Re: Soc7 abend

2023-01-12 Thread Ron Thomas
ok Jay. so, what you say is if the definitions are as below then we should be good. The '-' sign is part of the variable name in spool display. 05 INP-VNDR-PACK-COST PIC 9(9)V9(2). 05 WS-VNDR-PACK-COST PIC S9(9)V9(2) COMP-3. Regards Ron T

Soc7 abend

2023-01-12 Thread Ron Thomas
Hi Listers I was looking a Cobol code module developed and we ran in to a sco7 issue. I am not able to figure why this is abending. Any help to fix is much appreciated. Here is the spool display i have captured. 05 INP-VNDR-PACK-COST PIC 9(9)V9(4). 05 WS-VNDR-PACK-COST PIC

dfsort - Reformat file

2022-09-05 Thread Ron Thomas
Hi , We have a input PIPE DELIMITED file as follows of lrecl = 80. Need to remove the leading spaces with out disturbing the 3 column values 1652087|..0049|..OPTICAL |..0170| 2130994|..0006|..STATIONERY |..0716| 2199447|..0078|..SERVE OVER PIZZA|..0410|

Re: DFSort Create Filename

2022-06-21 Thread Ron Thomas
Thanks a lot Kolusu. it worked like a charm !! Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSort Create Filename

2022-06-20 Thread Ron Thomas
My sincere apologies Kolusu . I have updated the answers in-line >> If header comes in to this file for whatever reason we need to skip and >> then build this filename Q. How do you distinguish the header ? Any indicator? You don't even show a sample. ***Header if comes will start

DFSort Create Filename

2022-06-20 Thread Ron Thomas
Hello - We have a input file as follows. * Top of Data * .0050425063|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .0050996097|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .0009077849|..4138|..12211|..1.50|..1.50|..

Re: dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K

2022-06-10 Thread Ron Thomas
Hi edjaffe - I am not sure how to make that changes in then job . would you be able to let me know what changes i should make in the job ? Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send

dfsort -TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K

2022-06-10 Thread Ron Thomas
Hello - We are splitting a very large files in to 750 files dynamically based on key , which means if the key changes the file is moved to the respective ones we are getting the message STEPBB - TASK I/O TABLE EXCEEDS TIOT LIMIT OF 0064K STEPBB - STEP WAS NOT EXECUTED. and hence the step is

Re: DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Ron Thomas
Thanks a lot Massimo. It worked like a charm :) Thanks, Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Ron Thomas
Hi - We have a Input file of LRECL =80 as below 105_1_10893_1_28 1_10893_1_28 FAMILY SHARE CRISPS 1_10893_1_28 10893_1_28 SHARING CRISPS 10893_1_28 1_28 SHARING CRISPS 1_28 28

Re: DFSORT Header + Detail count match

2020-12-14 Thread Ron Thomas
Thanks a lot Kolusu. It worked great . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

DFSORT Header + Detail count match

2020-12-11 Thread Ron Thomas
Hi, We are getting 1 3rd part file with the layout as follows. Here in header 1-17 bytes is the count followed by Pipe & Date. The Rest of the lines is the detail lines . The process should not proceed if the count in header is not matching with the detail line count.

Re: SFTP Sortcard creating using DFSORT

2020-12-09 Thread Ron Thomas
Thanks a lot Kolusu .. Regards Ron -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: SFTP Sortcard creating using DFSORT

2020-12-09 Thread Ron Thomas
Thanks a lot Kolusu.. it worked like a charm ! Could you please help me to understand the below card as to how it is picking the store_nbr and create NREC PARSE=(%=(REPEAT=2,ENDAT=C'}'), %01=(ENDBEFR=C'{', ENDBEFR=C' ', FIXLEN=8)),

SFTP Sortcard creating using DFSORT

2020-12-08 Thread Ron Thomas
Hello- I am creating a dynamic SFTP sortcard using DFSORT, here in the Input file the Store_nbr is at position 40. I need the file to created as SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_33.csv but the issue is the store_nbrs are of different length, the .csv is not

Re: dfsort remove spaces

2020-10-09 Thread Ron Thomas
paul- this was a typo error , what the output i got from my control card is below 645|CASILLERODELDIABLO|VHOCASILLERODIABLO| Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: dfsort remove spaces

2020-10-09 Thread Ron Thomas
Anthony - The file has data as below also 000657|VHO TRIVENTO RESERVA |MALBEC 750ML 007762|FJAO PTO CAMIL |T1 1KG 007762|FJAO PTO CAMIL |T1 1KG 007762|FJAO PTO CAMIL |T1 1KG 007762|FJAO PTO CAMIL |T1 1KG 007762|FJAO PTO CAMIL

Re: dfsort remove spaces

2020-10-08 Thread Ron Thomas
thanks a lot Massimo . it worked great !! Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

dfsort remove spaces

2020-10-08 Thread Ron Thomas
Hello I have a sample file as below and we would need to remove the spaces 000645|VHO CASILLERO DIABLO |PINOT NOIR 750ML | 000645|VHO CASILLERO DIABLO |PINOT NOIR 750ML | 000645|VHO CASILLERO DIABLO |PINOT NOIR 750ML | 000645|VHO CASILLERO

Re: dfsort file split

2020-10-07 Thread Ron Thomas
Thanks a lot Kolusu.. it worked like a charm :) mazimo- the solution provided did not work for me . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with

dfsort file split

2020-10-07 Thread Ron Thomas
Hello- i have a file which has a header and detail records , i want to split the file based on value and here below is the one i have coded //SPLITEXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=PYU678S.ITR1.FUTR.RTLDTA.UNLOAD,DISP=SHR //OUT01DD SYSOUT=* //OUT02DD SYSOUT=*

Re: DFSort to pull the latest record date

2020-09-25 Thread Ron Thomas
Thanks a lot Kolusu for the help.. it worked like a charm!! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

DFSort to pull the latest record date

2020-09-25 Thread Ron Thomas
Hello We are using DFSORT utility to extract the latest record for a store/item/po and below is the sample file item_nbr| Store_nbr|Po_nbr|item_date|mode| 00604|9137|1100276393|2017-12-26|7|DSD | 00604|9137|1100278550|2018-01-09|6|DSD | Here we need to pull the 2'nd record

Re: sort join keys not correctly working

2020-09-02 Thread Ron Thomas
Thanks a Lot Kolusu for the information . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

sort join keys not correctly working

2020-09-01 Thread Ron Thomas
Hello We are using DFSORT and we have a input file as follows File- 1 (key 12 bytes) 998962 998969 998976 99905 99921 0001 0002 0003 0006 0007 0016 0019 0073 0092 File -2 (key 12 bytes 2 73 18 100907

Re: Sort Jcl to build a Update table control card

2020-07-02 Thread Ron Thomas
Thanks a bunch Kolusu.. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Sort Jcl to build a Update table control card

2020-07-01 Thread Ron Thomas
ok thanks a lot Kolusu.fyi , we are using DFSORT and not Syncsort . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Sort Jcl to build a Update table control card

2020-07-01 Thread Ron Thomas
Hello We have input file with around 6500 rows as below and would need to build a control card to update the DB US1234567897272 -(1st 2 bytes countrycode,next 9 bytes item number ,next 4 bytes PLU nbr) I need to generate a SQL UPDATE code generator like below. ("?" need to be pulled from the

Re: SFTP Get

2020-02-06 Thread Ron Thomas
this is what we use here ,so how is this we need to handle ? //STEP02 EXEC PGM=BPXBATSL,REGION=0M, // PARM='PGM /usr/lpp/ssh2/bin/sftp2 // -B //DD:BATCHIN' //SYSTSPRT DD SYSOUT=* //STDOUT DD SYSOUT=* //STDENV DD DSN=SYS1.TECSSH.PARMLIB(SSHENV),DISP=SHR

Re: SFTP Get

2020-02-06 Thread Ron Thomas
it is IBM z/OS SFTP -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

SFTP Get

2020-02-06 Thread Ron Thomas
Hello. We have a a job that runs every 30 mins , this job will pulls a text file from a windows server and loads to the Mainframe dataset . In some-cases the file is not present and FTP step fails . I need to set this to a normal completion even if the file is not present . Please let me

SFTP Special Charcters

2019-09-19 Thread Ron Thomas
Hello we are doing a SFTP from Mainframe to Windows machine (EBCDIC to ASCII) using reflection FTP client and we are seeing some special characters in the file is getting translated to others . For e.g Á (x'65') to 'Ý' x'AD' Is there a way we can keep this data ASIS during the ftp ? if so

Re: Email report from jcl

2019-08-12 Thread Ron Thomas
Ok Tony. But still the contents gets attached to the attachment . Thanks. Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Email report from jcl

2019-08-09 Thread Ron Thomas
Done as below , but still no changes. The below txt gets in the attached file // DD * --SIMPLE BOUNDARY CONTENT-TYPE: TEXT/PLAIN CONTENT-DISPOSITION: ATTACHMENT --SIMPLE BOUNDARY-- Thanks Ron T -- For IBM-MAIN subscribe

Re: Email report from jcl

2019-08-09 Thread Ron Thomas
ok. i checked now and there is no message like EZD1816I in job log. Thanks! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Email report from jcl

2019-08-09 Thread Ron Thomas
i have changed now to as below MIME-VERSION: 1.0 CONTENT-TYPE: TEXT/PLAIN CONTENT-DISPOSITION: ATTACHMENT; FILENAME=DIVRGRPT.TXT but still the below is getting written in the attachment --SIMPLE BOUNDARY CONTENT-TYPE: TEXT/PLAIN CONTENT-DISPOSITION: ATTACHMENT; Thanks Ron T

Email report from jcl

2019-08-09 Thread Ron Thomas
Hi All. i am only getting the file attached correctly when i am giving the below and then this text is going to get embed in the file also. Is there any other to do the same ? I don't want this contents to be attached when the user receives the report . The LRECL of the files is 4500 //

Re: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Thanks a lot Kolusu.. You are amazing to say the least !!! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: dfsort: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Ok Elardus. I will paste the requirement and output files generated again We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference.

Re: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Ok Kolusu, will remove dfsort tag from subject line . Thanks again for providing the steps. Here is what i have done //STEP03 EXEC SORT //SORTIN DD * 50338 789997580026.00 36052910 DF 96.12 50338 789997580026.00 36052910 DF 96.12

dfsort: Sort job to get price variance records

2019-07-31 Thread Ron Thomas
Hi. We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference. Could anyone let me know how this to be done using dfsort. Input file

Re: Sort - File split

2019-05-22 Thread Ron Thomas
Thanks a lot Kolusu, this is brilliant!! Thanks to all others also for all of your suggestions . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

Re: Sort - File split

2019-05-22 Thread Ron Thomas
Ron what i am looking is extract from the input file 100 PO's . as i told first 10 bytes of the file is the PO number and each PO can contain one record or multiple records. The idea is to extract 100 PO with the all the PO related information which resides in multiple records. Thanks Ron T

Re: Sort - File split

2019-05-21 Thread Ron Thomas
Ron, I don't need a single record per P.O, what i need is pull 100 P.O in the output file . A P.O will contain multiple records for e.g if each PO has 5 rows then the ouput will be 500. I put something like the below but this is not working SORT FIELDS=COPY INREC

Re: Sort - File split

2019-05-21 Thread Ron Thomas
Ron . what i need is copy 100 PO numbers details to a new file . One P.O has multiple rows . I don't think that will work Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Sort - File split

2019-05-21 Thread Ron Thomas
Hi . i have FB file with lrecl 5000 and here below is layout. key is first 11 bytes PO number 102016| 31859949 || 1613QTTR| 1 102016| 31859949 || 1613QTTR| 1 102016| 31859949 || 1613QTTR| 1 102016

Re: Appending timestamp to the file

2019-05-03 Thread Ron Thomas
Ok thanks Kolusu. That worked .. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Appending timestamp to the file

2019-05-03 Thread Ron Thomas
Hi . We are appending the timestamp to a CSV file and when we do the same we see the microsecond part is different for all the rows . Is there a way to make it same for all of the rows ? Here below is the control card we used OUTREC PARSE=(%01=(ENDBEFR=C'|',FIXLEN=4),

Re: Sort (numbering multiples)

2019-04-30 Thread Ron Thomas
Thanks a ton Kolusu .. I was able to work it out. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Sort (numbering multiples)

2019-04-30 Thread Ron Thomas
Hi Kolusu, Here is the actual production files data , 102,3522850,15,FF,9 202,3522850,15,FF,9 102016,3522850,15,FF,9 104152,3522850,15,FF,7 104152,3522850,15,FF,9 104760,3521499,15,FF,9 104760,3521499,15,FF,9 106735,3507181,15,FF,9 989898989,3507181,15,FF,9 989898989,3507181,15,FF,9 so the o/p

Re: Sort

2019-04-30 Thread Ron Thomas
Thanks Kolusu. Let me look in to that and see how it can be done. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Sort

2019-04-30 Thread Ron Thomas
Hi . We have a below CSV file and here we need to generate a number in the 1st column based on whether there is duplicates on the 2nd column. 102016,3522850,15,FF,9 104152,3522850,15,FF,7 104152,3522850,15,FF,9 104760,3521499,15,FF,9 104760,3521499,15,FF,9 106735,3507181,15,FF,9 so the o/p

Re: dfsort

2019-04-24 Thread Ron Thomas
Brilliant Kolusu ! Many Thanks !! Thanks again for all .. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: dfsort

2019-04-24 Thread Ron Thomas
Thanks a lot Massimo ! this is excellent . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: dfsort

2019-04-23 Thread Ron Thomas
Correct Elardus, I am awaiting Kolusu reply as to whether this can be achieved using sort. if not, other option is to do using as program . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send

Re: dfsort

2019-04-23 Thread Ron Thomas
Kolusu - sorry they should also be picked , we shouldn't be picking item_nbr that have other locations defined which means extract items have only in location "CORPORATIVO" Thanks Ron T -- For IBM-MAIN subscribe / signoff /

dfsort

2019-04-23 Thread Ron Thomas
Hi - We have a file that is received from a vendor ( item_nbr 10 byes and location 20 bytes) . File is a 80 byte FB record item_nbrlocation 4046340¦CORPORATIVO 4046564¦CORPORATIVO 4046564¦ESTADO 4047131¦CORPORATIVO 4047460¦CORPORATIVO 4047479¦CORPORATIVO Here we need to extract item_nbrs

Re: XML File to MQ

2019-03-06 Thread Ron Thomas
Thanks Grant for the info. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: XML File to MQ

2019-03-05 Thread Ron Thomas
Thanks Allan for your thoughts . -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

XML File to MQ

2019-03-05 Thread Ron Thomas
Hi . I am working in one of the data migration projects where are sending item related details to a 3'rd party system . We have around 300K items and we are planning to send through a XML file in 4 batches . One Item has got around 400 lines of information. So our question is it ok to send

Re: jcl remove leading zeros and spaces

2019-03-04 Thread Ron Thomas
My apologies on not putting the full details . Thanks a lot Kolusu . will try and see how it works. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with

Re: jcl remove leading zeros and spaces

2019-03-04 Thread Ron Thomas
Hi Kolusu, Can you show me how to do the same ? Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

jcl remove leading zeros and spaces

2019-03-04 Thread Ron Thomas
Hi . We have a below PIPE delimited file , let me know how to remove the leading zeros and spaces zeros from this file ? 102016|0031859949|00|1613QTTR|1| 1995-11-13|01|8.|C|75| 019.| Thanks in Advance Regards Ron T

jenkins IDE

2017-12-22 Thread Ron Thomas
Hello . We are planning to implement jenkins in to our QA mainframe environment . Is there any document where i can look and see how to configure our mainframe regions to jenkins . The objective is we should we able to submit jobs and build code from jenkins ? Is there any one in the list who

Re: JCL to get a report of large datasets

2017-08-02 Thread Ron Thomas
Thanks everyone for the valuable information . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: JCL to get a report of large datasets

2017-08-01 Thread Ron Thomas
Can i get a sample job or so to pull the information based on the high-level qualifier of dataset ? Thanks! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

JCL to get a report of large datasets

2017-08-01 Thread Ron Thomas
Hi . Is there using utility job where i can use it pull all datasets that occupy huge space . Let me know how i can go ahead and do it .? Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
Ok both the statements are working , as i have put the continuation character wrongly . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message:

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
Thanks a lot . it worked ! Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
I have given as below, but still the issue is there SELECT FROM(SORTIN) TO(SORTF1) ON(16,50,CH) DISCARD(SORTF2) FIRST - USING(CTL1) Thanks, Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

DFSORT Error message

2017-06-02 Thread Ron Thomas
Hello . I am trying to extract unique invoice numbers to a file using DFSORT ,ICETOOL and below is my control card.n The o/p i want to reformat it. I am getting the below error messages. could someone let me know where the issue is ? //TOOLINDD * SELECT FROM(SORTIN) TO(SORTF1)

Re: rename datasets

2017-05-11 Thread Ron Thomas
Thanks a lot john . it worked . -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: rename datasets

2017-05-11 Thread Ron Thomas
Thanks John . I am new to Rexx , but just wanted to know how in the below code, we make sure that only what is in my input file is read and renamed and not all the datasets under the SLXR5V.SAPDB.* ? /* REXX */ XX=OUTTRAP('DATA.','*') LISTC LVL('SLXR5V.SAPDB​') XX=OUTTRAP("OFF") DO I=1 TO

Re: rename datasets

2017-05-10 Thread Ron Thomas
Also, all of the files that need to renamed is there in a file . We want only those in the file to be renamed . Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: rename datasets

2017-05-10 Thread Ron Thomas
we are looking at renaming all of the datasets like the below. Old dataset - > SLXR5V.SAPDB.* New dataset - > SLXR5V.SAPDB.X.* Thanks Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

rename datasets

2017-05-10 Thread Ron Thomas
Hi . We have around 700 datasets where we need to rename the names , is there a utility by which we can run the same in batch ? I believe i can use IDCAMS , but is there a better way to it with less effort ? Regards Ron T

Re: SFTP From Linux to z/OS

2017-05-04 Thread Ron Thomas
Thanks for all the inputs , if we code as below is it possible to capture space related issues ? when i tried to give volume parameter it is not allowing , which made me think that script does not allow multi volume allocation . Correct me if i am wrong here ? ls

Re: SFTP From Linux to z/OS

2017-05-02 Thread Ron Thomas
Hi Kirk Here is the script & the error message i am getting . Kindly let me know is there anything wrong here ? ls /+mode=text,lrecl=3000,recfm=vb,space=cyl.100.100 put /sap/input/sample.txt //'KG99KVT.FXN.MXCROT.TOT(+1)' quit ls: cannot access

SFTP From Linux to z/OS

2017-05-02 Thread Ron Thomas
Hi . One of my colleagues told me from Linux script ,we can do SFTP using the below file allocation . Just wanted to know whether this possible ? As per my understanding this has no significance ? Also, whether from virtual machine we can put to a tape GDG file ? ls

Re: FTP Failing with space issues

2017-04-27 Thread Ron Thomas
we are looking at copy the file to a GDG, once it reaches the z/OS directory using the below job. so what i am looking is how we can automate this job so once file reaches the unix directory it copies and delete the source ? //COPYSTEP EXEC PGM=IKJEFT01 //FILE DD

Re: FTP Failing with space issues

2017-04-27 Thread Ron Thomas
Thanks for all the suggestions , Also, i would like to know how we can trigger the copy from the z/OS UNIX directory to a data set as soon the file arrives in the unix directory from the linux VM? Regards Ron T -- For

Re: FTP Failing with space issues

2017-04-25 Thread Ron Thomas
The criteria we are planning is the files which are more than 30 days old (Creation Date). Thanks! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message:

Re: FTP Failing with space issues

2017-04-25 Thread Ron Thomas
We finally decided to move the files to Z/OS unix , we plan to create a monthly folder to which we push all the files from linux VM. Once the file is there we will move back to GDG's . I have a query here , is there any job which i can use to clean up the files in the z/os unix folder . Please

Re: FTP Failing with space issues

2017-04-24 Thread Ron Thomas
with the modified one like "quote site blocksize=0 lrecl=3000 recfm=fb wrap prim=25 sec=25 cyl" it is showing the same error. Thanks! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: FTP Failing with space issues

2017-04-24 Thread Ron Thomas
i executed the below script from Linux VM and the below is what it says. Looks like site command is not supported . So any idea on how this could be resolved or is there any work around ? Script --- sftp to1c...@cray.cps.se.com << EOF site blocksize=0 lrecl=3000 recfm=fb prim=25

Re: FTP Failing with space issues

2017-04-21 Thread Ron Thomas
Ok what you say is that we can do like the one below . is that what you are referring ? SITE BLOCKSIZE=0 LRECL=133 WRAP RECFM=FB PRI=20 SEC=10 CYL put unix_file.txt 'HLQ.MAINFRAME.FILE(+1)' (replace Thanks Ron T -- For

Re: FTP Failing with space issues

2017-04-21 Thread Ron Thomas
Ok . i tried to copy a csv file that is there in the shell and i am getting the below message . I tried increasing the LRECL of the PDS file and still the same issue . Any idea on what could be the issue here ? $ cp -T SN_ASC00_03212017.csv "//'ng772pt.X.Y.Z'" cp: FSUM6260 write error on file

Re: FTP Failing with space issues

2017-04-21 Thread Ron Thomas
Ok , in that case if on the mainframe side has a file system setup , then they can send the file and from there we can copy back a PDS location. I need to understand whether there is any limitation on the number of files send or any memory constraints ? is that the best approach ? I am new

Re: FTP Failing with space issues

2017-04-20 Thread Ron Thomas
No i haven't thought about that as i am not sure how to do that . Thanks! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP Failing with space issues

2017-04-20 Thread Ron Thomas
Ok , whaat i am looking is to push the file from LINUX to Mainframe . So, the one below is fine ? SITE BLOCKSIZE=0 LRECL=133 WRAP RECFM=FB PRI=1 SEC=1 CYL delete 'HLQ.MAINFRAME.FILE' put linux_file.txt //'HLQ.MAINFRAME.FILE' Thanks Ron T

Re: FTP Failing with space issues

2017-04-20 Thread Ron Thomas
Ok. is the below one coded will work from linux LOCSITE BLOCKSIZE=0 LRECL=133 WRAP RECFM=FB PRI=1 SEC=1 CYL delete 'HLQ.MAINFRAME.FILE' get linux_file.txt 'HLQ.MAINFRAME.FILE' (replace Thanks Ron T -- For IBM-MAIN subscribe

Re: FTP Failing with space issues

2017-04-20 Thread Ron Thomas
So just wanted to understand , whether we can delete the file that is existing and then allocate the file from the virtual machine shell script ? if so how we can do the same , so we can get the correct data in mainframe with out FTP failure issues ? any sample code i can look ? Thanks, Ron

Re: FTP Failing with space issues

2017-04-20 Thread Ron Thomas
failing with X37 abends. The file is already allocated one in mainframe . I am not sure whether we can allocate the file from linux virtual machine script ? if possible , how this can be done ? Thanks. -- For IBM-MAIN

  1   2   3   4   5   >