DSXchange

Can u please provide me in detail on How can I pass it through a transformer stage????? Can i use Source as a Transformer...If not then If I use a File Stage as source and then add a transformer......I will not be able to create a file On the Clients Side in their Source folder.......How do I solve ...

Hi all, My requirement is as follows: I have a stored procedure which I am calling through the Job. The Jobs work is only to call that procedure using a stored Procedure using an ODBC Stage. The problem here is we have to pass three parameters to the Stored Proc. i.e. Current Month, Current Year and...

I didn't get your point.
you said

Trim() never removes the last of any set of internal spaces.

But Trim(Link.Column," ","A")="" can removes the internal spaces right???......Thats the reason I used it in my Jobs.....
If not Please explain.
Thanks in advance.

Heyyy Guys, I have got the solution for this problem :D . Following is the code which worked : If (IsNull(Link.Column) Or Link.Column= 0 Or Trim(Link.Column," ","A")="") Then Oconv(Iconv('99991231',"DYMD"),"D-YMD[4,2,2]") : " 00:00:00" Else...

Hi All, My source data contains date in the format "20060101" which I convert and insert into the target table using the following functions: Oconv(Iconv(InLink.TheDate,"DYMD"),"D-YMD[4,2,2]") : " 00:00:00" as suggested in another thread some days back. This i...

sorry I had misguided u somewhat with the condition in my earlier message .... so here's the modified one.... Directly write the following condition in the derivation for the 'Name' column in the Transformer stage that "If inputlink.code='A' then 'AAA' Else inputlink.Name" This will work.....

Why use a StageVariable?
Directly write the following condition in the derivation for the code column in the Transformer stage that
"If inputlink.code='A' then 'AAA' Else inputlink.code"
This will work...... why complicate things unnecessarily.......

Do you have the DataStage deadlock daemon running? This will periodically clear the locks held by redundant processes. ... I have no idea of this "DataStage deadlock daemon " How to keep it running so that it will clear the locks periodically...It would be of a great help. Also I didn't u...

I was accessing a datastage job from my clients DS Server, while working on it my connection with DS server lost giving me an Error Message "Error calling Subroutine........". After that I closed and Opened DataStage Designer again, when I tried to access the Same job again, It now gave me...

I will be able to show you this value only on Monday since my weekend has already started .
Till then please suggest if you get any idea about this issue.

I am using the date() function from the Transformer Stage. The database format(scale etc.) is same for both the database. so if it works on windows environment it should work on Unix. Nothing has been changed from job level to the database level except the Environment. Is it that Unix excepts someth...

Hi All, I am facing one strange problem. I have a DataStage job created in Windows Environment, in which I use a Date() function to pass Sys Date in the Target DataBase(Oracle9i). Its working fine. But when I Executed the same Job in UNIX Environment it throws a Warning Message saying "A non-Nu...

Yes....When I run individually as it is they run fine........Only when I run them through the Sequencer They fail giving the above error..............but the assignment of the parameters in the Job Activity stage are correct I had checked them if I have passed the proper parameter in the sequencer.

When I execute a Sequencer Job with all the parameters specified propely; the sub-jobs called(executed) through that sequencer gets aborted with the following error message " ORA-01005: null password given; logon denied". My password is in encrypted form, I removed password and entered it ...

Looks great Gateleys...I will surely give it a try and let you know.......Also thanks DSGuru.....I will suggest my client regarding these ideas so as to ease things lets see how much I succeed