If the to fetch empno and sal from emptble is written in embedded sql the

Select empno, sal from emptbl where empno < 101.By this
query can we fetch first 100 recs? where empno is primary
key.It won't throw -811 error? if it wont,then what is use
of cursor technique while fetching first 100 recs.

Please need more clarification.

Question Posted / madhu t

2 Answers
6252 Views
I also Faced
E-Mail Answers

Answer Posted / madhu t

If the to fetch empno and sal from emptble is written in
embedded sql then it will give sqlcode -811.
yes this query fetches first 100 records of employee table.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are catalog tables in db2?

1050

What is load utility in db2?

1181

What are the contents of dclgen?

1112

What is the difference between cursor and select statement?

1106

What is schema in db2?

1022

What is bufferpool in db2?

1054

How to find schema of a table in db2?

1016

Is db2 free?

1096

What's The Percentage Free Space ?

1224

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

4316

What is the use of commit in db2?

1083

Is ibm db2 open source?

1075

What is deadlock in db2?

1070

How would the varchar column remarks defined?

1090

What is cursor stability in db2?

1358