Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

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.

3 7408

i want to maintain uniqueness on pdf without make lf??????????

1266

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

Broadridge,

2650

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1281

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1429

What does an outer join do?

CTS,

1 6234

What happens to a cursor after a commit?

3 7218

What do you do to keep the cursor from closing after a commit?

1 5486

How do you check for a null value in a db2 column?

2 9931

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 .....

1503

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

Infosys,

1862

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

Cognizant,

2 5821

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

IBM,

6 10448

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 4471

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

RBS,

2 5428


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is db2 optimizer?

212


How to fetch the last row from the table in SQL (db2)?

533


How do I add a column to an existing table in db2?

195


Which components manage deadlocks in db2?

238


What is package in cobol db2?

246






What is image copy in db2?

196


What is runstats db2?

209


What is isolation level in db2?

201


What is ibm db2 client?

198


What is rebind in db2?

213


What is difference between alias and synonym in db2?

190


Where do you specify them?

222


Explain how can you do the explain of a dynamic sql statement?

247


What does reorg do in db2?

205


Which are the db2 tools to protect integrity of the database?

255