How to compare data between two tables in db2?
No Answer is Posted For this Question
Be the First to Post Answer
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
How to create db2 table in mainframe?
What is a page?
What is CHECK PENDING ?
Do we need cursor for Count(*)?
When is the skeleton cursor table created?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What are the disadvantages of PAGE level lock?
What is difference between rollback and commit?
What are the various data types available in db2?
What are packages in db2?