What are union and union all?
No Answer is Posted For this Question
Be the First to Post Answer
How many databases can be created inside an instance in db2 ?
Before you give the explain statement, what are the prerogatives?
How can you get the number of rows impacted by the last executed query?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain packages.
What is bind plan?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What are PACKAGES ?
what is the Foreign key? explain?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?