Selecting the max value from a file.

pema_yozer · New User Joined: 16 Feb 2009 Posts: 54 Location: pune

i had a file with the below layout

IBMSNAP_INTENTSEQ (BYTE(10))
,IBMSNAP_OPERATION (CHAR(1))
,IBMSNAP_COMMITSEQ (BYTE(10))
,IBMSNAP_LOGMARKER (CHAR(26))

i would load this file onto a table and then use sql to get the
MAX(IBMSNAP_COMMITSEQ||IBMSNAP_INTENTSEQ)
and
MIN(IBMSNAP_COMMITSEQ||IBMSNAP_INTENTSEQ)

i was looking out for a way to do it with sort so i can get the above two values
without having to load the file into a table.

Joerg.Findeisen · Posted: Fri Nov 25, 2022 1:15 pm

See DFSORT OUTFIL, using there MAX and MIN parameters.

pema_yozer · New User Joined: 16 Feb 2009 Posts: 54 Location: pune

thank you let me check that out and try to work it out.

Rohit Umarjikar · Posted: Sat Nov 26, 2022 3:21 am

You can Google as well as it was discussed many a times on this forum. Please make a use of code tags.