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
6213 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 we update view in db2?

983

Discuss about db2 bind?

1078

What are db2 objects?

1032

List some fields from sqlca?

1037

What is node in db2?

1033

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8239

What is buffer pool and list some of them?

1006

What is database reorganization?

1107

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2215

What is cascading rollback?

1190

What are bind parameters in db2?

1022

What are foreign keys in db2?

1082

What is schema in db2?

1006

What is precompiler in db2?

996

What are the various data types available in db2?

1074