DSXchange

Search the forum for discussion about why floating point numbers are (and cannot be) stored precisely in computers). Think about changing the data type from dfloat to decimal or even integer before performing the division.

Not only partitioning. Sorted order is also preserved in Data Sets.

devanars wrote:I need to get an advise from you guys and figure out what are all the codes have to use for them. Appreciate your help

Thanks

Then why won't you answer our diagnostic questions?

Do you have access to a second system (production, for example)? Can you (or they) find libdsplugin.so there? If so, and it's a compatible system, you could copy from one system to the other. Otherwise restore it from system backup. This is a vital library; it provides the underpinning of all plug-i...

What ELSE is happening on the production computer (that is, consuming resources) that is not happening on the development computer? Don't say "nothing"; that is clearly incorrect. Monitor the systems and find out. Are you processing the same data volumes in each environment? It's HASHED fi...

Lots of experience out here but less, of course, with the newer technologies. But it's ramping up even as we ponder.

That is NOT a fixed-width format. If it were, every record type would have the same length. What you can do is define every field as Char data type and the field delimited as 000. Do you need to profile header and trailer information? If not, pre-process the file using a DataStage job so that it onl...

IBM claims to have a tool, which they only offer as a service, and for which you have to agree to your work being sent offshore (I believe to IBM in Bangalore).

Explicit, because you don't get any warnings. Also you have greater control over resources allocated to the sorting process.

There is no file called DSR_JOBS. If the software is claiming this, then there is an error at least in the error message string. Report it to your official support provider. In the meantime, what exact version of DataStage are you using? Can you access other projects on this server? Can you access t...

That statement does not address any of my questions.

How many fields are in the Result dynamic array?

I'd also like answers to my other questions, but you will need premium membership to read those.

Do you have ANY idea what you are doing?

My guess is from this thread into their DataStage environment.

If you need to handle "" differently from NULL, you need to specify something other than "" as the representation of NULL when reading from the sequential file. I suggesst the character string "NULL" unless that is likely to occur in your data. Don't worry about padding...