Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is iseries database?
What is cascading rollback?
What are host variables in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Mention some fields that are a part of sqlca.
How does cobol compile db2 program?
List out the data types available.
Which component is used to execute the sql statements?
What is the difference between drop table and delete table?
How would the varchar column remarks defined?
What is host variable?
What is plan in cobol db2?
What is netezza database?
What is dbrm library?
On which levels locks can be applied?
