DSXchange

... was going to let them realize and attempt to correct that. Was also going to go back and edit my answer to say 'a variation of the last one' but decided to just let it stand.

Honestly, I don't think we'll see any changes here from what little I know of what goes on behind the scenes. There has been talk of a completely revamped site to replace this one but haven't heard anything new along those lines for quite some time. Maybe someone has more insight into that? To your ...

They may not be invalid as much so improperly converted. Nature vs. nurture.

Hard to say without knowing the source and how the data is being manipulated before we got here.

ALL of the digits are 'considered' (one by one from the right) not just the one immediately following the desired scale. And you seem to have your examples (2 after vs. 3 after) backwards, not to mention we're talking scale not precision here and you call out things like a 'second six' when there's...

Where does the file come into play? All you've mentioned are two tables and then you say that you are 'not working with a database'.

In other words... the last one.

That just needs to be one if-then-else, specifically the last one.

Sorry, not one of the chimers requested as my experience is primarily with Oracle not DB2 but... If it's anything like Oracle you can't bulk load into a table with indexes, if they exist they must be dropped and rebuilt afterwards. There are times when that fact alone rules it out as the added speed...

So... still no joy on your conversion? If so, as a first step please post the syntax you are using. We'd also need to know what your decimal conversion rules are - rounding, truncating? For example if your source string was "2000.28" would the end result still be "2000.2" or woul...

Andy is saying connector and you are saying connection... and they are not synonymous. If by that you mean you don't have the user and password actually specified in the stage on the canvas, give that shot and see what happens. All of this is predicated on the assumption that this is your first atte...

Well, it is complaining about the password or user being incorrect and it has to connect to a database in order to have that issue. Are you certain that:

a) you are connecting to the correct database?
b) the user name and password are correct?

No flavor of Windows 7 is supported for the server side of DataStage. Check the requirements for what is.

Vaibhav, what operating system is your DataStage server on? You've marked the post as Windows but the error looks like it comes from a UNIX system and the advice in Andy's link is specific to RedHat Linux, hence the question.

Andy, Andy, Andy... taking all the fun out of learning to fish.