Search found 53125 matches

by ray.wurlod
Wed Feb 11, 2009 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: using reference and output as the same file
Replies: 4
Views: 927

This fact was mentioned in the original post.
by ray.wurlod
Wed Feb 11, 2009 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "Could not serialize - transaction aborted" error
Replies: 3
Views: 11595

Welcome aboard.

How is the property "Transaction Isolation Level" set?
by ray.wurlod
Wed Feb 11, 2009 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to connect to DS
Replies: 3
Views: 944

Still no error message? If there is one, please post it. There are too many possibilities to waste time guessing.
by ray.wurlod
Wed Feb 11, 2009 4:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation of Mainframe jobs
Replies: 7
Views: 1549

You should be able to. Go to the Licensing screen in the Administrator client.
by ray.wurlod
Wed Feb 11, 2009 4:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job is not in the right state
Replies: 7
Views: 2592

It can also mean that the job is Aborted/Stopped and has not been reset.

It may also, but not in this case, mean that the job has not been compiled since it was most recently modified.
by ray.wurlod
Wed Feb 11, 2009 4:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Internal error on W2003: 39202
Replies: 9
Views: 4610

The next thing to check is the firewall. Is port number 31538 open? This is the one needed for dsrpcd - the one on which it listens for inbound connection requests.
by ray.wurlod
Wed Feb 11, 2009 4:18 pm
Forum: General
Topic: Invalid character(s) codepage ibm-1051_P100-1995 to Unicode
Replies: 3
Views: 1724

The NLS code page specifies how the data are encoded OUTSIDE of DataStage, for example in files and database tables. The NLS map translates from this encoding into the Unicode representation used internally by DataStage when reading. Or vice versa if writing.
by ray.wurlod
Wed Feb 11, 2009 4:17 pm
Forum: General
Topic: List all jobs in a sequence
Replies: 4
Views: 2062

All jobs that are designed in a sequence, or all jobs that were executed in a particular run of the sequence? (The latter may be a subset of the former, depending on the particular logic of the sequence.) Both answers are available by searching. The latter answer involves interrogating the job seque...
by ray.wurlod
Wed Feb 11, 2009 4:15 pm
Forum: General
Topic: Appending leading Zeros and writting to excel file
Replies: 9
Views: 2346

Or change the format of the cells if they really must be Number.

It's NOT a DataStage issue.
by ray.wurlod
Wed Feb 11, 2009 4:10 pm
Forum: General
Topic: Adding Arguments to heavily used existing routine
Replies: 4
Views: 1270

If you want different behaviour WITHIN the old routine then your way is to be preferred.

An alternative might be to load the sixth value into the job's user status area and have the routine pick it up from there.
by ray.wurlod
Wed Feb 11, 2009 4:09 pm
Forum: General
Topic: How to select and move multiple jobs by run date range
Replies: 5
Views: 1847

Have the Director window maximized and the Manager window about one-quarter screen size, it's then really easy.

Once you get to version 8 you will have Quick Find and Advanced Search and you can select any combination from these tools. Advanced Search allows filtering by date/time modified.
by ray.wurlod
Wed Feb 11, 2009 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling
Replies: 11
Views: 4905

Have you searched for
The number of reject datasets "0" is less than the number of input datasets "1".
by ray.wurlod
Wed Feb 11, 2009 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partitioning Details
Replies: 4
Views: 1192

Yes I can, but I won't.

Premium membership is not expensive, at less than 30c (Rs12) per day, and is one of the ways that the hosting and bandwidth costs of DSXchange are met.

I do not propose to set any precedent that might undermine the ongoing viability of DSXchange.
by ray.wurlod
Wed Feb 11, 2009 5:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Switch from Datastage5.2 to 7.5.1 using Multi Client Manager
Replies: 1
Views: 1080

Multi-client Manager should be what you require. (In earlier versions this was called Client Switcher.)

You can not have both client versions active simultaneously, since they use identically named, but different, DLL and other support files.
by ray.wurlod
Wed Feb 11, 2009 5:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to schedule jobs in Datastage
Replies: 1
Views: 1002

Method 1. Use Director client Schedule view. This is an interlude to the operating system's scheduler.

Method 2. Use any third-party scheduler (or the operating system scheduler) and the dsjob command line interface to request your job runs.