How do you simulate the explain of an embedded sql statement in spufi/qmf?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How do I import a csv file into db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
what is REORG? what is the use?
Are views updatable ?
can we drop column from a table
what is a collection?
How to update more then one record using update?
How can you get the number of rows impacted by the last executed query?
Can we declare DB2 HOST variable in COBOL COPY book?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
Explain how can you do the explain of a dynamic sql statement?