Where do you specify them?
No Answer is Posted For this Question
Be the First to Post Answer
How many buffer pools are there in DB2?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How do I add a column to a table in db2?
How can you quickly find out the # of rows updated after an update statement?
How does db2 sample database connect?
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
Define declaration generator (dclgen).
What is dbrm? What it contains? When it will be created?
What is a Resource Control Table(RCT)? Describe its characteristics.