DSXchange

Hi Sam,

My case is I have to read data form table and update the same table again. I do not want to lose data by conversion errors.

Hi Freddie, First of all ,if there is a posibility to store the Last Run Date of the Job / File Name then below approach will work. 1.You have to prepare a simple shell Script which can List the Files , filter the File names which are greater that Last Run Date of the Job/ File. Write these list int...

Hi , I am trying to read a column BMIPercentile defined as FLOAT in SQL Server Database using ODBC Connector Stage. I have specified column definition as Type=Float , Length=53 , Scale=10. My Job is aborting with below Fatal error . Schema reconciliation detected a size mismatch for column BMIPercen...

Thanks Zulfi.

Hi, I have been looking for a way to cleanup Datasets created by DataStage.I have found ORCHADMIN but scenario is different. My Jobs overwrite DataSet (*.ds) files for each run. But the files in Dataset path in the config file some times do not get deleted. If we use ORCHADMIN to delete it deletes t...

srinivas.g wrote:Ignore previous post. Use below command
use this option in Transformer stage :Column name[1,len(columnname)]

Thanks Srinivas.
This helped to solve my problem.

Thanks,
Mandy

Hi Pavan,

Let me know the version that you are using?
I am not seeing any warnings in IS 8.5.

year_cutoff is always there.

Hi Pavan,

Use StringToTimestamp((col1.DATE:' ':col1.TIME),'%mm-%dd-%1950yy %hh:%nn')

Here 1950 is year_cutoff. It means any year between 50 - 99 will be prefixed with 19 and any year between 00-49 will be prefixed with 20

Hope this might solve your problem.