DSXchange

In hashed file NULL is always NULL. Internally in hashed files NULL is represented as Char(128), but the translation is automatic. It is only in text files that you need to specify how NULL is represented. My question was whether the default handling is the same in version 8.0.1 as it is in 7.5x2, b...

Keep experimenting. Curiously enough, we don't know all the answers. There are known unknowns, and there are unknown unknowns.

Post your results.

Unable to view full sized image. "Click here" had no effect. Using IE6.

Can you show as text, between code tags? Or at least the definition of, say, the K1 column?

Have you specified different NULL mapping in the job? What is the default null mapping in each version (I don't have 8.0.1 where I am)?

Did you try floor as the rtype?

Why would you want to? What would be the ramifications if you were to mark a job as finished but, in reality, it was still running?

Right outer join is not possible with a Lookup join. If you reverse the sense of the stream and reference inputs and do a left outer join (rule is "Continue") then you have a functional equivalent. However, this is not feasible if you have multiple reference inputs. You need to use a Join stage in t...

Yes, a full restore to a clean system will reinstate whatever it was that was backed up - in your case the 7.5 system.

The move to version 8.0 involves many things but, as far as DataStage projects are concerned, export/import is the method of choice.

1) No. If anything there is a slight disadvantage. 2) Unless you have specified a different key separator character (and if you don't know how to, you haven't) you separate the column values with text mark characters. In your example the expression would be of the form K1 : @TM : K2 : @TM : K3 In pa...

Why not use the DataStage Manager client? That's what it's for (among other things).

... but now a new patch named AIX 5.3 ML-07 SP-04. The problem infact came after the new patch installed. How to avoid stating the bleeding obvious...? If you want urgent help sign up with your support provider for premium service and learn the true cost of "urgent". DSXchange is an all-volunteer s...

There are four rtype arguments you can use with decimal processing; ceil, floor, round_inf and trunc_zero. The default is trunc_zero.

Read about them in Appendix B of the Parallel Job Developer's Guide for more information.

The only way you can specify different environment variable names IS to specify different environment variable names. Otherwise you'd need to create a reference to something that contains the new environment variable name, and a means of evaluating that reference so as to decode the environment vari...

Restoring from a complete backup should re-create all the components including the jobs. You ought not to need to do anything else.

No. UPDATE is, by its very nature, slow. Think about all the things UPDATE has to do.