How to create db2 table in mainframe?
How would one remove old reorg information from the DB2 catalog?
How can you quickly find out the number of rows updated after an update statement?
Define data page.
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How do I change the column size in db2?
What is the role of data manager in the db2 database?
What's The Percentage Free Space ?
Where can you declare a cursor in a cobol-db2 program?
What are the various isolation levels possible?
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 column-name qualifiers used?