What are the flavours of DB2?
why do we declare include in between exec sql and end exec and why cant we declare copybook in place of include. Is their any reason why we declare include only
Latest Answer: INCLUDE is a pre-compiler statement so it should be coded within the scope of EXEC SQL and END-EXEC. INCLUDE is expanded during pre-compilation tome but COPY is expanded during compilation time and so declaration of host variable in ...
Can you select any column in a Group by query even if that column is not groupable?e.g. Select Dept, Empno, Ave(salary) From T1 Group by DeptCan we select empno in the above query?
Latest Answer: Yes we can select the emp no field ...
What happens during pre-compilation and finally bind process?
Latest Answer: Pre-compilation---> Pre compiler check's the program for any embedded sql statements if found than separates them into a DBRM and an object module is formed for the host language to be compiled by the compiler.....On the otherhand the DBRM that is formed ...
what is a db2 precompiler?
Latest Answer: When a Cobol program contains any embedded SQL statements the pre-compiler separates the non-Cobol statements and the Cobol statements separately, then the pre-compilation process begins. The non-cobol (SQL) statements are stored as a member of the pds ...
In DB2, Large Objects (LOB) Columns are used to store large objects (Documents, pictures, voice, and mixed media) in database. Which of the following clauses can't be used on LOB columns?a) GROUP
Latest Answer: None of the above ...
How many DB2 plans can be connected to CICS region at a time? a). Infinite b). 1 c). Depends on CICS region definitions d). 255 e). None of the above
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table
If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table
When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG
Latest Answer: Catalog Node ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
