If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > onpload on a distant server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 7
onpload on a distant server

Hi, I'm trying to execute onplod on a distant database, so the question is : is there any syntaxe to connecte to a distant database in order to unload or to load like the connect to ... when using load and unload utilities??

thanks
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jun 2009
Location: Lisboa, Portugal
Posts: 77
Hi,

You must configure a connection between the two Informix instances on sqlhosts file and you must have a connectivity for it, then you do:

database database_name@server_name;
load or unload command;

If you want to be more especific...

Hope it helps
__________________
LS
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 7
Hi, the problem is always in process, So Is there a way to have the onpload on a client side like I just have done to dbaccess wich I have install on a client with just the Informix SDK and not the entire Informix server, so I'm on a client machine wich have full access to the database wich is in a distant server and I configure the onpload job on that server but I want to call or to launch the job from the client machine thru some king of command is that possible??
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jun 2009
Location: Lisboa, Portugal
Posts: 77
I think, this will help you:

Remote Informix 11.5 Command Line Client - Stack Overflow

See you,
LS
__________________
LS
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 7
No, it does not help
What I want is to launch onpload but the command of extracting would be executed on a database wich is in an other server (a distant server).

thanks
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On