Search found 53125 matches

by ray.wurlod
Fri Mar 03, 2006 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dealing with complex flat file
Replies: 4
Views: 1638

C:\Program Files\Ascential\DataStage\Docs\parjdev.pdf
by ray.wurlod
Fri Mar 03, 2006 2:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Erro while reading from XML File
Replies: 3
Views: 1341

As it says, "please make sure a column that contains the repetition path is set as key in the output link table definition".
by ray.wurlod
Fri Mar 03, 2006 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dealing with complex flat file
Replies: 4
Views: 1638

There is a stage called the Complex Flat File stage that is purpose-built for this kind of task. Read all about it in Help or in the Parallel Job Developer's Guide manual.
by ray.wurlod
Fri Mar 03, 2006 2:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter Value not being Passed correctly
Replies: 3
Views: 1357

How, exactly, are you passing the parameter value to the job sequence? Please describe precisely how you are doing this. The most common cause for parameter values not being received properly is that they were not passed properly. An event is logged when the job (or job sequence) starts, indicating ...
by ray.wurlod
Fri Mar 03, 2006 12:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Impact Analysis on Columns
Replies: 7
Views: 1939

It remains the case that you can not determine impact unless the table (or file) name remains associated with the job. That is, for example, you can not use a job parameter for the table (or file) name; otherwise an impact analysis can only reveal that "this job affects a table (or file) whose name ...
by ray.wurlod
Fri Mar 03, 2006 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Impact Analysis on Columns
Replies: 7
Views: 1939

The Usage Analysis tool, when run on a table definition, is as close as you'll get to an impact analysis. However, proper functioning of this hinges upon proper management of metadata in jobs - never breaking the link between the job and the table definition(s) loaded into it.
by ray.wurlod
Fri Mar 03, 2006 9:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get diff between two dates in routine
Replies: 12
Views: 7066

The trial period was February. I undestand that we're "go" for premium content now.
by ray.wurlod
Fri Mar 03, 2006 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project NLS settings - default map name
Replies: 1
Views: 1281

What you change in the Administrator ARE the default map names. The only other place you can change this is during installation of the server components.
by ray.wurlod
Fri Mar 03, 2006 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning If I use JobInvocations....
Replies: 15
Views: 4145

That error suggests that the variable called JobHandle had not been assigned a value via a DSAttachJob() function. Any time you use DSAttachJob() it is imperative that you check that it was successful. hJob = DSAttachJob("jobname", DSJ.ERRNONE) If hJob Matches "'-'1N0N" T...
by ray.wurlod
Fri Mar 03, 2006 6:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get diff between two dates in routine
Replies: 12
Views: 7066

When dates are handled in internal format, leap years are handled automatically. So too is the strange year in the 16th century when the Pope added 11 days to a year to get the calendar re-synchronized with the seasons. Don't worry. Be happy.
by ray.wurlod
Fri Mar 03, 2006 6:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to import a job
Replies: 3
Views: 995

It's possible that the DS_JOBOBJECTS hashed file needs to be reindexed, though it's more likely that it has become corrupted. Please try these two commands from the Administrator client Command window and let us know what results. DS.REINDEX DS_JOBOBJECTS SELECT COUNT(*) FROM DS_JOBOBJECTS;
by ray.wurlod
Fri Mar 03, 2006 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage
Replies: 14
Views: 3910

Chapter 5 od the DataStage BASIC manual.
by ray.wurlod
Thu Mar 02, 2006 5:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem logging into DataStage
Replies: 0
Views: 758

It's internal to one of the objects in the GUI. That is it's "their" code that's having the problem; you'll have to contact "them" about it. Please let us know what your support provider does to address the problem. Meanwhile, are you seeing this from all PCs on which DataStage client software is in...
by ray.wurlod
Thu Mar 02, 2006 5:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ms_ole_db multiple row lookup
Replies: 27
Views: 5812

Drag extra links from the Hashed File stage to the Transformer stage.

In your case, move all the link ends to one Hashed File stage then delete the three unconnected Hashed File stages. Resize the remaining Hashed File stage so that your design looks beautiful.
by ray.wurlod
Thu Mar 02, 2006 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null date in transformer
Replies: 14
Views: 5774

Shouldn't it have been

Code: Select all

If IsNull(<Date Field>) Then #DefaultDate# Else <Date Field>    
?