Search found 53125 matches

by ray.wurlod
Wed Mar 05, 2008 2:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing logs to a file
Replies: 3
Views: 1092

That's a much different matter than the whole job log. You can easily append to the file. Use the OpenSequentialFile routine (search the forum) to open the file in "Append" mode, then use WriteSeq statement(s) to write a line at a time to the file. Don't forget to CloseSeq the file when done. Or you...
by ray.wurlod
Wed Mar 05, 2008 2:11 am
Forum: Site/Forum
Topic: cuse of could not get current wave number in my job
Replies: 1
Views: 2076

How, precisely, does this question relate to the DSXchange site/forum?

Please post your question on the forum appropriate to your job type. The answer may be different depending upon the job type.
by ray.wurlod
Tue Mar 04, 2008 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NOT GETTING PERFORMANCE STATISTICS
Replies: 16
Views: 5235

Under the Diagram menu there is an option Show Performance Statistics. Do you have this selected?
by ray.wurlod
Tue Mar 04, 2008 10:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing logs to a file
Replies: 3
Views: 1092

Job logs are database tables in the Repository database. So let's begin by asking how you are currently writing these to file? Could not that process be adapted to append to the file?
by ray.wurlod
Tue Mar 04, 2008 10:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding content validation
Replies: 6
Views: 1442

Code: Select all

Field(InLink.policy_no, "-", 1, 1)
by ray.wurlod
Tue Mar 04, 2008 9:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the period "." in a string in transfor
Replies: 5
Views: 1296

Or just:

Code: Select all

Count(InLink.TheString, ".")


There are many ways to skin this particular cat!
by ray.wurlod
Tue Mar 04, 2008 5:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find the period "." in a string in transfor
Replies: 5
Views: 1296

Code: Select all

Index(InLink.TheString, ".", 1) > 0
by ray.wurlod
Tue Mar 04, 2008 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing all characters before a certain type of character
Replies: 6
Views: 1543

Yes, Field() is available in parallel Transformer expressions.
by ray.wurlod
Tue Mar 04, 2008 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing all characters before a certain type of character
Replies: 6
Views: 1543

Yes, Field() is available in parallel Transformer expressions.
by ray.wurlod
Tue Mar 04, 2008 5:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while setting oracle path
Replies: 1
Views: 781

Why, when the error was clearly telling you that there was a problem with PATH, did you think that changing other environment variables would have any effect? It's the PATH environment variable that needs to be corrected - perhaps by inclusion of ${ORACLE_HOME}/bin.
by ray.wurlod
Tue Mar 04, 2008 5:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to read from an Excel file using java client stage
Replies: 3
Views: 1144

Can you read Excel worksheets using a different (non-DataStage) Java client?
by ray.wurlod
Tue Mar 04, 2008 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input Stage Replace Empty Values with Null
Replies: 6
Views: 2540

How do you claim to be able to "see" non-printing characters such as, perhaps, Esc in the XML file?
by ray.wurlod
Tue Mar 04, 2008 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete datastage log in director
Replies: 10
Views: 4741

Some sites have issues with compiling in a production environment.

Just out of curiosity does anyone know whether it's even possible to compile in a protected project? The site where I'm currently working does not use protected projects.
by ray.wurlod
Tue Mar 04, 2008 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diff. Node pool vs Node map
Replies: 1
Views: 1006

What did you learn when you clicked on the Help button from this page? Do you have any specific questions about what you read there?
by ray.wurlod
Tue Mar 04, 2008 5:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: generating flat file from xml file
Replies: 29
Views: 7547

UNIX commands don't work with Windows pathnames. Use the UNIX form of the pathname: for example ls -1 /tmp/*.xml (This assumes that DataStage server is installed on the C: drive.)