Search found 53125 matches

by ray.wurlod
Tue Mar 12, 2013 3:10 pm
Forum: General
Topic: Don't get warning message for execute command
Replies: 12
Views: 2751

Do you have automatic error handling enabled in the sequence? Do you have a Failure trigger on the Execute Command activity?
by ray.wurlod
Tue Mar 12, 2013 3:06 pm
Forum: General
Topic: DS Client 9.1 Failed to authenticate user
Replies: 8
Views: 7926

Once you're logged in using Director, can you run Designer from the Tools menu?
by ray.wurlod
Tue Mar 12, 2013 3:05 pm
Forum: General
Topic: Data Validation/Rejection
Replies: 7
Views: 1495

While it's a data quality question, it's not a QualityStage question. However, it's a mixed DataStage/IA question, so General is probably the best forum.
by ray.wurlod
Tue Mar 12, 2013 2:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split one column into multiple columns
Replies: 7
Views: 4774

Read with a Sequential File stage with First Line is Column Names set to True. Read the whole row into a single column, whose data type is a sufficiently large VarChar.

Parse the data using a Column Import stage or a Transfomer stage using Field() functions.
by ray.wurlod
Tue Mar 12, 2013 2:00 am
Forum: General
Topic: Data Validation/Rejection
Replies: 7
Views: 1495

Welcome aboard.

The Transformer stage is probably the simplest way.

If you have an Information Analyzer licence you could also use the Data Rules stage in DataStage.
by ray.wurlod
Tue Mar 12, 2013 12:09 am
Forum: General
Topic: Multi-Compiler error
Replies: 4
Views: 1468

Do get fix pack 1. It corrects a number of minor annoyances.
by ray.wurlod
Mon Mar 11, 2013 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to delete the item(s). Unable to load RID
Replies: 3
Views: 1683

Is this a parallel job (as marked) or a server job (as posted)?
by ray.wurlod
Mon Mar 11, 2013 1:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML stage does not process the first row
Replies: 13
Views: 3993

Do you have "first line is column names" set in the Sequential File stage?
by ray.wurlod
Mon Mar 11, 2013 1:31 pm
Forum: General
Topic: Source to Target mapping
Replies: 24
Views: 8280

The derivations and target columns are to be found in the DS_JOBOBJECTS record for the output link from a Transformer stage. To determine that a link is an output link from a Transformer stage you will need to determine its source stage repository identifier (for example V0S7) and query DS_JOBOBJECT...
by ray.wurlod
Sun Mar 10, 2013 10:19 pm
Forum: General
Topic: Jobs do not compile
Replies: 9
Views: 2287

Can you compile a parallel job that does not have a Transformer stage? If so, your C++ compiler licensing may have expired.
by ray.wurlod
Sun Mar 10, 2013 8:25 pm
Forum: General
Topic: Datastage client download
Replies: 2
Views: 2433

If you have a licence you can download from IBM Passport Advantage.
by ray.wurlod
Sun Mar 10, 2013 8:23 pm
Forum: General
Topic: Jobs do not compile
Replies: 9
Views: 2287

Then I suggest you need to undertake a bit more detective work. Clearly something has changed. Does compilation throw any error message? Does the status of the job in Director change?
by ray.wurlod
Sun Mar 10, 2013 12:42 pm
Forum: General
Topic: Jobs do not compile
Replies: 9
Views: 2287

What has changed on your Engine server since "a few days ago"?
by ray.wurlod
Sat Mar 09, 2013 1:04 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Accepting SOAP over HTTP requests into DataStage
Replies: 12
Views: 9218

Not sure what you mean by "accept" here. Reading your question at face value I would have suggested the ISD Input stage, and don't understand how job parameters come into the picture at all.
by ray.wurlod
Sat Mar 09, 2013 1:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to truncate Chinese Char ?
Replies: 9
Views: 4802

That, in turn, really depends on whether the database specifies characters or bytes for storage. If bytes, then a multiplier is definitely indicated, and will usually occur automatically when the table definition is imported. We found with most encodings of Japanese data that a factor of 3 was corre...