DSXchange

When I am writing into a fixed width file having a column as decimal.
It introduces a space into a file.
For ex. Column xyz decimal (10,2) -Null field value for this column has 10 spaces.

But when this column is seen in the file it will have 11 characters including a space at the start of this column

Thanks every one for your replies. The problem was DS was rounding the digits and which in turn was not giving the expected output. Once rounding is taken care of , it is displaying the correct results :D

I have exactly same requirement as this old post. But If then .... less does not work when I write A<0 and the value of A is 0.068 and it satisfies condition in this case. But I believe 0.068 should be considered more than 0

I got a workaround for this. If I maintain this field as varchar in datastage everywhere and use to_timestamp(InputColumn,'YYYY-MM-DD HH:MI:SS.FF) in Oracle user defined query and keep this column as varchar in Oracle stage also - It Works While reading from Oracle , again I make this field as varch...

First I defined it as Date and now I have it as showing TIMESTAMP(6) in Oracle when I defined it as timestamp

I am getting a varchar column having timestamp field with microseconds in format 'YYYYMMDDHHNNSSSSSSSS' I convert this using transformer into 'YYYY-MM-DD HH:NN:SS.SSSSSS' and this gets successfully loaded into target ORACLE10g database. Now in Oracle When I keep this field as date , It shows me last...

One more thing, this is a test file which I am loading into database and then finally reading these records from database table. I can modify the file as required but what to change.

It is a same input file which has change in a different column.This particular column data is unaffected

It was working good in morning and now it is again giving column length and not the character length even when I am using APT_STRING_PADCHAR as '0X20' Nothing was changed in the job

Thanks a lot SURA. It resolved the issue

No, It gives the full length of column

I need to calculate the length of characters in a CHAR column ( Source is Oracle ) so that I can filter out the data depending on the length ( length means the actual length of characters and not including white spaces which comes with CHAR field

chulett Datastage version 8.0 Master sequence log has only 3 lines ( I cleared the previous logs). I asked the same question to our ETL architecture team, and they told that this is happening because of 6 parameter sets being used which in turn use more than 1400 parameters. Because of this Datastag...

I have a master sequence calling 9 different sub sequences. These subsequences are scheduled to run sequentially inside master sequence. But when I run this master sequence, it takes more than an hour just to call the first sub- sequence and display following message in log file : Starting new run o...

I am getting following Error message in Datastage " Oracle_Enterprise_3: Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:0" It is a simple loading Job into database table running in Load Append Mode But when I run...