Search found 53125 matches

by ray.wurlod
Tue Oct 16, 2012 3:04 pm
Forum: General
Topic: Integrating PVCS to IIS 8.7
Replies: 3
Views: 1002

Check-out/check-in is not enforced for DataStage, but a well-governed shop will require that this occurs.
by ray.wurlod
Tue Oct 16, 2012 3:02 pm
Forum: General
Topic: How to fetch information from a Sequencer job
Replies: 9
Views: 2023

Your "kind of" suggests that you're asking an ambit question rather than trying to solve a particular problem. The answer is different depending on which you are seeking to achieve. To identify the jobs included in the design of a sequence you can use dssearch or you can interrogate the DS...
by ray.wurlod
Tue Oct 16, 2012 3:51 am
Forum: General
Topic: How to fetch information from a Sequencer job
Replies: 9
Views: 2023

The names of the jobs that form part of the sequence's design, or the names of the jobs that were actually executed when the sequence ran?
by ray.wurlod
Mon Oct 15, 2012 2:20 pm
Forum: General
Topic: DataStage V8.7 FixPack-1
Replies: 4
Views: 2805

That URL throws a 410 error (page gone).
by ray.wurlod
Mon Oct 15, 2012 2:19 pm
Forum: General
Topic: Retrieve Partition type from Xmeta Query
Replies: 3
Views: 1409

No-one outside IBM has official information about the table structures in the common metadata repository. I have noticed that they change as new releases appear, so anything published would be immediately out of date.
by ray.wurlod
Mon Oct 15, 2012 2:17 pm
Forum: General
Topic: Problem while using Unconditional triggers
Replies: 7
Views: 2254

Isn't that the same as Unconditional trigger?
by ray.wurlod
Mon Oct 15, 2012 2:14 pm
Forum: General
Topic: Number of Transformers
Replies: 14
Views: 2856

Now is a great time to start learning! You create server routines within DataStage Designer. Documentation about the API functions is to be found in the DataStage BASIC manual. FUNCTION CountTransformerStages(Arg1) * Return list of jobname|stagename pairs for Transformer stages. $INCLUDE DSINCLUDE J...
by ray.wurlod
Sun Oct 14, 2012 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Intercept fields that generate update: compare data
Replies: 3
Views: 1058

Where do you believe any row limit is documented? Don't you think a company like a large retailer, bank, insurance company or telco would have a Customer dimension with millions of records?
by ray.wurlod
Sun Oct 14, 2012 3:18 pm
Forum: General
Topic: Routine activity failure
Replies: 4
Views: 1052

The other way to disable a failure - and any non-zero return from a Routine activity counts as a failure - from invoking the Exception Handler is to have an explicit Failure trigger from the Routine activity.
by ray.wurlod
Sat Oct 13, 2012 3:19 pm
Forum: General
Topic: finding unix shell scripts used in datastage
Replies: 9
Views: 3479

EVAL introduces an in-line expression.
@RECORD is a system variable that contains the entire record as a single delimited string.
by ray.wurlod
Sat Oct 13, 2012 2:24 am
Forum: General
Topic: Teradata-ODBC:Not enough information to log on
Replies: 2
Views: 6103

Does TDDEMO exist in the list of DSNs in the .odbc.ini file?
by ray.wurlod
Fri Oct 12, 2012 5:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to generate unique numbers only for duplicates
Replies: 2
Views: 1112

Use stage variables to increment the counter when there's a duplicate or to reset the counter when a new group starts.
by ray.wurlod
Fri Oct 12, 2012 5:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: substring a column
Replies: 7
Views: 1784

One possible expression is: InLink.TheString[11,6] : Right(InLink.TheString, Len(InLink.TheString - 16)) Clearly all you wanted was the answer handed to you on a silver platter without being prepared to engage in civilised conversation about whether you needed help in function syntax, techniques, or...
by ray.wurlod
Fri Oct 12, 2012 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: derviation logic with derviation substituion $1 logic
Replies: 5
Views: 2048

Not possible. Derivation substitution makes exactly the same substitution on every selected expression (or part thereof).
by ray.wurlod
Fri Oct 12, 2012 5:15 pm
Forum: General
Topic: Installing Big Data File Stage
Replies: 7
Views: 2862

Can you find it using Quick Find? If not, search in the StageTypes branch of the Repository.