If we are using empty VSAM file, we can see this empty file by using FILE AID tool. How can we open empty VSAM file if you are using in Program..?
3 11764how to identify the file used in the JCL is an VSAM file. Just seeing the JCL code how can we track the file as VSAM file?
CSC,
6 17474If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
8 18162Could anyone please suggest me what is the maximum length of data that can be pass as input in //sysin dd * This was asked in interview. TIA
3 13682If TDQs are selfdestructive then why they are used? AND Why TSQs are preferred over TDQs?
IBM,
5 12054Looking at an CICS module how would one will identify that it is pseudo or full conversational?
IBM,
5 13086Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
8 33005Can we give the GSAM-PCB in between the DB-PCB'S like below? I/O-PCB DB-PCB1 GSAM-PCB1 GSAM-PCB2 DB-PCB2
IBM,
4 13250What is reference modification? What is UNION in sql and syntax? What is the difference between GDGS and VSAM? Which is prefer one? What is processing groups in endevor?
1 9054Would like to know if have an expecific command that returns a code or something about the execution of a CALLNAT. For example ... CALLNAT 'SUBPRG' [parameter] [parameter] ... [here comes a code or command that checks if the CALLNAT was successful]
1 7139What type of Call you would use if you don;t want the control back to the calling program?
TCS,
8 12936Scenario: I have 3 Input Files.Read the first i/p file and depending on certain business logic, I want to read wither i/p file-2 or i/p file-3.Now, depending on certain business logic applied to the record read from either file-2 or file-3, I decide to write them to either output file-2 or output file-2. Question: How many job steps are necessary to implement a solution for the above.
TCS,
2 6743I have a job which is a long-running one. Processes millions of records. Due to some run-time problem (not a problem due to the job/data) the job abends.What needs to be done to make the job complete successfully.
TCS,
4 10647
What is the eib parameter?
How to code the db2 queries using rexx?
What is universal database?
Is length = 0 sufficient to ascertain that the field has been modified?
Explain path?
What are the two types of fields available in ims db?
What are the different dataset organizations used in vsam?
What does the following code do? Ap wkur,=p5 where wkur is a label?
What are the full forms of spufi and dclgen and why are they used?
What is the use of commit in db2?
There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.
Can I combine uni-REXX with a compiled language in my application? What application programming interfaces are available? For example, can I share variables between uni-REXX and a compiled language?
What is a region in idms?
What are foreign keys in db2?
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?