in GDG: is it poosible to copy records from a file which
utilizes some 100 cylinders to a gdg whose model is defined
as trk(1,0) and also it possible to copy 100 bytes file to
80 bytes file?
Can we update view in db2?
What is the SQL Communications Area and what are some of its key fields?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
how to copy the host variables from ps file into cobol program other than include statement
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Highlight all the advantages that are attached to a package.
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
Compare a subselect to a join?
How can you compare table column after update and before update?
When will you chose to run RUNSTATS?