Search found 53125 matches

by ray.wurlod
Mon Oct 13, 2008 1:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data validation
Replies: 1
Views: 1111

Num() function will report whether the data is numeric. You can also use the Matches operator - for example Matches 1N0N.
Finally you can use oconv(string,"MC/N") and see if there's anything remaining.
by ray.wurlod
Sun Oct 12, 2008 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

Get the pathname right. NUL file is in the folder; therefore the pathname is either NUL alone or .\NUL (the dot means "current folder") - not \NUL which means "the nul file in the root directory of the drive.
And, of course one L not two for Windows.
by ray.wurlod
Sun Oct 12, 2008 1:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine hangs
Replies: 13
Views: 3609

A useful trick

The NUL file (or /dev/null if you're on UNIX) can deliver an infinite number of "presses of Enter". Try something like the following if default answers are OK. Call DSExecute('DOS', '7z x ' : Filedir : '\' : ZipFile : " < .\NUL", Output, ReturnCode) Ans = Output
by ray.wurlod
Sun Oct 12, 2008 1:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine called from job transformer -> abnormal terminati
Replies: 10
Views: 5998

Might it be that not all arguments are being passed to the routine?

I always include traps for UnAssigned() and IsNull() for routine arguments in the routine code.
by ray.wurlod
Sun Oct 12, 2008 1:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: outerjoin worked but not lookup
Replies: 1
Views: 802

Moderator: please move to parallel forum
by ray.wurlod
Sun Oct 12, 2008 1:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage repository interface and Universe
Replies: 1
Views: 945

Welcome aboard. This question is too vague. The structure of the Repository is intentionally sparsely documented by the vendor. The DataStage Repository has not been UniVerse since version 5.2; if you want to know more about UniVerse then I suggest you visit IBM's website for UniVerse and UniData
by ray.wurlod
Sun Oct 12, 2008 1:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dataset read - Unknown Error Reading Data
Replies: 15
Views: 5092

Moderator: please move to parallel forum
by ray.wurlod
Fri Oct 10, 2008 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spliting data using transformer vs filter stage
Replies: 6
Views: 1922

The statement is true in version 7.5 and later.
by ray.wurlod
Fri Oct 10, 2008 1:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to use mathamatical function of Exp in datastage
Replies: 5
Views: 2566

So it's a parallel job. Continued in that forum.
by ray.wurlod
Fri Oct 10, 2008 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling Jobs at V8
Replies: 3
Views: 966

at is used for "one shot" schedules, cron for repeating schedules. It was thus in earlier versions also.
Note that this is the UNIX command at and not the Windows command AT.
by ray.wurlod
Fri Oct 10, 2008 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of LOG.SAVE
Replies: 2
Views: 1098

Tell us more about these commands. Where did you find them? Were they perhaps provided by IBM France?
These commands are not, as far as I know, part of the standard DataStage suite.
by ray.wurlod
Fri Oct 10, 2008 7:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to use mathamatical function of Exp in datastage
Replies: 5
Views: 2566

What error message is being generated?
by ray.wurlod
Thu Oct 09, 2008 8:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delimiter string in schema file definition
Replies: 2
Views: 3117

Save the table definition from your Sequential File stage, then view it as a schema file (on the Layout tab) to learn how it's done.
by ray.wurlod
Thu Oct 09, 2008 7:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OCI stage assuming null for field containing only one space
Replies: 2
Views: 1390

APT_STRING_PADCHAR is not relevant to VarChar data types. Why do you claim that "OCI stage assuming null for field containing only one space"? What is populated into the table (use a query with NVL function) or, if there is an error message, please post that. In short, debug! Send (a relevant sample...
by ray.wurlod
Thu Oct 09, 2008 7:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restore purge settings
Replies: 10
Views: 2582

If it's in VOCLIB, then

Code: Select all

COPY FROM VOCLIB TO RT_LOGnnn '//PURGE.SETTINGS'

It it's not in VOCLIB but is in another job log, then

Code: Select all

COPY FROM RT_LOGkkk TO RT_LOGnnn '//PURGE.SETTINGS'

Note that neither of these is SQL, so there is no terminating semi-colon.