What is JOIN and different types of JOIN.
Answers were Sorted based on User's Feedback
Answer / nidhi sharma
joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join
Is This Answer Correct ? | 26 Yes | 1 No |
Answer / vamsikrishnamraju
Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join
Is This Answer Correct ? | 7 Yes | 4 No |
How to run db2 command in windows?
Q3. How will you fetch duplicate values from a DB2 table?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
what is diffrence b/w file-aid tool and file-aid utility???
What is the command used by TSO users to invoke DB2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are db2 tables?
How do I optimize a query in db2?
What r the comman abends in db2, jcl and cobol???????
What is difference between alias and synonym in db2?
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?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........