**************************************************************************
Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
**************************************************************************
:
Thirumaran,
Why don't you just use the DB2 export and load utilities?
Don't forget that you have to feed a SELECT statement into an export. In
the SELECT statement code the column order to match the order in the target
table. You can also add new columns (by assigning default values, eg.
"SUBSTR(' ',1,4) AS NEWCHAR" or "INTEGER(0) AS NEWINT") and perform data
conversion where the column data types don't match (using DB2 functions).
David Chapman,
IBM Certified DBA for DB2 UDB on OS/390, Linux, Unix and Windows.
|---------+--------------------------------------------------------->
| | Thirumaran |
| | <db2udbdba-ezmlmshield-x29515196.[Email Address Removed] | azyDBA.com> |
| | |
| | 24/06/2004 23:40 |
| | |
|---------+--------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: LazyDBA Discussion <[Email address protected] |
| cc: |
| Subject: DB2 tools |
>----------------------------------------------------------------------------------------------|
Hi,
DB2 version 8.1
OS: AIX 5.1
1) Is there any DB2 tool simillar to ETL (Extract Transformation & Load)
tool (or ) Sql server DTS package .
i.e i need to migration from DB2 v8.1 to DB2 v8.1 having different table
structures.
2) What is the alternate for to_number(null) (oracle) in DB2
Example(Oracle): what is equalent in DB2
Select to_number(null), Name, Age from TableA
Union
Select Epid, Name, Age from TableB
Regards
thiru
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
:
********************************************************************************
The information transmitted in this message and attachments (if any)
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.
If you have received this in error, please contact the sender and delete this
e-mail and associated material from any computer.
The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.
This message has been scanned for viruses and cleared by MailMarshal.
********************************************************************
:
DB2 & UDB email list listserv db2-l LazyDBA home page