How do you filter out the rows retrieved from a Db2 table ?
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?
Where do you specify them?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is image copy?
how to get duplicate records from tables?write qurey for this?
What is dbrm? When it will be created?
What is the use of db2 optimizer?
How do I delete a table in database?
What is declare cursor?
Can I use LOCK TABLE on a view?
What is the physical storage length of timestamp data type?