Search found 53125 matches

by ray.wurlod
Tue Feb 26, 2008 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Counts
Replies: 6
Views: 1572

You can run it from any directory if you use its full pathname ${DSHOME}/bin/dsjob or if you have ${DSHOME}/bin in your command directory search list (the PATH environment variable).
by ray.wurlod
Tue Feb 26, 2008 5:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking the path of DS services
Replies: 1
Views: 827

Potentially there is only one ${DSHOME}/bin/dsrpcd

You may optionally have the deadlock daemon ${DSHOME}/bin/dsdlockd and the job monitor application (a Java application that runs as JobMonApp and can be started using ${APT_ORCHHOME}/java/jobmoninit
by ray.wurlod
Tue Feb 26, 2008 5:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Making data run on multiple lines
Replies: 10
Views: 2370

Not enough information. Please describe (with examples) the expressions you are using to accomplish this result.
by ray.wurlod
Tue Feb 26, 2008 5:47 am
Forum: General
Topic: Export, import, delete an empty job
Replies: 15
Views: 3020

Is dummy a totally empty job?

How about you put in an after-job subroutine that calls ExecTCL to COUNT VOC (just for something to do)?
by ray.wurlod
Tue Feb 26, 2008 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: month from date
Replies: 5
Views: 1943

If you have a Date column is does NOT have a format: your Sequential File stage specifies the date format in the file and the import operator looks after it. If it's a Char or VarChar data type then the format is important. There are date conversion functions both for the Modify stage and for the Tr...
by ray.wurlod
Tue Feb 26, 2008 3:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Conversation
Replies: 3
Views: 1194

Source is VarChar while target is Date. Date does NOT have a format.

Therefore

Code: Select all

StringToDate(Trim(LNK_Read_Input.IND_DT), "dd-%mmm-%yy")
should suffice.
by ray.wurlod
Tue Feb 26, 2008 3:50 am
Forum: General
Topic: Export, import, delete an empty job
Replies: 15
Views: 3020

Can you see the dummy job post-import? If not, try the query

Code: Select all

SELECT NAME, JOBNO, CATEGORY FROM DS_JOBS WHERE NAME = 'dummy';
It may be that there's a job called dummy in some other category, which should throw an error if you try to import the same job name into another category.
by ray.wurlod
Tue Feb 26, 2008 2:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling oracle sequence
Replies: 3
Views: 1469

Very easily. And if you search the forum you will find that that question has been answered lots of times - sometimes with examples - already.
by ray.wurlod
Tue Feb 26, 2008 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed a keylookup for record.(Shared Container)
Replies: 1
Views: 811

Chances are that your Lookup Failed rule is "Fail", which is the default. This causes your job to abort as soon as one lookup fails. Change the setting to one of the three other possible values.
by ray.wurlod
Tue Feb 26, 2008 2:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Director Getting Closed Abruptly when viewing log in detail
Replies: 8
Views: 2490

What if you're in Status view and you try Clear Log ?

Can someone please try this in version 7.x? It might be something new in version 8.x.
by ray.wurlod
Tue Feb 26, 2008 12:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how we can remove duplicates in transformer stage
Replies: 10
Views: 4330

I expect, from reading the rules, that the fact that the routine uses COMMON variable would preclude it. Why not try it and let us know?
by ray.wurlod
Mon Feb 25, 2008 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how we can remove duplicates in transformer stage
Replies: 10
Views: 4330

RowProcCompareWithPreviousValue in a parallel Transformer? Doubt it. RowProcCompareWithPreviousValue is written in DataStage BASIC and relies on COMMON, which immediately invalidates it from use in a parallel job. See Chapter 2 of Parallel Job Developer's Guide for more information on the rules.
by ray.wurlod
Mon Feb 25, 2008 11:43 pm
Forum: General
Topic: DataStage Health Check
Replies: 4
Views: 2709

Define "not performing". The only permanently-running process is the dsrpcd (DataStage RPC daemon). It is a listener, so tends not to use much in the way of resources. Optionally you may have the job monitor (a Java application JobMonApp) running for parallel jobs, and the DataStage deadlock daemon ...
by ray.wurlod
Mon Feb 25, 2008 11:14 pm
Forum: General
Topic: Unable to connect to Host
Replies: 2
Views: 1019

Can you connect if the Omit button is checked?

Are you using a legally licensed copy of DataStage server? This symptom can occur if the licence has expired.
by ray.wurlod
Mon Feb 25, 2008 11:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: phantom
Replies: 1
Views: 755

"Phantom" is DataStage terminology for "background process".
All DataStage jobs run as phantom (background) processes.
The only way to avoid them is to take a vacation.
Or simply stop using DataStage and any other tool that uses background processes.