Search found 53125 matches

by ray.wurlod
Sun Nov 14, 2010 3:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File name is aready present in VOC file definition -error
Replies: 13
Views: 4749

Remove the VOC entry separately via

Code: Select all

DELETE FROM VOC WHERE @ID = '<<HashedFileName>>';
- a DELETE.FILE command will also remove the VOC entry. Execute either from the Administrator client Command window.
by ray.wurlod
Sun Nov 14, 2010 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File name is aready present in VOC file definition -error
Replies: 13
Views: 4749

Yes, that would do it. Account = project.
by ray.wurlod
Sat Nov 13, 2010 11:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File name is aready present in VOC file definition -error
Replies: 13
Views: 4749

Has anyone used a SETFILE command to create a VOC entry for the hashed file? Have you accidentally chosen to create a pathed hashed file that has the same name as an extant VOC entry (what is the name of your hashed file)?
by ray.wurlod
Sat Nov 13, 2010 6:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in ODBC stage but view data returns fine
Replies: 2
Views: 1321

So it looks like an issue with parameter value passing. Take a look at the osh generated by View Data and compare that with the generated osh (and the score) used at run time.
by ray.wurlod
Sat Nov 13, 2010 6:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing symbols other that numbers
Replies: 4
Views: 1468

Every character is a symbol, or glyph, including numeric characters. Can you be more specific?

In particular, is your intended rule to remove non-numeric characters, or is it only specific characters (non-alphanumeric?) that you want to remove?

Have you executed a Search of DSXchange?
by ray.wurlod
Sat Nov 13, 2010 6:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert value from -00005.55 to -5.55
Replies: 17
Views: 6211

Did you mean DecimalToString() ?
by ray.wurlod
Sat Nov 13, 2010 6:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What are Routines and where are they get created?
Replies: 1
Views: 968

Parallel routines are not created in DataStage at all. They are created as separate C++ functions, which are compiled and linked in the usual C++ ways. What you do need to create in the Routines branch of the Repository is an entry that records the existence, location and argument definitions of the...
by ray.wurlod
Sat Nov 13, 2010 6:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File name is aready present in VOC file definition -error
Replies: 13
Views: 4749

If there's VOC entry you must go through DELETE.FILE (or a DELETE command against VOC). For remote (pathed) hashed files you may still need to execute the recursive rm command, as well as a separate rm command for the file dictionary D_hashedfilename.
by ray.wurlod
Sat Nov 13, 2010 6:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parameter name --> Password
Replies: 9
Views: 2665

Leave?!! You're permitted to take leave?!!
:lol:
by ray.wurlod
Sat Nov 13, 2010 6:09 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Decimal to String conversion in a rule
Replies: 2
Views: 2147

If this is a Rule Definition, can you specify the value as a global logical variable, as just 124?
by ray.wurlod
Fri Nov 12, 2010 6:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exception Handler triggered by a Routine Activity result
Replies: 1
Views: 2228

A return value of 0 will not trigger the Exception Handler (same rule applies to Execute Command activity). Any other value WILL trigger the Exception Handler unless "failures" (non-zero returns) are explicitly handled using activity triggers, which take precedence.
by ray.wurlod
Fri Nov 12, 2010 6:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reducing Swap Usage in Simple Jobs
Replies: 9
Views: 2279

Was it not Bill Gates who asserted that you should never need more than 640KB of memory?
:roll:
by ray.wurlod
Fri Nov 12, 2010 6:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pushing to data to new column when loading into oracle table
Replies: 2
Views: 1012

Welcome aboard.

"ABCD"F"GH" is not a valid construction according to CSV rules. Please have your data provider give you valid format files.
by ray.wurlod
Fri Nov 12, 2010 6:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing symbols other that numbers
Replies: 4
Views: 1468

What does "special" mean?