What for procopt is used? List some of them?
Answers were Sorted based on User's Feedback
Answer / s stanley
PROCOPT - is the processing options of the program on that DB.
Examples:
G - Read-Only Access
I - Insert Allowed
R - Read/replace Access
D - Read/Delete Access
A - All Access
LS - Load Sequential in GSAM (HIDAM)
GS - Get Sequential in GSAM
Is This Answer Correct ? | 37 Yes | 3 No |
Answer / prasanna
Procopt is processing optiosn which will be defined while
creating the database which specifies what operations can
be performed on tht database using particular PCB..
Is This Answer Correct ? | 23 Yes | 8 No |
Can we give the GSAM-PCB in between the DB-PCB'S like below? I/O-PCB DB-PCB1 GSAM-PCB1 GSAM-PCB2 DB-PCB2
What are the advantages and disadvantages of a hierarchical database?
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.
Explain the maximum number of levels allowed in ims db?
What is bmp mode?
Which DB access method (OSAM or VSAM) is used for primary index or secondary index and why?
I am totally confused on IMS message segments. When I create a message and it contains 5 segments does the entire message have a 32k limit or does each segment have a 32k limit? Is there a setting in the stage1 sys gen that defines if a transaction can receive/send multi-segmented messages?
What are the main control blocks available in ims db?
What are the two ways in which dl/i interface can be invoked?
What is dbms in ims?
How many PCB?s can be coded within a PSB?
An application programmer comes to you and says your DB is no good, they got an II status code on an insert call from IMS, is this a DB problem?