Search found 53125 matches

by ray.wurlod
Thu Sep 22, 2005 2:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job import/export
Replies: 8
Views: 1637

Sure it does! XML export files! :lol:
by ray.wurlod
Thu Sep 22, 2005 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: EventId from the log
Replies: 2
Views: 2387

DSGetNewestId has options for filtering by event type (severity) and timestamp.
by ray.wurlod
Wed Sep 21, 2005 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BASIC Routine to Convert datatype
Replies: 3
Views: 1267

BASIC doesn't have data types, so the answer is properly no. Pass the value as string into your parallel job and convert it there.
by ray.wurlod
Wed Sep 21, 2005 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Sequencer
Replies: 3
Views: 950

Is there any way to control this?

Triggers. Your first job sequence has a link to your second job sequence. You make the trigger on this link "Finished OK" or a custom trigger that allows both finished OK and finished with warnings.
by ray.wurlod
Wed Sep 21, 2005 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Conditional Job Start from Routine Value
Replies: 4
Views: 1304

It's an "activity variable" in your job sequence.
RoutineActivityName.$ReturnValue
by ray.wurlod
Wed Sep 21, 2005 4:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while trying to retrieve text for error ORA-12154
Replies: 8
Views: 5839

Can you use the oerr command successfully? For example

Code: Select all

oerr ORA 12154
by ray.wurlod
Wed Sep 21, 2005 4:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export-Import
Replies: 2
Views: 754

Search the forum for the SQL. You update a column called READONLY in DS_JOBOBJECTS where OBJNAME = 'ROOT' and OBJIDNO is the correct job number.
by ray.wurlod
Wed Sep 21, 2005 4:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Projects with many jobs have slow graphical front-end resp.
Replies: 7
Views: 1893

You could read up about the following commands in the Ascential DataStage Hash Stage Disk Caching manual! :wink:
    SET.MODE
    LIST.FILE.CACHE
    CLEAR.FILE.CACHE
    CATALOG.FILE.CACHE
    DECATALOG.FILE.CACHE
    DAEMON.FILE.CACHE
by ray.wurlod
Wed Sep 21, 2005 4:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phone_Number MATCHES '3N1X3N1X4N'
Replies: 5
Views: 2023

A ten digit number will never match that pattern, because that pattern matches a string containing three digits, one "any" character, three more digits, one more "any" character then four more digits. If your source data are purely numeric, you may prefer InLink.Phone_Number MATCHES "10N" ...
by ray.wurlod
Wed Sep 21, 2005 4:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Processes
Replies: 14
Views: 6304

Can you open a CMD shell and execute the command shrdump ? This command is located in the DataStage Engine bin folder. It provides a listing of the shared memory segments in use by DataStage processes. It may be that you can connect soon after shutting down dsservice.exe because Windows has not yet ...
by ray.wurlod
Wed Sep 21, 2005 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Equivalent of first and last functions in sql in datastage
Replies: 6
Views: 2819

Not unless you tell us, completely and precisely, what your job is doing in these stages.
by ray.wurlod
Wed Sep 21, 2005 12:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Processes
Replies: 14
Views: 6304

Check also in Task Manager. If dsservice.exe is genuinely not running, I dispute your assertion that "I can still connect to the server (which is on my local machine) and run the jobs." I have stopped DataStage services on my machine (server on local Windows), and I can neither connect from DataStag...
by ray.wurlod
Wed Sep 21, 2005 12:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null property in flat files
Replies: 3
Views: 1310

Look (in generated OSH) at the stage with which the export operator is associated. This is where you need explicitly to handle the null.
by ray.wurlod
Wed Sep 21, 2005 12:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Processes
Replies: 14
Views: 6304

Verify that dsservice.exe has truly stopped and not restarted. Do this through the Services applet, not the DataStage applet.
by ray.wurlod
Wed Sep 21, 2005 12:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Jobs examples
Replies: 2
Views: 1398

There is a Tutorial that ships with the product. It has a couple of examples. Then, working through it, you get to build some others.