Search found 53125 matches

by ray.wurlod
Sun Jul 24, 2016 4:43 pm
Forum: General
Topic: Datastage job Issue
Replies: 1
Views: 1143

Welcome aboard.

It is not possible to answer this question without a lot more information, starting with "are you looking at the correct log?" After all, only sequence jobs can have that status.
by ray.wurlod
Fri Jul 22, 2016 2:40 pm
Forum: General
Topic: Date From and Date To in Sequence
Replies: 4
Views: 2783

Note that vamsi_4a6's syntax is specific for Oracle.
by ray.wurlod
Fri Jul 22, 2016 2:38 pm
Forum: Enhancement Wish List
Topic: IGC Custom Attributes
Replies: 2
Views: 8822

Only on RU17 thus far. Thanks for heads up.
by ray.wurlod
Thu Jul 21, 2016 7:00 pm
Forum: Enhancement Wish List
Topic: IGC Custom Attributes
Replies: 2
Views: 8822

IGC Custom Attributes

I need to be able to use custom attributes with Governance Rules and Policies.
by ray.wurlod
Thu Jul 21, 2016 6:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading and Writing in same table
Replies: 4
Views: 1633

SURA wrote:Job1 - Read and write it in a file.
Job2 - Insert / Update
Which part of "in same job" wasn't clear? :?
by ray.wurlod
Thu Jul 21, 2016 4:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 3164

I should have thought TCS would always require an algorithm specification.
by ray.wurlod
Thu Jul 21, 2016 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output Stage - Repeating elements
Replies: 5
Views: 2415

One-off special since you're new to DSXchange... You will need a variety of techniques here. This is a fairly poor xml design...at least on the scale of using tag names as metadata....(ie. With tags of name and age instead of having true metadata stored in attribute values.).....but as a tip to get ...
by ray.wurlod
Thu Jul 21, 2016 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading and Writing in same table
Replies: 4
Views: 1633

Almost certainly NO. This is what is called a "blocking operation", and would thwart pipeline parallelism, so it is banned in parallel jobs. It may be possible, provided that the writing stage uses auto-commit, and the reading stage is far enough downstream for the commits to have taken ef...
by ray.wurlod
Thu Jul 21, 2016 4:01 pm
Forum: General
Topic: Date From and Date To in Sequence
Replies: 4
Views: 2783

I'd also recommend User Variables.

Examine the Transforms in your Repository, particularly MONTH.FIRST and MONTH.LAST to get ideas about how to calculate these dates.
by ray.wurlod
Thu Jul 21, 2016 3:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date format in Server job causing issues in 11.5.
Replies: 8
Views: 7893

Your database may be expecting a different date format? If so, modify the second argument of Oconv() to produce the expected format.
by ray.wurlod
Thu Jul 21, 2016 3:53 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: v11.3 to v11.5 migration
Replies: 2
Views: 3443

You should be OK pointing to the same IADB. However, use caution with the "update existing tables" option - there may be some small differences in the table structures in IADB. Note that, on installation, IADB is empty of tables; IA creates tables as required.
by ray.wurlod
Thu Jul 21, 2016 3:51 pm
Forum: Data Integration
Topic: Glossary anywhere with multliple IS versions
Replies: 1
Views: 6053

Certainly try it (the 11.3 client connecting to 11.5 services). The API hasn't changed that much, and Glossary Anywhere doesn't do anything particularly special.
by ray.wurlod
Wed Jul 20, 2016 3:50 pm
Forum:
Topic: Data Lineage - Reporting Transformations
Replies: 5
Views: 3269

I'm picking up column name changes OK, but cannot find in data lineage where the transformations themselves in a Transformer stage are reported.
by ray.wurlod
Tue Jul 19, 2016 7:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date format in Server job causing issues in 11.5.
Replies: 8
Views: 7893

Try resetting the server job after it aborts, then viewing the log entry "from previous run". There's nothing in your syntax that is incorrect, though I'd probably use "D-YMD[4,2,2]" rather than "D4-YMD[4,2,2]". What happens if you: (a) just use Iconv (not Oconv), and (...
by ray.wurlod
Tue Jul 19, 2016 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Should be warning, not info?
Replies: 3
Views: 1706

Message handlers can be used to promote informational messages to warnings.