DSXchange

ray.wurlod

From the glossary of Catbert, Evil HR Director:

"Resource" - something placed between keyboard and chair

ray.wurlod

Possibly the user does not have SELECT privilege to the Oracle system tables in which the metadata are stored.

ray.wurlod

Ordinarily this is only used on advice from support, who will advise the module names. When a job starts, there is an event logged showing which modules are loaded. These are examples of the module names that can be loaded into APT_DEBUG_MODULE_NAMES.

ray.wurlod

Yes.

But this error message asserts that there's no SQL statement at all!

Add a WHERE clause that limits the return to one row and which uses but ignores the key value. For example

Code: Select all

WHERE ? IS NOT NULL AND ROWNUM = 1

Welcome aboard.

ray.wurlod

No you'd still need something to trigger the first ODBC stage. You may as well use a Before SQL in the target ODBC stage.

ray.wurlod

To expand, generate regular integers, then transform them to strings with a function such as Right(Str("0",16):InLink.MyInteger, 16) For improved performance, initialize a stage variable, say sv16zeroes, to Str("0", 16), and use the stage variable rather than the function call in...

ray.wurlod

ray.wurlod

It's poor code, that relies on the fact that errors in DataStage API functions return negative number and on the fact that DSJ.ME is not negative - you can find its value in JOBCONTROL.H. Better code is to perform some innocuous function on the job handle, and test the result of that. JobHandle = DS...

ray.wurlod

No idea, but the limit is determined by any limit in your email system, not by anything in DataStage.

ray.wurlod

From memory it's APT_RDBMS_COMMIT_ROWS

ray.wurlod

The obvious one! Without gives a smaller export file, and is probably the preferred method when simply backing up your work from the design area. The difference becomes apparent when you import. If the export contains compatible executables, you can run straight away in the new project. If the expor...

ray.wurlod

Yes. And your point is?

Code: Select all

                        +----------------+
                        |                V
      SeqFile  ---->  Copy              Join  -------> 
                        |                ^
                        +----------------+

ray.wurlod

The whole purpose of an information agenda is to have data that are fit for purpose.

Note that word: FIT

Fit, not BLOB.

Now, get down, gimme twenty!!!

ray.wurlod

You might like to talk with the folks behind http://www.redbook.com.au (they have these data as drop-down lists, and may be nice enough to share).

ray.wurlod

Like so many other things in the parallel execution environment it's managed through environment variables rather than through stage properties. It's probably a good idea to add the environment to the job, or to a parameter set that the job includes.

Search found 53125 matches