Interested to Buy Any Domain ? << Click Here >> for more details...
wht is d/f between union and joins ?
- 2 Answers
- 6419 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amarnath reddy
use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;
use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;
| Is This Answer Correct ? | 4 Yes | 1 No |
How to find last record before record through SQLRPGLE?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the difference between TYPE 1 index & TYPE 2 index
What happens to a cursor after a commit?
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.
Is db2 free?
Can you tell me how can you find out the # of rows updated after an update statement?
What are iseries servers?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is the significance of DB2 free space and what parameters control it?
What are the various data types available in db2?
COBOL 
