Thanks for all your input. I got an overall idea. Installed DB2/SQLSERVER and did exercise of export from Db2/Sqlserver/Oracle(UTL_FILE) and imported into Sqlserver/Db2/Oracle (SQL LOADER). It went successfully. I want to write batch or shell scripts for these activity. As i am new to DB2/SQLSERVER I will really appreciate if somebody want to share .BAT for SQLSERVER bcp utility or shell script for Db2 export/import. Thanks in advance PTP
"Matthew H. Devlin III" <[Email Address Removed] wrote:Not sure on oracle and sqlserver but for db2 you can use export to 'del'
(delimited, comma by default) files.
Db2 export to of del select * (or whatever) from sometable;
This is a very simplified example that assumes you want all the data,
you can review the command reference (available online) for detailed
instructions.
Obviously, these commands would be easily stuck into a perll script. I
have a ton of perl code to run against db2 databases at
www.mattdevlin.net if you want any
examples. Nothing spectacular but it all works.
-----Original Message-----
From: manage data [mailto:[Email Address Removed]
Sent: Thursday, April 17, 2003 5:46 PM
To: [Email Address Removed] [Email Address Removed] Fwd: common SQL statments for ORACLE/DB2/SQLSERVER
Hi Guys
I want to create FLAT FILE from SQLSERVER tables data and DB2 tables.
What is best option we have ?
Basically I want to synchronize two databases (offline synchronization)
and databases may be (SQLSERVER, DB2 , ORACLE) . I was thinking of
writting PERL script which will talk to database (DB2/SQL/ORACLE) and
create FLAT FILE from data. and when Uploading to databases , for Oracle
we have SQLLDR or equivalent for DB2/SQLSERVER.
Another option i was thinking is writting common SQL statements.
Please guide me in this. I donot know anything about DB2/SQLSERVER.
Thanks
PTP
_____
Do you Yahoo!?
The New
Yahoo! Search - Faster. Easier. Bingo.
---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
DB2 & UDB email list listserv db2-l LazyDBA home page