Search found 53125 matches

by ray.wurlod
Thu Aug 11, 2011 3:49 pm
Forum: General
Topic: Clean-up or reduce the size of native_stderr.log file
Replies: 1
Views: 1133

And your question is... ?
by ray.wurlod
Thu Aug 11, 2011 3:47 pm
Forum: General
Topic: Exporting whole project into single file
Replies: 32
Views: 10061

Try opening a CMD window first then executing dscmdexport from there.
by ray.wurlod
Thu Aug 11, 2011 3:44 pm
Forum: IBM QualityStage
Topic: Survive Stage
Replies: 1
Views: 799

You use as many rules as are appropriate. Initally the "master" record (resulting from Match) becomes "best", then the rules are applied one after the other to determine whether to replace a single field in, multiple fields in, or the entire "best" record.
by ray.wurlod
Thu Aug 11, 2011 3:41 pm
Forum: IBM QualityStage
Topic: Match Frequency Process
Replies: 9
Views: 2917

Have you set up a DSN to the Match Designer database from your DataStage server as well as from the client? Both are needed.
by ray.wurlod
Thu Aug 11, 2011 6:00 am
Forum: General
Topic: Exporting whole project into single file
Replies: 32
Views: 10061

The command you need is dscmdexport.
by ray.wurlod
Wed Aug 10, 2011 11:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCIISTR eqivalent function in datastage
Replies: 2
Views: 1093

No idea what the function does. (Not everyone in the world uses Oracle, much to Larry's chagrin.) Perhaps if you could explain the required functionality we might be more easily able to help.
by ray.wurlod
Wed Aug 10, 2011 11:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace instance with string
Replies: 5
Views: 1875

Get a copy of stdio.h into DSU_BP directory would be easiest.

Otherwise use $INSERT rather than $INCLUDE and specify the pathname of stdio.h.
by ray.wurlod
Wed Aug 10, 2011 11:13 pm
Forum:
Topic: Data lineage and tracing from Cognos Report to Source
Replies: 7
Views: 4913

In addition to all the things Ernie mentioned IBM Services can provide a tool (erwin2bg) to extract business terms out of ERwin logical models into an XML format that can be consumed by Business Glossary using its import utility. This (import from XML file) may - I have yet to research this - be abl...
by ray.wurlod
Wed Aug 10, 2011 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to create fixed width text file
Replies: 10
Views: 5489

Show your derivation expression.
by ray.wurlod
Wed Aug 10, 2011 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating Fixed Lenght file
Replies: 2
Views: 1186

Padding is how you get fixed width.
by ray.wurlod
Wed Aug 10, 2011 3:55 pm
Forum: General
Topic: Logs for Infosphre server crash
Replies: 7
Views: 22720

Looks like permission denied to /var/tmp when trying to do something with a lock file. (Or, perhaps, /var/tmp became full.) Work with your official support provider, who has diagnostic tools to apply to logs.
by ray.wurlod
Wed Aug 10, 2011 3:50 pm
Forum: IBM QualityStage
Topic: Overrides in Standardization Stage
Replies: 5
Views: 1385

Use an upstream Transformer stage.

Code: Select all

If Right(InLink.Name,2) = "//" Then Left(InLink.Name, Len(InLink.Name)-2) Else InLink.Name
by ray.wurlod
Wed Aug 10, 2011 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selecting distinct values and creating a list/array
Replies: 16
Views: 5360

1. Vertical pivot.
2. Yes. Use a "list of things" loop.
by ray.wurlod
Wed Aug 10, 2011 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: minimising the imoact on source DB when using infosphere cdc
Replies: 2
Views: 1561

CDC is designed to minimize impact. It's (probably) running a low-impact read process on the transaction log.
by ray.wurlod
Wed Aug 10, 2011 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to create fixed width text file
Replies: 10
Views: 5489

After you show me what you did to get the four decimal places.