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
- 2080 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 |
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is dclgen in db2?
What is a DB2 plan?
What are packages in db2?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How can deadlocks be resolved?
How to resolve -502 sql code in DB2?
select distinct(empid),distinct(dept),name from EMP will the above query work?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What are foreign keys?
What is difference between *omit and *nopass?
COBOL 
