How do you simulate the explain of an embedded sql statement in spufi/qmf?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

How will you delete duplicate records from a table?

7 Answers   Google,


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


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 Answers  


What is the syntax for creating a table in the db2 database?

0 Answers  


What's the maximum number of characters that a tablename can have?

3 Answers  






How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  


What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,


How to create backup table in db2?

0 Answers  


How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,


Can you search give an array in the WHERE clause of a db2 query?

1 Answers  


What is the reason behind not using select * in embedded sql programs?

0 Answers  


how to check the table is empty or not?

3 Answers   IBM,


Categories