mainframegurukul.com

In interview i faced below question:

How to find 10th highest salary in employe table with employe name.

My answer was

William please theow some more light on the ways suggested

I am unable to understand the approch suggested

Thanks William for your reply

I am using assgnment (=)

I want to suppress zeros for all variables from row3 to row10

Suggest an some approach

FileB ROW1 001 039 ROW3 040 015 N MASK 'ZZZZZZZZZZZZZZZ' ROW4 057 015 N HEADING ('REPRESENTMENTS') ROW5 074 015 N HEADING ('UNPAIDS') ROW6 092 015 N HEADING ('VALUE< R 100') ROW7 109 015 N HEADING ('VALUE< R 1000') ROW8 126 015 N HEADING ('VALUE< R 5000') ROW...

I have two files file 1 (pos 214) 13 13 14 21 25 26 31 33 36 file2 11 (means in this file every 1-5 have 1-6 entries 12 13 14 15 16 21 22 23 24 .. .. 56 My requirement is to get count of some specific fields from filea for all records of fileb Ad those records which are not present in filea should b...

I am using below jcl to precompile cobol-DB2 code //STP00#01 EXEC PGM=DSNHPC,PARM=('SOURCE','HOST(IBMCOB)', // 'APOST,APOSTSQL,') //STEPLIB DD DSN=DPD2.BTLLOAD.PUSER,DISP=SHR // DD DSN=DB2T.DSNEXIT,DISP=SHR //DBRMLIB DD DSN=LFML.EXTW131.PAD.DBRM(MEM1),DISP=SHR //* //SYSIN DD ...

Thanks William....!!
I managed to get the decimal but still not getting how to print the month like (Sep 2013)...........

Thanks a million William I am using below logic SORT FIELDS=COPY INCLUDE COND=(45,3,CH,EQ,C'010',OR,45,3,CH,EQ,C'020', OR,45,3,CH,EQ,C'014', OR,45,3,CH,EQ,C'052',OR,45,3,CH,EQ,C'062',OR,45,3,CH,EQ,C'054', OR,45,3,CH,EQ,C'254',OR,45,3,CH,EQ,C'114') INREC IFTHEN=(WHEN=(20,11,ZD,LT,5000000), BUILD=(20,...

I realiy appreciate your help I am using below sysin card SORT FIELDS=COPY INCLUDE COND=(45,3,CH,EQ,C'010',OR,45,3,CH,EQ,C'020', OR,45,3,CH,EQ,C'014', OR,45,3,CH,EQ,C'052',OR,45,3,CH,EQ,C'062',OR,45,3,CH,EQ,C'054', OR,45,3,CH,EQ,C'254',OR,45,3,CH,EQ,C'114') INREC IFTHEN=(WHEN=(20,11,ZD,LT,5000000),B...

Thanks for help William!! BUt i have some issues here. 9/03/13 MAILBOX EFT ON US FOR MAY 2013 1 DAY SERVICE PAGE 1 No of transaction TOTAL AMOUNT LESS R5M VOLUME 0000002440 70,397,603.16 OVER R5M VOLUME 0000000533 1,550.00 My output report should look like above I cannot understand what Build is doi...

Don't have the final AND on the INCLUDE. Use INREC IFTHEN=(WHEN=(... to determine LT, and set the valuesin less-than-5m location and zero in 5m-or-more location. Use IFTHEN=(WHEN=NONE and set zero to less-than5m locations and values in 5m-or-more location. Then have four TOTs for the four fields, a...

Now i am using the below sysin card SORT FIELDS=COPY INCLUDE COND=((45,3,CH,EQ,C'010',OR,45,3,CH,EQ,C'020', OR,45,3,CH,EQ,C'014', OR,45,3,CH,EQ,C'052',OR,45,3,CH,EQ,C'062',OR,45,3,CH,EQ,C'054', OR,45,3,CH,EQ,C'254',OR,45,3,CH,EQ,C'114'), AND,(20,11,ZD,LT,5000000)) OUTFIL NODETAIL,REMOVECC, HEADER1=(...

Thanks for help William.

But i am still struggling.....
If possible please write in more detail,specifically to count the amount in both cases.

Hi William I tried display but it expect on clause as i do not want to print any input record to my report it will not help.I just want the four different counts 1 no of transaction 2 total amount of transaction I want these details for amount less than 5M and over 5M Hi Dikdude, Please accept my si...

try this for unmatch records //SYSIN DD * JOINKEYS FILES=F1,FIELDS=(139,18,A, 99,12,A,264,08,A) JOINKEYS FILES=F2,FIELDS=(1,18,A, 23,12,A,40,08,A) JOIN UNPAIRED,F2,ONLY SORT FIELDS=COPY END /*