-
INSPECT and EXAMINE
What is the difference between INSPECT & EXAMINE?
-
CEEDUMP and SYSUDUMP
Hi, Can anybody please tell me what is the exact purpose of the CEEDUMP and SYSUDUMP and How effectively we can use them for the problem solving( abend handling)
-
Bind process
What happens during pre-compilation and finally bind process?
-
How many rows will the query return ?
Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36
-
How do you skip a job and run step 1 and step3 ?
A job has 3 steps by name step1, step2, step3.if i don't want to execute step2, what i have to do.
-
-
-
-
-
What is the significance of the cursor with hold clause in a cursor declaration?
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
-
Explain an outer join?
An outer join includes rows from tables when there are no matching values in the tables.
-
What does a COMMIT statement do?
It writes a checkpoint to the Journal File and releases any record locks.