How to retrieve the third maximum value from a column ?
For Ex: If i have emp-id as one column with values 111,458,785,896,274,698 etc, using SELECT MAX(EMP-ID) retrieves the value "896". But i...
Type: Posts; User: kanchhana; Keyword(s):
How to retrieve the third maximum value from a column ?
For Ex: If i have emp-id as one column with values 111,458,785,896,274,698 etc, using SELECT MAX(EMP-ID) retrieves the value "896". But i...
I have group item as below :-
01 ws-var1.
05 ws-var2 pic s9(4).
05 ws-var3 pic x(4).
.
.
..
Procedure division.
INITIALIZE WS-VAR3.
I have a JCL like this :
//JOB1 JOB NOTIFY=&SYSUID
//STEP1 EXEC PGM=IEBGENER
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//DD1 DD DSN=input-dsn,DISP=SHR
//DD2 DD DSN=output-dsn,DISP=SHR...
Currently am doing my course in mainframe and for a beginner like me pls suggest some useful books for JCL other than the one written by Chander.K.Ranade ......