IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
ADP,
4 10386For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
2 8561How can we extract data from IMS DB and load it onto oracle database by converting it.Pls someone help me
TCS,
2 5365Given below code, find the value of 'x'. Perform s001-x thru s001-y. s001-x. add 1 to x . s001-1x. ------- . s001-y. perform s001-1y 10 times . s001-1y. perform s001-2y 10 times . s001-2y. perform s001-x 10 times .
1 4647This was on MQseries. What does MQ queue Manager do? what are the different types of queues? do you know about remote queues etc. How do you delete records from queues? how do you empty queues?
1 4537
how can you display specific subfile page on the screen in unequal subfile?
How to print 10 to 1 if the input have only 10 digit number?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are the various data types available in db2?
How the interaction between DB2, SQL, and QMF takes place?
Specify cics transaction initiation process?
What is the difference between access path and open data path?
WHAT IS FERERENTIAL INTRIGRITY ?
A word in the computer memory is identified by_________
Explain the advantages of adabas?
how do handle file exception/error?
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.
How to move a field DT 9(8) of input file to DT 9(8) COMP-3 in output file in ezytrieve? in the output file entire dt is not moved.If any answer plz reply as soon as possible.
Suppose I have five jobs to do. But I want to hold one?
Explain the maps in cics?