DSXchange

In Sun Solaris: version 2.10 = version 5.10 ?? Yes SunOS was renamed Solaris. SunOS 5.10 is Solaris 2.10 In DataStage: version 7.5.1.1 <> version 7.5.1 ?? 7.5.1.1 is 7.5.1 with fixes. In DataStage: version 7.5.1.1 <> version 7.5.1A-OEM ?? OEM (other equipment manufacturer) means that it's supplied ...

DataStage server uses multiple processes rather than multiple threads, with very few exceptions (for example the sort engine is multi-threaded). Since separate jobs run in separate process you can correctly deduce that their local variables are independent of those in other jobs.

1. Any jobs presupposed by lookups. This includes lookups to be used in existence and change detection for Type 2 SCD. 2. Extract data from source to text files (rather than staging tables) - in your case they are already text files. 3. Pre-processing of source data (for example removal of header/tr...

The directory pointed to by UVTEMP may contain any of the following. - temporary files when compiling sica constraints ('compconXXXX') as part of DataStage SQL security - temporary files used for sorting (partitions files that are then merged) 'sort'XXX') - temporary files for EXECUTE...CAPTURING ('...

You can select only current data from source, using an appropriate WHERE clause, if the records have some date/time column you can use as the basis of this selection. That feeds the job that populates the data mart. A separate job can be used to purge the data mart tables of records more than a year...

RECORD.SIZE is not the correct option for 64BIT. 64BIT is. RECORD.SIZE specifies the average record size to be stored, which causes DataStage to calculate GROUP.SIZE (and, implicitly, LARGE.RECORD).

And it's "hashed" file, not "hash" file. A hash file is used for filing hash.

... and the actual limit is undocumented, so you will need to determine it by experimentation. If you do, please post your findings.

You already have it. It's part of the Server to Parallel Transition Lab. There are various parts therein that discuss "how you do this in server jobs". Just need to tidy it up a bit. Should be out some time before Dubbya orders the destruction of the planet.

In a Transformer stage explore the conversion functions and the casting functions. You can also search the forum, since this question has been addressed in the recent past.

(1) A job can never become uncompiled. All you need to do is to reset the job.
(2) Precisely how do you supply the parameter value when you request the job run?

What are the business rules associated with casing? For example, are accented lower case letters to lose their accents when converted to upper case (as in French in France) or not (as in French in Canada)? Do any characters such as the German "β" have to be converted into multiple upper case le...

You can run them in the PX environment subject to certain restrictions documented at the end of Chapter 2 of the Parallel Job Developer's Guide - however you will get reduced, rather than enhanced, performance because the strongly-typed environment of PX must convert to the typeless environment of s...

No.

(If (SrcColumn < 0) Then "-" Else "") : Fmt(Abs(SrcColumn), "R%" : (4 - (SrcColumn < 0))) or If SrcColumn < 0 Then "-" : Fmt(Abs(SrcColumn), "R%3") Else Fmt(SrcColumn, "R%4&quo...