What is the maximum length of a column name in DB2? 18 or
30 or anything other than these?
Answers were Sorted based on User's Feedback
Answer / vat
it depends :) which vesion of DB2 that you are referring
to...
V7 : 18
V8 : 30
| Is This Answer Correct ? | 17 Yes | 4 No |
Explain package in db2 and its advantages?
What are concurrency issues?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Explain the use of the WHERE clause?
What are delete-connected tables?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
Explain the contention situations caused by locks?
can any body explain about plan and pakage in detail....
Why use RUNSTAT Utility?
What is db2 purescale?