what is + sign and -ve sign for sql code ?
- 1 Answers
- 5938 Views
- TCS, I also Faced
- E-Mail Answers
Answer / amarnadh reddy
In SQL CODE, + sign means wornings.
In SQL CODE, - sign means unsuccessful execution.
| Is This Answer Correct ? | 21 Yes | 1 No |
What is JOIN and different types of JOIN.
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Define data page.
How does DB2 determine what lock-size to use?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is the function of buffer manager?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What techniques are used to retrieve data from more than one table in a single SQL statement?
Once you create a view, where would information about the view be stored?
What is drop table?
What is role in db2?
What action db2 takes when a program aborts in the middle of a transaction?
COBOL 
