Share.org has a wealth of SMP/E presentations.
Davod
-Original Message-
From: Jousma, David <01a0403c5dc1-dmarc-requ...@listserv.ua.edu>
To: IBM-MAIN@LISTSERV.UA.EDU
Sent: Fri, Sep 25, 2020 6:22 am
Subject: Re: shopz UJ01255
Instead of ordering "Recommended", order everything, and
Just a wild guess?
Sort it in reverse and take the first record as oldest date??
Chris Hoelscher
Lead Sys DBA
IBM Global Technical Services on assignmemt to Humana Inc.
T 502.476.2538 or 502.407.7266
-Original Message-
From: IBM Mainframe Discussion List On Behalf Of
Lizette Koehler
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
Excel is awful to use. I would recommend doing as much as possible
elsewhere before loading into Excel. (Including what some of my code does:
Creating the CSV files in DFSORT.)
Cheers, Martin
Martin Packer
Systems Investigator & Performance Troubleshooter, IBM
+44-7802-245-584
email:
Totally agree
Just trying to provide alternatives that might make sense. I know I love
SAS and I tend to do everything in SAS. But my co workers do not use it. So
then I either have to super document the process so they can support it
Or find alternatives to do the work that they would be
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
Wayne Bickerdike wrote:
>My "spoof" email was apparently genuine. The
>person who sent it has no idea
>how much he got wrong with the request.
Eh? Can you elaborate? First sentence makes no sense. It was spoofed or it
wasn't?!
--
zMan -- "I've got a mainframe and I'm not afraid to use it"
> 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
Why not load the data into a DB and use SQL or similar language?
If you have SAS - Max Min - functions
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
> 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 *
W dniu 25.09.2020 o 02:59, Neale Ferguson pisze:
How do I set the default logon procedure for a TSO user? Currently on the login
screen the Procedure field is empty and I’d like to set it to ISPFPROC. Using
search on the IBM Knowledge site results in a heap of stuff and I am having
trouble
[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|
This is not state of the art solution, but... You can prepare another
order and explicitly request all the missing PTFs in this order. Finally
you will have two (three..) orders which you can RECEIVE into CSI.
While it is convenient to have all needed PTF within single order it is
not required.
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
Classification: Limited
I went through a similar discussion last year (? this year? Time flies..), and
I now do RECEIVE ALL - just means you have all available fixes, whether you
then go on to APPLY them of course, is entirely up to you, but I found it was
better to have them than now. It's
Instead of ordering "Recommended", order everything, and then only apply the
Recommended.
CONTENT (ALL)
Its entirely possible the PTF you are interested in, never made it to
"recommended".
18 matches
Mail list logo