DSXchange

I am trying to get the system date and time into a oracle table. I am using Oconv(Date(),"D,YMD[4,2,2]") and giving the datatype as Timestamp in datastage. I get the date in the oracle table but the system time displays as 00:00:00. Do i have to give it another format to get the time . Ple...

[quote="thumsup9"]RowCount = DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
quote]

What should i substitute for each of these "hJob", "StageName", "LinkName", "DSJ.LINKROWCOUNT"

How can i get the record count of a specific input column in a transformer
along with the other transformations.

And can i take out the max value of the Record Count. I do not want to use a aggregator for this.

I have a script written and i need to run the script in my datastge job and also use the output of the script in the same job for further transformation.

how do i do it?

In the query there is order by three fields (ie order by 1,3,4) and i used sort stage to satisfy that , but the data is not sorting . any clue why this is happening? any other solution to sort apart from this? Click on the blue part to go to beaditya's relating post. How are you exaclty specifying ...

Yes "MATCH" works like magic !! ... still figuring out if i am getting the right output ..

In the query there is order by three fields (ie order by 1,3,4)
and i used sort stage to satisfy that , but the data is not sorting .

any clue why this is happening?

any other solution to sort apart from this?

I have a job where the i need to implement the query using stages the query looks something like this SELECT A.RACCOUNT C.REP_TO_ACC FROM VB.R_M_LAST A, VA.M_H_LAST B, VA.M_H_LAST C WHERE A.M_ACCOUNT_NO = B.M_ACCOUNT_NO AND B.REP_TO_ACC = C.M_ACC_NO AND C.HQ_IND = 'Y' AND CURRENT DATE < A.REDEPLOY_E...