DSXchange

narasimha wrote:Try hardcoding the name of your server name in the FTP stage and see if the connection fails again.
Also double check the default you have specified in the Administrator is your server name

The default I specified in the Administrator for server name is correct. There is nothing wrong in that.

narasimha wrote:Try hardcoding the name of your server name in the FTP stage and see if the connection fails again.
Also double check the default you have specified in the Administrator is your server name

Hardcoding the servername is working. But I am not able to use Environment variable.

Another check would be Say if your parameter name is $SERVERNAME, how are you referencing that in your RDBMS stage if you are using #SERVERNAME# change it to #$SERVERNAME# I am doing the same thing. I defined rdwserver as userdefined variable in admin and imported it into job parameter as $rdwserve...

I'm aware encrypted passwords defined as Project Parameters do not work properly when added to a job. If you are using password as encrypted you should create a job parameter for it. Otherthan that all all Project Parameter work fine. Try using $PROJDEF as a default value for the project parameters...

To use environment variables for FTP Plugin file stage you will have to add parameter to the job. I'm assuming you are calling user defined project parameter as global variables. You can source project paramter as $PROJDEF by defining the value in DataStage administrator or by $ENV to source it fro...

Hi,

Can anyone help me in using environment variables for FTP Plugin file stage. It is not accepting global variables.


Thanks

any more thoughts??

Hi-

I need to load data from database to sequential file without a deilimter, but with a fixed width for each coulum.
Like Column A takes first 1- 7 digits and Column B 8-16 , and column C is 16-30 etc..

Any thoughts , pls help.


Thanks

Versio 7.5.2

I copied them in the admin tool, but its not refleting in my jobs. I used environmental variables in my dev servers and used them in all my jobs. When I imported those jobs into my QA environment , i added same envirmental varibles with my new server info, so that i dont have to go and change in eac...

Any other thoughts.??

Hi-

How do I move the global environmental variables from one server to other server?? I copied them in the admin tool, but its not refleting in my jobs. After changeing environmental variables , do i need recycle or restart any thing??

Thanks

correct.

This is a simple ORacle to ORacle job

simple database to database job with lot of data..