By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Cursor Load

P: n/a
Hi,
I like to load data from one table in a database in a server into
another table in another database residing in another server. I like
to use cursor load. in that case.
1) Do i need to catalog the target database.
2) Can i do it online.

Any suggestions. This might be simple. I am new to this. Please help
me.
Thank You
Vijay

Sep 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 25, 12:21 pm, bujjus...@gmail.com wrote:
Hi,
I like to load data from one table in a database in a server into
another table in another database residing in another server. I like
to use cursor load. in that case.
1) Do i need to catalog the target database.
2) Can i do it online.

Any suggestions. This might be simple. I am new to this. Please help
me.
Thank You
Vijay
You 'll need nicknames (federation) for the target tables at the
source location (or vice versa) to be able to use cursors for this
kind of load. An easier option would be to export in 'ixf' or 'del'
format and ftp and then load.

~sanjuro

Sep 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.