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
6358 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

Can one database have multiple instances?

1097

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1138

How do I optimize a query in db2?

1153

what is utility for parm lib

2423

What is a Foreign Key?

1143

What is the connection string to connect to the DB2 Database ?

1176

What is a page in db2?

1080

How to check table size in db2 sap?

1099

What is coalesce in db2?

1187

What do you mean by between and in? Is between inclusive of specified range values?

1141

What db2 400?

1260

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1238

Where do you specify them?

1375

What is null indicator in db2?

1165

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

1145