What is db2 optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
When reorg is used?
What is image copy?
Can you search give an array in the WHERE clause of a db2 query?
What language is db2 written in?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Which component is used to execute the sql statements?
How do you prepare a COBOL + DB2 program from coading till execution ?
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?
Discuss about db2 bind?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What is a cursor in programming?
Plan has the optimized access path in it. But is that optimized access path is attained or known