Search found 53125 matches

by ray.wurlod
Tue Jan 30, 2007 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Renaming and deleting a dataset
Replies: 34
Views: 12192

You can have your own.profile in your own home directory.
by ray.wurlod
Tue Jan 30, 2007 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List of DS Engine Commands
Replies: 5
Views: 2003

Does anyone have any plz that they can pass across?
:evil:
by ray.wurlod
Tue Jan 30, 2007 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert Read only share container into R/W mode
Replies: 11
Views: 2136

Code: Select all

UPDATE DS_CONTAINERS SET READONLY = 'NRO' WHERE NAME = '<<Container Name>>';

It may be the case that READONLY was not set to 'RO'. There are other values set by other utilities that also indicate a read-only status.
by ray.wurlod
Tue Jan 30, 2007 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting category list in a project
Replies: 5
Views: 1488

You need to set your PATH to include $DSHOME/bin or to specify the full pathname of the uv command.

After that, you may find that you have not executed the dsenv script, which will cause errors about libraries when you manage to execute the uv command.
by ray.wurlod
Tue Jan 30, 2007 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal Truncation -RESOLVED
Replies: 8
Views: 2122

Ray's been around long enough to remember computers where integer arithmetic was your only choice, and to remember an apparently minor point in the teaching when he was learning C programming.
by ray.wurlod
Tue Jan 30, 2007 2:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checking whether string is numerical or not
Replies: 3
Views: 736

Assuming that the value is always 20 characters long:

Code: Select all

If InLink.MyColumn Matches "1A19N" Then InLink.MyColumn[2,4] Else ""
by ray.wurlod
Tue Jan 30, 2007 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Initialize Transformer stage variables
Replies: 6
Views: 1392

Code: Select all

SELECT col2 || ':' || col6 || ':' || col7 FROM TABLE WHERE ...
by ray.wurlod
Tue Jan 30, 2007 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can i inport a dll in datastage designer
Replies: 10
Views: 3728

In Manager, choose Import > External Function Definitions (see Manager Guide , page 8-17) This places an entry in the Routines branch of the Repository describing the external (ActiveX) function, how many arguments it has, and the DLL in which it resides and the automation class within that DLL. Not...
by ray.wurlod
Tue Jan 30, 2007 2:26 pm
Forum: IBM QualityStage
Topic: cannot see output in quality stage
Replies: 9
Views: 4503

Verify the stage properties in your job to make sure you're looking for the correct output file name. It will not have reported "run successfully" without producing an output file.
by ray.wurlod
Tue Jan 30, 2007 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Quality via DSRoutine
Replies: 5
Views: 2184

Can you try describing your "empty" strings in code as '\0' ? You could also implement the logic in a parallel Transformer job, compile the job, then inspect the generated C++ code for ideas about coding your function. (You'll also find, if you're on 7.5.1A or later, that the Transformer stage is qu...
by ray.wurlod
Tue Jan 30, 2007 5:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine to connect to DB2
Replies: 14
Views: 6824

Your original post on this thread suggested that your DataStage server is on Windows, which is why I suggested "DOS" as the first argument of the DSExecute() call. That "UNIX" works tells me that your DataStage server is, in fact, on a UNIX machine. Had your DataStage server actually been on a Windo...
by ray.wurlod
Tue Jan 30, 2007 5:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage, Oracle and UTF-8
Replies: 3
Views: 2470

UTF-8 is not a single standard. To say that UTF-8 is a standard is like saying that UNIX is a standard. There are many eight bit Unicode Transformation Format schemes. Even the one used inside DataStage is idiosyncratic, as it preserves dynamic array delimiter markers as single-byte characters. It's...
by ray.wurlod
Tue Jan 30, 2007 5:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage date in sql query
Replies: 10
Views: 5415

DataStage job parameters must be set before the job starts and can not be legally changed once the job is running.
by ray.wurlod
Tue Jan 30, 2007 5:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reference link get the first row of the reference table
Replies: 29
Views: 4178

I suspect kumar_s meant "linking" rather than "liking".
by ray.wurlod
Mon Jan 29, 2007 11:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs Failing
Replies: 6
Views: 1399

Do you understand why?