Search found 42189 matches

by chulett
Mon Oct 24, 2011 1:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To have numbers only in a phone number column.
Replies: 11
Views: 3120

On the Server side you have the DIGITS transform but on the PX side I'd just fall back on Convert, I do believe:

Code: Select all

Convert("()[]-. ","",YourField)
Something much like that.
by chulett
Mon Oct 24, 2011 11:37 am
Forum: General
Topic: Change log location
Replies: 4
Views: 951

Of what logs do you speak? Why does the subject say "job location", typo?
by chulett
Mon Oct 24, 2011 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Padding 0's
Replies: 11
Views: 4236

... and?
by chulett
Mon Oct 24, 2011 9:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading Mainframe flat file to populate Oracle table
Replies: 7
Views: 2070

The Complex Flat File stage was built to do exactly that.
by chulett
Mon Oct 24, 2011 7:00 am
Forum: General
Topic: Passing values to a job through sequencer
Replies: 3
Views: 990

Simple, perhaps, but problematic. Any issues with that approach and you'll be correcting it manually. You can easily add this "end timestamp capture" function capability into any job that needs it using a Aggregator to ensure that happens last. I'm assuming, however, that you may need to d...
by chulett
Mon Oct 24, 2011 6:47 am
Forum: General
Topic: passsing before routine's output in job
Replies: 1
Views: 666

This cannot be done "before job" to the current job. Run the routine via a Routine Activity stage in a Sequence and pass the output to the job that needs it there.
by chulett
Mon Oct 24, 2011 6:44 am
Forum: General
Topic: Migration testing
Replies: 2
Views: 654

The same way you tested them when you built them originally. You run them and verify the output. Not sure what other advice you might be looking for.

You have to decide if you need to run everything through that gauntlet or if representative samples of each "type" of job is enough.
by chulett
Mon Oct 24, 2011 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01722: invalid number
Replies: 17
Views: 12757

Well, rather than hijack an older thread here you are in your own topic which you can come back and mark as resolved if you figure out the issue. That or come back and ask more questions.
by chulett
Mon Oct 24, 2011 6:33 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 4404

I'm going to take a wild, crazy guess that you need to add the "-domain" option back in... with a proper domain value. I'm also curious if there are any "special characters" in your userid and/or password.
by chulett
Sun Oct 23, 2011 4:38 pm
Forum: General
Topic: Repository Search
Replies: 1
Views: 1223

The normal ones. Director allows a wildcard search, suggest you do that first and then turn off Category display. Otherwise, search DS_JOB from the Administrator:

Code: Select all

SELECT CATEGORY FROM DS_JOBS WHERE NAME = '?'
by chulett
Sun Oct 23, 2011 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: field function
Replies: 4
Views: 1202

pandeesh wrote:That will suite your requirement i believe
Not sure there's a "requirement" to be met here, at this point all we have is a question.
by chulett
Sun Oct 23, 2011 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: field function
Replies: 4
Views: 1202

jwiles wrote:Where does it say that in the manual? According to the docs, it returned what you asked for (field #1).
I agree and you got exactly what I would have expected. Can you post the verbiage from the documention that you mentioned? Perhaps when it comes to the wording, they choose... poorly. :wink:
by chulett
Sat Oct 22, 2011 8:46 am
Forum: General
Topic: Unlocking a job via another job
Replies: 36
Views: 9218

That's a SIGKILL not an unlock and you need to read about the -9 termination signal. It doesn't allow for any kind of lock release to happen, it just... kills. Without mercy. Try a "ps -ef | head -1" if you want an easy way to see the headers to know which column is what. If you're still n...
by chulett
Sat Oct 22, 2011 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PATH env Variable
Replies: 5
Views: 2979

Where are you seeing what you posted - in the dsenv file or the job's log? For the former, just change it there. Otherwise, I'd suspect it is in the .profile of the executing user, or whatever userid is used to start the DataStage services.
by chulett
Sat Oct 22, 2011 8:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: abort the Job
Replies: 8
Views: 2857

I'm not going to have the exactly correct terminology but (from what I recall) you can set the Lookup to Fail if a match is not found...