DSXchange

I have 2 stage variables in Transformer . My requiremnet is, the two stage variables should be concatenated if they are not null. I tried like this If IsNull(A) Then @NULL Else A: If IsNull(B) Then @NULL Else B But If A is not null and B is null, I get the o/p as Null. Is it that concatenation of a ...

Is there any command to clean up log of a job in administrator.

I know this can be done using director. But I want to know is there a command to clear job log in adminstrator

I ran a job. From the source there were around 100000 records coming. While running the job for testing, I forgot to to take care of the warnings options: i.e abort after 'n' warnings. So, the director is thrown with full of errors due to single mistake in code. I stopped the job. But still the warn...

Ok, I got the solution When I opened the Oracle Stage, It is getting opened in minimized mode. So, due to this the screen appears and not able to touch any other stages. Dont know how the Oracle stage is opening in minimize mode by default

I noticed that only when I click the Oarcle Stage in my JOb, The designer is getting hanged. The job had Tranformer and Hash Stages also. When I click Hashed File or Transformer, I am ble to navigate and designer is not getting hanged. What is the problem with Oracle Stage. I was using ORA9i stage

Yes, I can open director and manager

I opened a Job, and trie dto open Oracle stage. It didnt open, instead I am unable to edit any othet stages. i.e I can only move the curso, but could not even highlight any stage. I restarted machine, but no solution. I dont know why this problem occurs. Upto Yesterday, this was working fine. What i...

I have a Column COMM_RESERVE_CODE_SET in Look up Hash_Comm_Reserve_Code which is a concatenation of 6 strings delimited by ','. I have another column ACTIVE_RC in another Look up Read_ResTgtReports which is a concatenation of 15 strings delimited by ',' My Requiremnet is If ACTIVE_RC contains any on...

i dont think i can mark it as resolved as i didnt start this topic. i juts continued it from a point.

But if i can , tell me how shd i do it. i am not able to find any tab where i can its resolved.

Ok, so now you are calling the job using Routine which reads the Hashed file as well. no.. in my sequencer, the job to populate hash file from tables runs first and in the before sql , i m loading all the file names in the table. And after this job, i have a routine stage to get the file name from ...

Thats good. But how could you frame a filename by reading the value from a Hashed file. Are you reading the hased file and passing it as parameter to a Utility that calls the Job which need to produce the file? my table has 2 columns. One column is name and other is value. i am entering a record wi...

No version 7 is not supported with this functionality. You can only use "@Date", but again it will change it to literal values. You need to use After Job subroutine may be. Ok... so u mean its present in 7.5 but not in 7.0? But i figured a solution. i have created a table and from here, i...

What is the version of Datastage. Iam not sure on version 7. Check "@Date". But do check you get the value of Date and not Exactly as @Date. i am using 7.0 and the problem is not with the Date or DATE. the error is "only numerics or alpha-numerics allowed in the value expression. Do ...

What is the exact expression that you used there including the file name? Paste it here In the sequential file stage, i am passing the file name as file_#date1#.txt and i have defined date1 as a parameter in the job. Then a developed a sequence job which calls this job and in the Job Activity, unde...

First just try @DATE then go ahead with Oconv(@DATE,"D2") and so on.. so that you can nail down the issue. i tried @DATE but it gave me the error "Only Numeric or Alpha-Numeric allowed here" Whats the solution for this?? If i put this in quotes('@DATE') then a file is created wi...