What is the picture clause of the null indicator variable?
Answers were Sorted based on User's Feedback
Answer / mna
The null indicator data-type expected by different
utilities is S9(04) comp. Usage of sync depends on the
version of cobol compiler we are using.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / prasad
S9(04) COMP SYNC
Using SYNC is always better for fast processing.
| Is This Answer Correct ? | 6 Yes | 4 No |
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Is Cursor exicutable ?
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 .
Explain what are the various isolation levels possible?
How to rename a table in DB2 ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
How can you display the current date & current time ?
What is cursor stability?
Q3. How will you fetch duplicate values from a DB2 table?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
Explain transactions, commits and rollbacks in DB2.