Interested to Buy Any Domain ? << Click Here >> for more details...
What is JOIN and different types of JOIN.
- 2 Answers
- 12591 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What is filter factor?
what is a plan and how do you refer the plan in the program?
my project is insurance management system,how to explain my work environment in interview?
Can I use LOCK TABLE on a view?
Explain about open switch business continuity software?
What can the SET option of the Repair Utility accomplish?
What is DCLGEN ?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
How to check table size in db2 sap?
How do I delete a column in db2?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
how can we retrieve the 100 records of the file ?
COBOL 
