What are the contents of a DCLGEN ?
EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.A host language copy book that gives the host variable definitions for the column names.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is CDF? 04.12.08
CDF (Channel Definition Format) is an XML based data format used in the Microsoft internet explorere 4.0 and later to describe active channel contents and deskt...While handling the interrupt instructions in 8086, What are the internal operations may be carried out by the stack? 14.11.08
(i)SP =SP-2 , stack ß Push flag reg. Contents, IF =0 , TF =0 (ii) SP=SP-2, Stackß CS Reg. Contents, Address of Interrupt pointer = Interrupt type * 4 ,...Write about the following instruction : LES CX, [3483H] 14.11.08
Copy the contents of memory at the displacement of 3483H in DS to CL, contents of 3484H in DS to CH, and copy the contents of memory at displacement of 3485H a...Define XLAT instruction used in 8086. 14.11.08
It translates a byte in AL using a table in memory. The offset address is calculated by adding the 8 bit contents of the AL register and the contents of BX reg...Given a singly linked list, print out its contents in reverse order. Can you do it without using any extra space? 10.11.08
Start reversing the list. Do this again, printing the contents. tags: microsoft sw programming...Can we declare DB2 HOST variable in COBOL COPY book ? 24.03.08
NO. If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not expan...Is DECLARE TABLE in DCLGEN necessary? Why it used? 12.03.08
It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc., during p...Is it mandatory to use DCLGEN? If not, why would you use it at all? 12.03.08
It is not mandatory to use DCLGEN. Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself (because of the DECLARE TABLE...What is Declaration Generator(DCLGEN) 09.03.08
DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the validity...What are the contents in technical specifications? 06.03.07
There are five contents in Technical Settings: Data Class, Size Category, Buffering Permission, Buffering Type and Logging....