DSXchange

Thank you so much for the information. I got help from my IT team.
thanks
Nivas

I tried with rsh as follows
rsh <host> -l <userid> <command>

I am getting error as Connection refused.Can't establish connection.

Could you please suggest hints.

thanks
Nivas

Hi
I need to execute a batch file on a Remote server. The remote server OS is WINDOWS XP. I think RSH and REXEC utilities are for UNIX OS.

could any body suggest hints on it.

thanks
Nivas

Thanks for your information. I am trying to use as follows. The remote server is on windows OS. rsh <host> -l userid <pwd> <commnad> I am getting error as connection could not be established. userid and pwd are correct. I tried with rexec also. If you can provide me some more information that would ...

I need to connect to a remote server console and need to execute a batch file on that remote machine. I have batch program sits on the remote machine. Using ExecDOS I need to execute the batch file on the remote machine from my machine/server.
thanks
Nivas

Hi
could you please suggest how do i connect a remote server using ExecDOS.
thanks
Nivas

Its not allowing me to put sourceFiled<= at join to hash file Key Column.
After <= I should some thing which datastage allows

use 2 stage varaibles to increment two numbers. First one pass as a parameter to CHAR() and concatename this to the second second incremented stage variables. This is an outline. For example You can achieve as follows. Or you can achieve many sequences

A1, B1, C1....Z1
A2,B2,C2...Z2

Hi

I need to join to a hash file like follows.

I need to use one souce filed as lookup against hash file. My hash file has two key columns.I need to join hash file as follows.

souce filed <=First key filed AND souce field>=second Key filed

Please help me out.

thanks
Nivas

You are absolutely right . Thanks

then compare this job with other job and find out the difference

then compare this job with other job and find out the difference

switch lookup and source positions if possible. I mean to say change the lookup to source and source to lookup as the present source has only 150 records.

performance will be effected by many reasons.

you may try by developing one job for each table load instead of one job for multiple tables.
You may try to use efficient plugin for data load, for example multiload if the data base is teradata, bulk load if it is oracle.

thanks
nivas

Hi I am calling dos batch script from datastage . That batch script interim calling another batch script called dsjobControlParm. I am getting error as "dsjobControlParam' is not recognized as an internal or external command, operable program or batch file" But If I directly run the batch ...