DSXchange

Hi Arnd, Yeah the batch id is coming from the data itself. Thanks a lot Arnd. It really make sense and I proceed based on your input. chao, gopskrish Gopskrish, Is this Batch ID coming from the values in the data itself? If so, at the end of the run you will need to store the highest BatchID somewhe...

Hi,

I want to round the number to 2 decimal places in parallel extender.
I dont have oconv or fmt function over there. Let me know hot to attack it.

Best Regards,
Gopal

Hi ,

Thanks for helping me out on that. It is really working great. Great job and u have prooved that datastage is really fun. Nice job.I have been fighting with this for almost a day.

cheers,
gops

Hi Everybody, I am loading data to sequential flat file with sybase as my source using paralex. I am not getting the number columns in proper format. If the value is big, it gives me an exponential value. In the target i have specified as float (same as the source) When i changed to numeric(9,2) it ...

Hi, This is what i got in the log. CopyOfPrice_Seq..JobControl (@Coordinator): Summary of sequence run 11:42:32: Sequence started 11:42:32: Set_Parameters (ROUTINE DSU.UICISetJobParamsFromFile) started 11:42:32: Set_Parameters finished, reply=1 11:42:32: Exchange_Extraction (JOB CopyOfFXRate_Extract...

Hi Everybody, I am taking data from Sybase and loading the same in flatfile. For all the columns which are of type float, I am not getting the same value in the target (my target type is also float) I have changed the target datatype to varchar,decimal etc., but i am not getting the result what i wa...