Search found 53125 matches

by ray.wurlod
Thu May 16, 2013 1:45 am
Forum: General
Topic: Contents deleted from /opt/IBM/InformationServer/ASBServer/b
Replies: 3
Views: 1126

Does there exist a system backup?

If so, restore from the backup.

If not, you have no option than to re-install the Services tier.
by ray.wurlod
Thu May 16, 2013 1:43 am
Forum: General
Topic: Delete file using DataStage Job
Replies: 5
Views: 3238

The optimum method will depend on when and where you need to delete the file. Please provide more information. Either of the approaches already mentioned will do the task, but do you want to remove the file as an isolated operation, or at the end of some other processing? You can specify only to exe...
by ray.wurlod
Wed May 15, 2013 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need logic looking for Active Sub account
Replies: 4
Views: 1559

Please post how this was Resolved, to help future searchers.
by ray.wurlod
Wed May 15, 2013 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to perform padding on left side
Replies: 3
Views: 1911

More efficient (fewer CPU cycles):

Code: Select all

Right("0000" : InLink.DEPTNO, 4)
Right("00000" : InLink.SAL, 5)
by ray.wurlod
Wed May 15, 2013 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Data formatted
Replies: 2
Views: 1494

Look for an end tag "ax" rather than "ax21".
by ray.wurlod
Wed May 15, 2013 2:58 pm
Forum: IBM QualityStage
Topic: diff b/w usual addr rule set and avi
Replies: 6
Views: 6080

:idea: Contrast the terms "standardization" and "certification".
by ray.wurlod
Wed May 15, 2013 4:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk Characters in datastage
Replies: 8
Views: 11172

Don't trust how View Data represents non-ASCII characters.

Experiment with text files and hex editors/viewers to learn exactly what these characters are, and then process them accordingly.

There are NO junk characters.
by ray.wurlod
Wed May 15, 2013 4:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk Characters in datastage
Replies: 8
Views: 11172

how r these words appearing when viewed in DB2? what is the source datatype etc? which country related data is it? did u try that country NLS? did u try to write to a file and ck? U did not try any of these things, because U is not at the same site as varsh16785. The second person personal pronoun ...
by ray.wurlod
Wed May 15, 2013 3:57 am
Forum: General
Topic: DataStage Not Creating Instances
Replies: 4
Views: 901

Try restarting your client machine.

If that doesn't work, remove and re-install the client software on your machine.

Is your machine at the same patch/fixpack level as your peer's?
by ray.wurlod
Wed May 15, 2013 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic Issue
Replies: 7
Views: 1778

If you're doing a lookup against a single row table you're effectively returning a constant. You could generate this in the Transformer stage or in a Column Generator stage.
by ray.wurlod
Wed May 15, 2013 3:53 am
Forum: General
Topic: Link row count
Replies: 5
Views: 3215

Welcome aboard.

DSGetLinkInfo() works with all job types.

However, it can also return per-node information in parallel jobs.

Others have already solved your problem. For example download ETLstats from Kim Duke's website for example.
by ray.wurlod
Wed May 15, 2013 3:50 am
Forum: IBM QualityStage
Topic: diff b/w usual addr rule set and avi
Replies: 6
Views: 6080

Read the documentation on the AVI stage, and the information about address rule sets, let us know what YOU think, and then we'll guide you.

We believe in helping people to learn, and that simply providing answers "on a silver platter" does not achieve that end.
by ray.wurlod
Tue May 14, 2013 9:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unusual difference between two jobs
Replies: 5
Views: 1215

OK, perform a job comparison report and determine where the difference lies.
by ray.wurlod
Tue May 14, 2013 8:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Preserve sort
Replies: 7
Views: 2453

Make them available.

Or run your Sort stage in Sequential mode.
by ray.wurlod
Tue May 14, 2013 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unusual difference between two jobs
Replies: 5
Views: 1215

Does one of the jobs have APT_STRING_PADCHAR set to 0x0 (ASCII NUL)and the other to something else?