IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
2 6448i want to use only first 100 records from a file.plz tell me how to write JCL for this(for read,copy,write operations).plz give me details of all posible JCL utilities?
CTS,
7 43956What is COUNTERS in PL/1? How to assign the COUNTER variables? WHich Data Type it can be used for this?
2 6573Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?
3 10504we have 2 PF files with same name, how to copy data's from one file to another through RPG program logic?
3 19849How to read the last 100 records from a COBOL file. The file contains N number of records.
IBM,
11 41336For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
3 6744What is the significance of the PROGRAM-ID paragraph? If this name doesnt match with the name of the COBOL program, does it make a difference? Is the name specified in the PROGRAM-ID paragraph used as a name for the load module or any such thing?
IBM,
4 16501How to find whether a Flat file is empty or not without Reading a file in COBOL Program. (not using JCL)
9 34535I have 2 steps in my exec statement , in first step I am creating a gdg, and the output of this step is going into second step as a input, and this second step is abended , now how could i approach in this case.
5 13610I have a File that has duplicate records. I need only those records that occur more than thrice.
3 13542
Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC
explain in brief how you can create a vsam file?
What is db2 bind?
How many root segments do we have per database record?
What are the sub parameters for undo command?
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
Explain package in db2 and its advantages?
What is data structure in as400? What is the use of data structure?
How can values be passed from the job stream to an executable program?
Explain the data storage?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
what is scan and xlate?
How do you eliminate duplicate values in db2?
How gdg are concatenated?
What is the use of base and index registers in the IBM 360/370 processor?