DSXchange

Thank you ray for your response. Here i am using comma delimited file . seq ------> transformer -----> oracle I specified following properties in seq stage like Field delimiter ------ comma record delimiter ---- none. I specified all the fields as char or varchar. I am not specifying any length in i...

Hi Everybody , I am working on datastage from the past 3 months.We are working on DATASTAGE 8.0.1 version on LINUX box. I am facing some problem in NULL handling .My scenario is as below I am having a sequential file . its a COMMA DELIMITED. 12,99,jkl,10082008,a 12,,mno,,a 13,20,klo,11062008,b So i ...

Thank you very much ray ....It worked....

Hi everyone , I am using DATASTAGE 8.0.1 version on LINUX box.I am facing following problem : I have a job with below design seq ---->>> transformer -----> oracle enterprise stage I have a NUMBER field in the input sequential file .I am reading it as integer.But when i am getting data as an empty st...

Hi Everybody , I have problem coming in a job which got executed successfully many times.Now the same job is throwing some error which i am unable to comprehend what it is ? I have a job like this seq ---->>>> transformer ----->> oracle enterprise . Its giving fatal error when i am executing that on...

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

Thank you chulett for your response .But , In DRS Stage there is no provision for giving job parameters to username and password .Thats where entire problem came

Hi , I have some 100 jobs designed .My database is oracle .But , I am using DRS stage instead of oracle enterprise stage because oracle enterprise stage is giving some sql loader error . with DRS stage , all jobs are working fine . But , If the usernaame and password is getting changed i need to cha...

Hi Everybody , Thank you all for your response .My issue is resolved .I am using dsjob -wait option.Its working fine .Thank you chulett for your suggestion.Actually I mentioned just part of our design .If we take entire design into account , then we are unable to put that parallel job into the seque...

Hi Everybody , My issue is resolved .I am using dsjob -wait option.Its working fine .Thank you chulett for your suggestion.Actually I mentioned just part of our design .If we take entire design into account , then we are unable to put that parallel job into the sequence .Thats why we are going with ...

Thank you Arndw and ray for your response .I will try that option and let you know the status

Hi Everybody , I am using IBM Information server 8.0.1 Version.I am a novice in datastage .I wrote a shell script to invoke many jobs .I have the following scenario: s1 --- sequence 1 j1 ---- parallel job 1 I want to run the sequence completely and then run the parallel job .This is the design which...

Hi Everybody , We are using Information Server 8.0 .We have a requirement where we need to get the latest file name and process in datastage. For that I am using ls -lrt command and storing the latest filename in the UNIX variable INPUT_FILE. We parameterised that INPUT_FILE_NAME in the parameter se...

ok , Thank you for your reply

Hi ,
I wrote a Transform for a some logic .How to call that user defined transform from a parallel Job ??