DSXchange

Hi Craig nope done nothing with that ... thought the error was because i did not specify a column seperator in the stage ... cn you please throw some light into the issue you think it to be??

Hello I am trying to use sort stage to sort data in a fixed width file , I havent specified any delimiter as a fixed width file does not have one.... the job is failing with error Error in retrieving stage property values DSTAGE-SORT-0048`:`Invalid value for stage property 'Column Seperator' Can any...

Hello All,

I want to write a PX routine. My requirment was i want extract two columns runid and rerunid which will stored in a particular table. For this i need to write a parallel routine. How can i do that. Please share me the code if anybody knows. I am totally new to rotines.

Thanks in Advance.

Hello All, My requirment is: I am loading the data toa file and passing the file name like this. #Tempfilepath#/#subject#.txt, Here i am getting #Tempfilepath# from parameters, but #subject# is not defined in the parameters. I want to extract the Subject from the tempfilepath sya suppose. \data\ds\1...

Hello All, My requirment is: I am loading the data toa file and passing the file name like this. #Tempfilepath#/#subject#.txt, Here i am getting #Tempfilepath# from parameters, but #subject# is not defined in the parameters. I want to extract the Subject from the tempfilepath sya suppose. \data\ds\1...

Hi Chulett,

I got your point. But i have almost 50+ jobs using this container in Live. Then i need Recomiple all those jobs manually. Already these jobs are running in Live. Please suggest me how can i corporate in a simple way.

Sorry to trouble.

Thanks

Hello Chulett, Thanks for the reply, As i am working on the shared conatiners for the first time.Can you please elobrate your suggestion. I didn't catch your point. The change which i want to do was i need to add extra transfomer stage to capture the message handling. After doing this change if i re...

Hello All, I have Parallel shared container for surrogatekey generation, this container was used in so many jobs. My requirment was now i need to modify small change in Shared container.If a modify then how can i incorporate this change in all the jobs that is using this conatiners. Please suggest m...

Hi,

I resolved the issue with the below function.

CurrentTimestampMS() :"." :Right("000000" : @INROWNUM,6)

Thanks for all who have replied to my query.

Hello ray,

As i didn't have a premium aaccount, could you please send me that command which works in parallel jobs. Sorry for troubling.

Thanks
Pavan

The same function is working in server jobs Oconv(Date(), "D-YMD[4,2,2]") :" ": Oconv(Time(), "MTS:") :"." :FMT(Mod(@INROWNUM,1000), "6'0'R") i am using the below function in parallel jobs but no luck CurrentTimestampMS() :"." :Right(Mod(@I...

I am using datatype as timestamp(26,6).....but that didn't work...output is coming like this 2010-12-30 05:01:44 But i need the output like this. 2010-12-30 05:50:30.000001 and the last one should be incremented for each new record like below. 2010-12-30 05:50:30.000001 2010-12-30 05:50:30.000002 20...

Hi All, I have a small requirment in parallel jobs. I want output to be like this. 2010-12-30 05:50:30.000001 - - - - for first record 2010-12-30 05:50:30.000002 - - - - for second record I have used the following function in transformer stage but didn't work. CurrentTimestampMS() :"." :Ri...

Hi Freinds, I am pretty new to datastage, Any body can you please provide this usefull information. 1. If a job is compiled in Datastage what happens in the backend. 2. If we run the job in Datastage Desighner, how it connects to manger.....i want to know the complete process in backend when we run ...

I tried with this function RowProcCompareWithPreviousValue(StageVar3:StageVar2:StageVar1) with the following data. Input data A B C -- ---------- ---------- 1 1 1 1 2 3 2 2 2 2 3 4 I got the Output data A B C -- ---------- ---------- 1 1 1 But i want the output data as A B C -- ---------- ----------...