-
sort in increasing order records based on the letters in columns 1, 2, 3, 9, 10,11
sort field=(1,3,CH,A,9,3,CH,A)
-
sort in increasing order records based on the letters in columns 1, 2, 3,BUT NO DUPLICATES
- sort field=(1,3,CH,A)
- SUM FIELDS=NONE
-
How to copy data set in DFSORT
- SORT FIELDS=COPY
- FIELDS - The input data set is copied to the output data set
- without sorting or merging.
-
Delete the VSAM file QUALVSAM.QUAL1.QUAL2
- //IDCAMS1 EXEC PGM=IDCAMS
- //SYSPRINT DD SYSOUT=*
- //PRINTDD DD SYSOUT=*
- //SYSIN DD *
- DELETE (QUALVSAM.QUAL1.QUAL2) -
- CLUSTER PURGE NOERASE
- /*
- //
-
What is the JCL to create vsam file qualVSAM.qual1.qual2.TEST?
- //IDCAMS1 EXEC PGM=IDCAMS
- //SYSPRINT DD SYSOUT=*
- //PRINTDD DD SYSOUT=*
- //SYSIN DD *
- DEFINE CLUSTER -
- (NAME (qualVSAM.qual1.qual2.TEST)-
- VOL(VSAMT3) -
- CYL(1,5) -
- MODEL(qualVSAM.qual1.qual2.model))-
- DATA (NAME (qualVSAM.qual1.qual2.DATA))
- /*
- //
-
What is the JCL to copy a vsam file?
- //STEP02 EXEC PGM=IDCAMS
- //INTAPE DD DSN=qualVSAM.qual1.qual2,DISP=SHR
- //OUTFSM DD DSN=qualVSAM.qual1.qual2.TEST,DISP=OLD
- //SYSIN DD *
- REPRO INFILE(INTAPE)
- OUTFILE(OUTFSM)
- //SYSPRINT DD SYSOUT=*
- //
-
What are common ddnames of MVS utilities
- SYSPRINT = output messages or printed output
- SYSUT1 = the input file
- SYSUT2 = the output file
- SYSIN = the control statement file
-
Write the jcl to sort a file based on 5 characters starting in the 9th column.
- //stepname EXEC PGM=SORT
- //SORTLIB DD DISP=SHR,DSN=***
- //SYSOUT DD SYSOUT=*
- //SORTIN DD DISP=SHR,DSN=input file
- //SORTOUT DD DSN=output file, DISP=(NEW,CATLG,CATLG),
- DCB=(RECFM=FB,LRECL=len,BLKSIZE=size),
- UNIT=DISK,SPACE=(TRK,(100,15),RLSE)
- //SORKWK01 DD UNIT=WORK,SPACE=(CYL,(10,1))
- //SYSIN DD *
- SORT FIELDS=(9,5,CH,A)
- /*
-
What is IKJEFT01?
IKJEFT01 is the TSO/E program. You use it whenever you wish to perform a TSO function within a batch job. It allows you to perform any TSO function. For a general list of all TSO functions, type TSO HELP. Additionally, IKJEFT01 allows you to run programs written in TSO/E Command List (CLIST) and/or TSO/E REXX. Optionally, you can also invoke other environments, such as ISPF , allowing you to run ISPF Dialogs in a batch environment.
-
What are some important ddnames to run a program
- STEPLIB = where to find the loadmodule
- SYSTSIN = specifies the executable commands
- SYSTSIN DD *
- DSN SYSTEM(****)
- RUN PROGRAM(prgname) PLAN(planname) LIBRARY(‘library’)
- /*
- SYSIN = program statements like SQL or FILEM
- SSSSnnCI = input control file, usually gdg gen(0)
- SSSSnnCO = output control file, usually gdg(+1)
- SSSSnnI1 = input records, some previous SSSSnnPn
- SSSSnnI2 = input records, some previous SSSSnnPn
- SSSSnnP1 = output records, sometime SSSSn+P1(+1)
- SSSSnnP2 = output records, sometime SSSSn+P2(+1)
- PCLOG program information determined by developer
- SYSOUT program messages and control statements are listed, system level output
- SYSPRINT program reports
- SYSTSPRT program reports
- SYSUDUMP
- SYSABOUT
-
What is the purpose of a DCLGEN?
DCLGEN (Declaration Generator) is a structure‑generating utility that maps the columns of a database table into a structure (a COBOL record) that can be included in an embedded SQL declaration section.
-
What is JESMSGLG, JESJCL and JESYSMSG ?
- JESMSGLG contains the "log" of what happened.
- JESJCL contains the expanded jcl that was executed.
- JESYSMSG contains allocaton/deallocation info as well as some statistics about the job.
|
|