Answers were Sorted based on User's Feedback
Answer / prachi
SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;
This will fetch 1st 100 records
|Is This Answer Correct ?||20 Yes||0 No|
Answer / ankit.:-)
if u want to fetch first 100 go for
select * from tablename fetch only 100 rows;
this will select only 100
|Is This Answer Correct ?||5 Yes||5 No|
Is db2 relational database?
What is a view? Why use it?
What is a DB2 plan?
How to view db2 table structure?
how can u understand the end of the table ?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What are common abends
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Outputs of explain are with matchcols = 0. What does this signify?
What is scrollable cursor in db2?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.