Search found 53125 matches

by ray.wurlod
Tue Mar 31, 2015 3:37 pm
Forum: General
Topic: OPTION to parameterize different jobs in the Sequence JOB
Replies: 1
Views: 1052

Custom triggers to make the decision about which validation job to run, separate Job activities for each of those jobs.
by ray.wurlod
Mon Mar 30, 2015 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server Varchar Date to Oracle Timestamp conversion
Replies: 3
Views: 1775

Your default format string for timestamp expects YMD order but you are providing MDY order. That's basically what you're doing wrong.
by ray.wurlod
Mon Mar 30, 2015 3:30 pm
Forum: General
Topic: UpdateSignerCert.bat error
Replies: 3
Views: 1974

What about opening ports 9080 and 2810 ?
by ray.wurlod
Sun Mar 29, 2015 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add column to input
Replies: 13
Views: 4344

I intend not to load the job, when the same can be achieved by other lightweight stages like column generator and/or modify stages. You are relying on out-of-date knowledge. These days (since about version 8.7) the Transformer stage is no less efficient than most other stages, sometimes it's more e...
by ray.wurlod
Sun Mar 29, 2015 3:53 pm
Forum: General
Topic: Run DSJOB -run from command activity stage having limitation
Replies: 16
Views: 7266

You can try forking background dsjob processes. For example

Code: Select all

nohup dsjob [ options ] &
by ray.wurlod
Sun Mar 29, 2015 3:51 pm
Forum: General
Topic: Identify failed job from Master Sequence
Replies: 2
Views: 766

You can look at the job log in Designer. Press Ctrl-L to enable/disable, or use the View menu to accomplish the same.
by ray.wurlod
Thu Mar 26, 2015 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Table NO RCP
Replies: 6
Views: 3914

Please verify that each column to be mentioned in the WHERE clause is identified in the metadata as Key
by ray.wurlod
Thu Mar 26, 2015 3:58 pm
Forum: General
Topic: Problems with engine credentials
Replies: 8
Views: 4007

Also check that the passwords for the WAS admin user and the IIS admin user have expired/changed without the appropriate script (AppServerAdmin) having been run.
by ray.wurlod
Thu Mar 26, 2015 3:56 pm
Forum: General
Topic: JobControl Job aborted
Replies: 6
Views: 1982

There's no other information in the job logs, either of the sequence itself or of JA1 or JA2?

Please note: it's SEQUENCE, not Sequencer. A Sequencer is something that you can use in a Sequence.
by ray.wurlod
Wed Mar 25, 2015 4:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel job reports failure (code 139)
Replies: 8
Views: 4171

Anyone? :roll: Learn patience! This is an all-volunteer site where people post as and when they can. Yesterday, for example, I had a breakfast meeting with management, a busy day at work, and a training session at IBM after work. Not much time for DSXchange. The issue many times is that the job mon...
by ray.wurlod
Wed Mar 25, 2015 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find out the bytes moved by a datastage job
Replies: 13
Views: 6452

I'm not aware of any either, other than manually calculating row sizes based on information in Chapter 2 of Parallel Job Developer's Guide about storage sizes of data types. And anything you put in to calculate the same would degrade the job's performance. But, of course, any data moved around in pa...
by ray.wurlod
Wed Mar 25, 2015 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add column to input
Replies: 13
Views: 4344

Are you permitted to use a Modify stage?

If yes use a column generator to generate "Y" for all rows then use the Modify stage to convert the NULL from left outer join into "N". And/or use a fork/join to split the streams based on the result of the join (or lookup).
by ray.wurlod
Tue Mar 24, 2015 10:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Non Printable characters loaded to Oracle from Sybase
Replies: 3
Views: 1319

Maybe Sybase suppresses it. You need some way to look at the data in raw format. Try getting a CSV dump of the record from Sybase.
by ray.wurlod
Tue Mar 24, 2015 10:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing leading '0' while decimal to varchar conversion
Replies: 4
Views: 2394

Probably there are non leading zeroes because the actual leading character is a space (" ") occupying the sign position.
by ray.wurlod
Tue Mar 24, 2015 10:39 pm
Forum: General
Topic: Unable to rename or delete jobs
Replies: 8
Views: 2057

I thought Gibberish was the language they speak in Gibraltar.
:lol: