DSXchange

Hi Forum I will prepare a demo using DataStage 7.5.2 server and UniData 6, how i configurate this conection??? in the pdf says change the uvodbc.config, but dont says thats necesary install unidata client in the DS server ,, is necesary??? or DS dont need its??? I need to know all steps to prepare t...

Hi, In my DS server was defined one project to one user, now i have 25 projects, i want to defined the rols and permissions in DS and Unix. Each directory project in UNIX was asigned to the user group and directory permissions, and assigned the respective rol in Administrator using the dsadm (DS adm...

Hi DS_FocusGroup,

The sqlldr was founded, because in previous load insert 150000 records, when this number is increased the process abort ...

Hi forum !! My job is running in an AIX server with DS EE v 7.5.2, now i trying to insert record into oracle using the oracle enterprise plug in. In the sequential file i set the attribute Read First Rows = 150000 and run and insert without problems. I change the value to 350000 and my job abort 30 ...

gateleys,

Last time did not appear this value $PROJDEF only $ENV and $UNSET ... i change the default value with $PROJDEF, try to view the data and work ok !!!

I export the job to certificacion and try to view again and can see the data...

thanks !!!

Ok now is working ... thanks. I have a new question about that. How create a job will use the values of Environment Variables in the job parameters???? For example: Job1 in Desarrollo use the follow parameters and values pXCP_DB = BASE1 (define in XCP_DB in Administrator) pXCP_USER = u020 (define in...

Hi gateleys, Both files contains the values defined in this administrator window for each one, in desarrollo and certificacion are differents. DSParams from Desarrollo [EnvVarValues] "XCP_DB"\1\"XCPDWX_odbc" "XCP_USER"\1\"IU231275" "XCP_PASS"\1\"...

Hi Teej,

In my job i'm setting job parameters and load this environment variables to the grid. There aren't hardcore values in the job.

And, this environment variables are news and doesnt exist in the dsenv file

Hi Ray, thanks for your help, but dont work, i changed the variables in Desarrollo and close the window. open another administrator and set new values for certificacion, and press Ok button ... In the manager open the job from the Desarrollo and Certificacion projects, but is the same result ... sho...

Hi gateleys

I change the values for empty in Certificacion project user variables, and open my job, view the odbc stage and show me the Desarrollo values again.

Is necessary restart the services to take the last changes????

Thanks.

Hi Forum, In my server exists 2 projects, Desarrollo y Certificacion, and each project access to different oracle database. I set in my jobs the environment variables for each project with diferents values, but, when i open the job in Desarrollo shown the rigth values configured for this project, an...

Hi Forum, I'm working in Data Stage Enterprise 7.5.2 in AIX server 5.3, and i need to obtain the difference between two dates, in server version i use iconv for both fields and obtain the result, but in parallel i can't .. Anybody has an answer ?? Is there another choice to obtain this result?? Thanks

Can you show the routine code to evaluate???

Can you show the routine code to evaluate???

Hi ratuldey, i used the space between the id mails and worked.

Example my.mail1@bd.com my.mail2@bd.com

Initially used comma but give an error in the director log. try with this option.