Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



MainFrame Interview Questions
Questions Answers Views Company eMail

What is the difference between TYPE 1 index & TYPE 2 index

IBM,

1 13235

What are the disadvantages of using VARCHAR?

3 15675

What is the purpose of the DSNC transaction ?

1 7610

What are delete-connected tables?

1 4404

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 30386

What is a correlated sub query?

2 5490

What is read-only cursor?

1 6792

What Utility is used to migrate DB2 from one release to the next?

1 5855

What is Skeleton cursor table (SKCT)?

2 14479

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 6136

What is the database descriptor?

2 14694

What is the syntax required for the creation of a cursor?

1 9798

What is meant by AUTO COMMIT?

3 10193

What information is contained in a SYSCOPY entry?

2 10037

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 20600


Un-Answered Questions { MainFrame }

What are the full forms of spufi and dclgen and why are they used?

1104


how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.

3690


Can you delete vsam files with the delete option of the disposition parameter of jcl?

1126


Tell about how do you eliminate the duplicates?

1021


What is host variable in db2 cobol?

1097


What are the various error conditions seen in rexx?

943


Why do we need reorg in db2?

1005


can any one plzzzzzz tell the jcl code for creating ps using idcams

11689


What is link edit in cobol?

1229


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2380


Can we see the copy book length using file-aid?

924


What is redefines clause in COBOL?

1310


how you will the direct the data to spool using sysout option?

2448


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2538


Explain the maps in cics?

1191