DSXchange

Some useful date routines for solving the Australian daylight saving question. FUNCTION LastSundayInOctober(Year) $COPYRIGHT "Copyright (c) 2004, Ray Wurlod. All rights reserved." $* Calculates the date of 01-November in the year in question, then steps backward until a Sun...

Your shared container must have a means of sending its results out. You need something like this: ++++++++++++++++++++++++++++++++++++++++++++++ + OCIStage ----> HFStage -----> COutput + + lk1 lk2 + ++++++++++++++++++++++++++++++++++++++++++++++ where COutput is a "Container Output" stage. In your j...

Yes, you can. You can also create a DataStage BASIC routine to do it. You, however, (or the author of the script/routine) need to figure out the placement and indenting rules. There's one major gotcha; if the job uses Container stages or shared containers, the parameter handling is different; only t...

Do you want to put any constraints on responses? For example, if you have an eight CPU configuration, then a response from a 32 CPU configuration would not be particularly useful to you; scalability is nearly linear, but not exactly. Are you talking about a single SMP system, or an MPP cluster?

It's a known issue that job sequences don't get exported to the Documentation Tool.

Not enough information.

What is the data type of the column in question?
What (from Debugger perhaps, check "break on warnings") is the value that you are trying to load?

The only things of which I am aware that will generate a Run Stopped message is a Stop request - either issued manually from Director, or by a call to DSStopJob or the -stop option for dsjob. When a run stops because of a row limit, there's an event in the log to indicate that this was the cause. Re...

You've got a problem. The VOC file should not be more than a few tens of KB in size. In a newly created project on UNIX (I just happen to have one of these today, without NLS enabled) the VOC file is 102,400 bytes. In a five year old development project, the VOC file is still only 796,672 bytes. Thi...

DataStage (Administrator client especially) does not like empty password.

I think Siva's seeking examples and/or names of the "third party software". FWIW he is running on AIX.

Thinks... Daylight saving can be handled most easily using the Julian date (that is, the ordinal number of the day in the year). OCONV(date, "DJ") gets this. In Australia, if this is less than the finish date (Julian form) or greater than the start date for daylight saving, then no adjustment need b...

You should be able to specify the development server as a resource in the configuration file and do it that way. Please note, however, that I have not tried this.

Currently, no.

I guess that raises the question whether you have to be able to do this only for current dates, or possibly also for historical dates (and, if so, how far back). Hmm... It's also the case that the TZ environment variable has a different value/format depending on your UNIX. Here are two examples, the...

The sequencer's own parameters' default values are viewable at design time using the Job Properties dialog. Parameter values with which the sequencer ran are in the "started" event in the sequencer's job log. Run time default values can be viewed in the Director client's Job menu by choosing the Set...