If I have a view which is a join of two or more tables, can this view be updateable?
What is the return codes 0307 and 0326?
What is the advantage in De-normalizing tables in DB2?
Suppose I want to code a rexx program in order to get the inputfile and output files of jcl. I want code snippet or the coding for this?
I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?
What is the function of the steplib dd statement?
What is the advantage of defragmentation?
example for sub strings ? and refernce modifications whit output pls
Explain how to differentiate call by context by comparing it to other calls?
How to retrieve rows from a db2 table in embedded sql?
What is monosysplex?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
how do we prepare test data using file-aid tool?
What is host variable?
What is the syntax of JCL statement?