On Tue, 13 Oct 2020 16:19:39 -0300, Clark Morris wrote:
>...
>What field is 1,4,CH? Why should an applications programmer have to
>know in 2020 that offset 5 in the COBOL data division map means 6 if
>it is a fixed block file and 10 if it is a variable block file?
>
PL1 and COBOL both
>>What field is 1,4,CH?
If you looked up the syntax of P, M, F then it is very easy to follow
P = start position of the field
M = Length of the field
F = format/type field
so 1,4,CH = position 1 for a length of 4 bytes and character format
>>Why should an applications programmer have to
know i
[Default] On 25 Sep 2020 10:25:23 -0700, in bit.listserv.ibm-main
skol...@us.ibm.com (Sri h Kolusu) wrote:
>> Given the obscurity of the control statements (quick tell me what
>> field is 1,4,CH) why not write the thing in a language
>
>Clark,
>
>I have to respectfully disagree with you. The contr
Sent: Friday, September 25, 2020 1:16 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: [IBM-MAIN] DFSort to pull the latest record date
[External Email: Use caution with links and attachments]
Why not load the data into a DB and use SQL or similar language?
If you have SAS - Max Min - functions
If
On Fri, 25 Sep 2020 10:25:13 -0700, Sri h Kolusu wrote:
>
>... The control statements for DFSORT
>are not obscure and they are on the same level as following the
>coding/syntax rules for a programming language. For example COBOL, you
>would follow all the rules governing it. So why not do the
On Fri, 25 Sep 2020 14:08:30 -0300, Clark Morris wrote:
>
>Given the obscurity of the control statements (quick tell me what
>field is 1,4,CH) why not write the thing in a language that has access
>to the descriptions of the fields being used? We are not in the era
>of 22K DOS360 partitions, 100K
lusu
To: IBM-MAIN@LISTSERV.UA.EDU
Date: 25/09/2020 18:34
Subject:[EXTERNAL] Re: DFSort to pull the latest record date
Sent by:IBM Mainframe Discussion List
>>If you can load to EXCEL - use its functions
Not all functions on the mainframe can do everything. You shou
: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DFSort to pull the latest record date
>>If you can load to EXCEL - use its functions
Not all functions on the mainframe can do everything. You should look at
what makes sense. And if the tool you are comfortable in using, does not
have the function, I
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
>>If you can load to EXCEL - use its functions
Not all functions on the mainframe can do everything. You should look at
what makes sense. And if the tool you are comfortable in using, does not
have the function, I would say to find one that does.
Lizette,
EXCEL is limited to 1 million records.
> Given the obscurity of the control statements (quick tell me what
> field is 1,4,CH) why not write the thing in a language
Clark,
I have to respectfully disagree with you. The control statements for DFSORT
are not obscure and they are on the same level as following the
coding/syntax rules for a
not have the
function, I would say to find one that does.
Hope that helps
Lizette
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of Ron
Thomas
Sent: Friday, September 25, 2020 9:55 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DFSort to pull the latest record date
Hello
> Here we need to pull the 2'nd record to the Output as this is the
> latest date .
Ron,
Use the following DFSORT/ICETOOL JCL which will give you the desired
results
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
+1+2+3+
[Default] On 25 Sep 2020 09:54:45 -0700, in bit.listserv.ibm-main
ron5...@gmail.com (Ron Thomas) wrote:
>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|20
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
15 matches
Mail list logo
