DSXchange

Provided they are relevant there's no such thing as too many comments.

You're not missing anything. (!) DataStage itself uses float or dfloat internally, for example in the Aggregator stage to prevent arithmetic overflow. There's nothing available in the Oracle Enterprise stage to allow you to change the behaviour I described - though you could use an upstream Modify o...

Floating point potentially has more than 10 decimal places. DataStage alerts you to that fact with this message. Create a message handler to demote or suppress it, or stop using float (or dfloat) as the data type, or provide an explicit conversion. With SQL the conversion is automatic, so there's no...

One word: SEQUENTIAL

It's a bottleneck. Also, data have to undergo export when being written and import being read.

Prefer Data Set, where none of the above apply. The operator generated by a Data Set stage is copy - which should speak volumes. Partitioning and sorting are preserved.

Sequential files do not have data types. Export is the process of converting data to human-readable format. You need to do this when writing to a sequential file. Because they have no data types, sequential files don't have a NULL. Therefore you have to tell it how to represent NULL. You do this thr...

The first error message relates to the default value for the decimal type - technically 0.00 ("all zeroes") is not permitted. There is an environment variable - whose name I don't recall at the moment - to allow "all zeroes". The second error is mysterious - the field does exist in the schema, thoug...

Pre-process the file (with tr perhaps) to convert all the ";" characters to line terminators - that way you will have one value:data pair per line. If you use tr as the filter command on a Sequential File stage, the stage will read stdout from the tr command as the source.

There's a separate option on the Import > Table Definitions menu for importing stored procedure definitions.

What are the quote characters in (@RECORD,':vTableName',1 meant to be doing? Since it's still inside the backquotes it's within the string. You're also missing a concatenation operator. Try cmd = \SELECT EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,\ : vTableName : \,1) > 0 THEN 'FOUND' ELSE 'N...

DataStage can use the sequence. Specify user-defined SQL in which you provide sequencename.NEXTVAL rather than a parameter marker for the key column.

The vendor offers a range of training classes. Consult their website. Some third party providers also offer training classes.

How about this for a theory? Your 1100MB file fills 999MB of cache but is not finished populating the cache before the 700MB hashed file checks and finds that there is no room left in the cache. I don't know for sure that this is the mechanism - it's more difficult to get advice about internal mecha...

What precisely is your question? Or are you just letting us know? What precisely are you doing, and what messages are displayed? Are you getting a list of server B's projects when you authenticate to server A? (If so, I would suggest that you check very carefully that you are indeed connecting to se...