DSXchange

Mike, can you be a bit more specific about where one can change the default decimal format in a parallel job? Are you perhaps referring to the NUMERIC category in an NLS locale?

As the others have noted, try at all times to create hashed files on local drives. The main purpose of hashed files is to provide fast, local, lookup capability.

I did not ask whether you had resolved it. I asked what you had tried, so that we don't waste our time covering myriad possibilities that you have already eliminated.

DSguruji wrote:Storage Area Network

More usually Storage ARRAY Network - an array of storage devices (disks) connected with intelligent controllers so that they can be managed as a single entity or partitioned as required.

The best practices class is no more; it disappeared before Ascential was acquired. There is a Best Practices document produced by the IBM Information Integration Solutions Center of Excellence, but this is very strictly for internal IBM use - that is, by their consultants and internal product evalua...

Is your H: drive local or remote? You will find (by searching) that using mapped network drives is not supported; you will need to use UNC pathnames.

And even that won't work if ALLOWNFS in uvconfig is set to 0.

Get a better requirement.

Seriously.

If the data type is Char(3) then the Null Field Value property must contain three characters.

Indeed, any value in the field must contain exactly three characters.

Null Field Value is an example of an in-band null. An import operator converts it into an out-of-band null.

$DSP.Open is the function used to connect to DB2.

Verify that all the connection information goven in the stage is correct and that, if needed, the DB2 client software is correctly installed and configured.

I would rather advise you to create two separate jobs, for ease of future maintenance if for no other reason.

Yes, I'd like to see the value of LD_LIBRARY_PATH (rather than how you've defined it). You can get this from the second event in a job run, or by executing the dsenv script then issuing an echo $LD_LIBRARY_PATH command. I'm thinking that dshome (sic) is not set for DataStage processes (this is not t...

Alert your BA to the fact that that decision will mean that week #53 in the year has fewer than seven days, and that roll-ups by week will be invalid.

Too simplistic, grasshopper. See above.

There isn't one. The reason is that the week number is determined by a business rule. On what day does a week start? How is week number 1 in a year defined (all weeks must have seven days, so "starts on Jan 1" is not a good rule). Look at the Transform WEEK.TAG and the WeekTag routine that it calls....

Thanks a ton Ray! I plugged in your code and concatenated with "V-" and it works great except for 5 & 6. (Values after ----------------> are the results) 1. "3.5 L V6 24-Valve DOHC" ---------------------> V-6 2. "3.8 L V-6 24-Valve DOHC" ---------------------> V-6 3. "4...