Search found 53125 matches

by ray.wurlod
Tue May 17, 2011 3:18 pm
Forum: General
Topic: export dependent jobs,td's etc using istool
Replies: 4
Views: 2223

What's the resolution?
by ray.wurlod
Tue May 17, 2011 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rollback Procedure
Replies: 1
Views: 897

Set the commit interval to 0 rows. (0 = all)

Placate your DBA.
by ray.wurlod
Tue May 17, 2011 3:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning while reading fixed width file
Replies: 2
Views: 2003

Was the file created on Windows? My guess is that it has CRLF line terminators but you are specifying UNIX style in your Format properties.
by ray.wurlod
Tue May 17, 2011 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage jobs not running and validating
Replies: 5
Views: 2818

Look in the log to learn what's wrong.
by ray.wurlod
Tue May 17, 2011 3:10 pm
Forum: General
Topic: new project locked by DataStageSystemUser
Replies: 5
Views: 3520

Did you make it a protected project?
by ray.wurlod
Tue May 17, 2011 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hash file update problem
Replies: 3
Views: 1982

Make very sure that your hashed file metadata are 100% correct. Hashed files are navigated by position of the field in the record, not by column name. Examine the Position field in the Columns grid.
by ray.wurlod
Tue May 17, 2011 3:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clearing mulitiple hash files in a single attempt
Replies: 3
Views: 1494

Set the Hashed File stages to "clear before writing".

Why do you want to clear them otherwise? It does not give back any disk space.

Please be more careful with your spelling.
by ray.wurlod
Tue May 17, 2011 3:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compare two tables with same structures in different servers
Replies: 12
Views: 8299

Use a lookup from one table to the other. Perform whatever comparisons you need in the Transformer stage.
by ray.wurlod
Tue May 17, 2011 3:04 pm
Forum: General
Topic: I want to copy a file to a network drive
Replies: 4
Views: 2089

The ALLOWNFS parameter in uvconfig must also be set.
by ray.wurlod
Tue May 17, 2011 3:04 pm
Forum: General
Topic: &PH& file cleared but the directory size is not redu
Replies: 20
Views: 9837

&PH& automatically has a VOC entry. How are you determining its size? &PH& is a sub-directory in the project directory.
by ray.wurlod
Mon May 16, 2011 11:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to start and stop ASB andd Log agents
Replies: 2
Views: 1510

That's totally unrelated. Please begin a new thread for it.
by ray.wurlod
Mon May 16, 2011 11:13 pm
Forum: General
Topic: max value of table column value as vriable in the sequencer
Replies: 3
Views: 1724

Make the first (or an early) activity in the sequence a Job activity that fetches the maximum value and loads it into its own user status area. A server job is always recommended for processing just one row. The job activity's $UserStatus activity variable is available anywhere downstream of the act...
by ray.wurlod
Mon May 16, 2011 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Working with Dates
Replies: 1
Views: 1104

There are basically two approaches. One is to perform arithmetic on the individual components, the other is to use something like DateFromDaysSince() function with an offset of -183 days (a close approximation to six months).
by ray.wurlod
Mon May 16, 2011 8:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to start and stop ASB andd Log agents
Replies: 2
Views: 1510

I don't think this is related to the node agents. Another site where I worked recently had the same java.lang.NullPointerException issue (on AIX) and received a patch from IBM to fix it. There are scripts - from memory NodeAgentsStart.sh and NodeAgentsStop.sh - for starting and stopping the node age...
by ray.wurlod
Mon May 16, 2011 6:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incremental Lookup
Replies: 4
Views: 1927

Try using a Merge stage, which consumes rows loaded from the Update input. However, your "restart from the top" requirement can not be implemented using this stage type. That would call for some kind of circularity for which, I suspect, you will need a Build stage (or a routine that loads ...