Interested to Buy Any Domain ? << Click Here >> for more details...
How do you retrieve the first 5 characters of firstname column of db2 table emp?
- 1 Answers
- 2059 Views
- I also Faced
- E-Mail Answers
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain packages.
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What are the Isolation levels possible ?
How do you do the EXPLAIN of a dynamic SQL statement?
how to get duplicate records from tables?write qurey for this?
Can one database have multiple instances?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
In terms of DB2 indexing, what is the root page?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
COBOL 
