When you use CURSORS in your program. or when you use FETCH FIRST (n)

When Can you be sure that a query will return only one row?

Question Posted / shankar

4 Answers
8454 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / shankar

When you use CURSORS in your program.

or

when you use FETCH FIRST (n) ROW ONLY option on your SELECT
statement.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which components manage deadlocks in db2?

1016

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4214

What are db2 objects?

1000

How to test SQL -911 error while developing COB-DB2 program

7441

How to view db2 table structure?

960

What is a dbrm in db2?

969

What is drop table?

959

Give a brief description of db2 isolation levels?

1013

What is deadlock in db2?

1017

What does sqlcabc has?

994

what is diffrence b/w file-aid tool and file-aid utility???

4809

How do you concatenate the firstname and lastname from emp table to give a complete name?

1011

How do I create a view in db2?

973

What are the contents of dclgen?

1053

What do you mean by commit and rollback?

973