37) What are the contents of a DCLGEN? - - 1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MAINFRAME

DB2

DETAILS

Question: 37) What are the contents of a DCLGEN? -

Answer: 1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8080 users
Added on	9/1/2014
Views	68882
Rate it!

Question: 37) What are the contents of a DCLGEN? -

Answer:

1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	36) What is DCLGEN ? -	View Answer
	35) What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)? - Ramesh	View Answer
	34) What is the COBOL picture clause of the following DB2 data types:	View Answer
	33) What is the physical storage length of each of the following DB2 data types:	View Answer
	32) Give the COBOL definition of a VARCHAR field.	View Answer
	31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )	View Answer
	30) When you COMMIT, is the cursor closed? - drona db2 interview questions	View Answer
	29) Can you have more than one cursor open at any one time in a program ? �	View Answer
	28) Is DECLARE CURSOR executable?	View Answer
	27) What happens when you say OPEN CURSOR?	View Answer
	26) How do you specify and use a cursor in a COBOL program? �	View Answer
	25) Where would you specify the DECLARE CURSOR statement? �	View Answer
	24) How would you retrieve rows from a DB2 table in embedded SQL? �	View Answer
	23) What is a cursor? why should it be used? �	View Answer
	22) What are the issues related with correlated subqueries? � ???	View Answer
	21) Why SELECT * is not preferred in embedded SQL programs?	View Answer
	20) What is the result of this query if no rows are selected:	View Answer
	19) Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?	View Answer
	18) What do you accomplish by GROUP BY ... HAVING clause? �	View Answer
	17) What is the meaning of underscore ( �_� ) in the LIKE statement? �	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DB2 Interview Questions & Answers - Exam Mode / Learning Mode