IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, then how will the sort card be??? e.g- if we want to sort by a field which is defined as a PIC X(5) then we will mention - sort fields=(1,5,ch,a). Likewise if a field is defined as PIC S9(10)COMP-3 then in this case how will the sort field be defined (because in this case a sign is also involved)???
8 41826In a single table,How to retrieve a employee-id of an employee who works in more than one department?
15 242401.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
11 48954How I can reread the physical file in CL program once the end of file reached in same CL program.
IBM,
20 65608how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
8 16265Given the following code, what is the value of RESULT? DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords+++++++++++++ D RESULT S 5 0 C EVAL RESULT = (2 + 3 * 2) ** 2 / 2
2 6444
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
explain the use of dftwrt display keyword?
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?
What will happen if some program tries to process a queue on which an ENQ command has been issued by some other program?
Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?
kindly specify the pic clause for the following:any bll cell, data type of length option field, hhmmss type of data fields?
What are the different types of table spaces?
what are the key words you must use when using a subfile?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
Explain what is a cursor in cics sql processing?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Differentiate between PCT and FCT.
Define dynamic processing?
File1 has 100 records and file2 has 200 records I want to copy 50 records which are in both file into file3?