DSXchange

If the described data object exists somewhere (database table, text file, etc.) then you could import it from there. Otherwise no.

1. Create a complete specification in English.
2. Hire a competent C++ programmer to create your code.

1. Create a complete specification in English.
2. Hire a competent C++ programmer to create your code.

For so few fields type it in manually. There is no metadata import tool geared to the format you have specified.

Arnd meant that you should try Decimal[18,3]

Arnd meant that you should try Decimal[18,3]

DataStage is a 32-bit application. You MUST use 32-bit libraries with DataStage, even if these are accessing a 64-bit capable instance of DB2. Verify that the 32-bit library is referred to first in the shared library search path set up in the dsenv script. Ask your DBA for information about what the...

Announced at IOD 2007 was FastTrack, the latest toy in the toy box. At its simplest it looks like a spreadsheet for documenting source-to-target mappings (which, indeed, it is). However, you can browse for the source and target columns in the common Information Server repository (they may have been ...

Well done!

Now please mark this thread as resolved.

Well done!

Now please mark this thread as resolved.

Well it looks like the driver has (falsely or otherwise) detected Oracle 7. This is a mystery and may be a bug - I can't see anything in your configuration that would cause that. Time to involve your support provider.

The quick fix is to read as delivered and divide by 100. Further thought and experimentation is needed to give a technical solution, and I don't have access to Enterprise Edition just at the moment.

Add a reject-handling output link to your Transformer stage.

(Only fix one thing at a time. Let us know if that fixes changes anything.)

Show the syntax you used with StringToDecimal().

My answer above is a complete answer. You will need to enrol for premium memberhip in order to be able to read it all. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. The premium membership fees are 100% devoted to this purpose. It's less than 30c per...