how will you retrieve first record in table
Answer / saravana
select empname,empno from tablename order by empno fetch
first row only;
| Is This Answer Correct ? | 11 Yes | 0 No |
What is a data page?
What are the bind parameters ibm db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is a subselect? Is it different from a nested select?
Why select is not preferred in embedded sql programs?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
When Can you be sure that a query will return only one row?
How do you find the maximum value in a column in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is with ur in db2?
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 ?...
what is + sign and -ve sign for sql code ?