What is the role of schema in the db2 database?
No Answer is Posted For this Question
Be the First to Post Answer
When do you use the IMAGECOPY?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is node in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What is cursor in dbms?
Explain the use of the WHERE clause?
can all users have the privilage to use the sql statement select * (dml)?
What will happen, while trying to close the closed cursor.
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
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?