Search found 53125 matches

by ray.wurlod
Wed Mar 14, 2012 3:26 pm
Forum: General
Topic: DataStage Designer collides with QTP -QuickTest Professional
Replies: 4
Views: 2224

What port numbers does QTP use? Do any of these clash with the IBM InfoSphere Information Server port numbers? Does QTP report any startup errors?
by ray.wurlod
Wed Mar 14, 2012 3:22 pm
Forum: Data Quality Best Practices
Topic: Business Glossary 8.7 CSV import & special characters
Replies: 3
Views: 9434

This works for Metadata Asset Manager; it may also work for Business Glossary imports. Create a file called admin.properties containing the following four lines. mmi.admin.invalidIdentities.autoClean.precedingWhiteSpace=true mmi.admin.invalidIdentities.autoClean.trailingWhiteSpace=true mmi.admin.inv...
by ray.wurlod
Tue Mar 13, 2012 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Subtract time microseconds
Replies: 8
Views: 2392

SecondsSinceFromTimestamp() function?
by ray.wurlod
Tue Mar 13, 2012 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input stage
Replies: 9
Views: 4194

How did u able to resolve this problem.I am also facing the same issue, plz help me out. The second person personal pronoun in English is spelled "you", not "u". There is no word "plz" in English - I suspect you mean "please". Please strive for a professional...
by ray.wurlod
Tue Mar 13, 2012 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange Datastage Error in 8.5
Replies: 6
Views: 5129

Craig is being assertive.
:lol:
by ray.wurlod
Tue Mar 13, 2012 1:42 pm
Forum: General
Topic: Email notification on NON Business hours
Replies: 4
Views: 1199

Code: Select all

Left(Oconv(Date(),"DWB"),1) <> "S" And (Time < Iconv("08:00","MT") Or Time() > Iconv("20:00","MT"))
This could be a User Variable definition expression.
by ray.wurlod
Tue Mar 13, 2012 2:33 am
Forum: General
Topic: Email notification on NON Business hours
Replies: 4
Views: 1199

Create job designs that don't abort. Then, if they abort for environmental reasons, you can trap the job status in the controlling sequence and send email based on any conditions you wish. Implement the condition logic in a Nested Condition activity.
by ray.wurlod
Mon Mar 12, 2012 9:51 pm
Forum: General
Topic: Changing of Dsadm Uid:0 to other
Replies: 1
Views: 1155

Although there is a script for resetting the permissions. You need also to research root versus non-root administration in the Administration manual, and "impersonation mode" in particular.
by ray.wurlod
Mon Mar 12, 2012 6:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: null character
Replies: 3
Views: 914

Define APT_STRING_PADCHAR correctly.
by ray.wurlod
Mon Mar 12, 2012 1:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: many reports in one file
Replies: 8
Views: 3122

How do you identify the various reports? The beginning of the report? The end of the report?
by ray.wurlod
Mon Mar 12, 2012 11:37 am
Forum: IBM QualityStage
Topic: Suspect matchng in Qualitystage
Replies: 3
Views: 2323

Use special variable handling on gender CRITICAL MISSING OK, or apply a heavy disagreement weight override to gender. This does not seem to be a candidate for a reference match (where's your second input?): prefer an Unduplicate match in this case.
by ray.wurlod
Sun Mar 11, 2012 11:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: script to process a file
Replies: 15
Views: 3425

Whatever you want it to be. When you read your file it's the line terminator character, but you can convert that you anything you like in a User Variables activity.
by ray.wurlod
Sun Mar 11, 2012 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Date logic
Replies: 14
Views: 3691

kandyshandy left out one "not".
1900 was not a leap year.
2000 was a leap year.
2100 will not be a leap year.
2400 will be a leap year.
by ray.wurlod
Sat Mar 10, 2012 8:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can it be possible to calculate sum of salary and number of
Replies: 3
Views: 1196

It can be done with a single Aggregator stage, but you might have to use SUM(1) rather than COUNT.
by ray.wurlod
Sat Mar 10, 2012 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: script to process a file
Replies: 15
Views: 3425

... or, indeed, a looping sequence job that uses the contents of your file of file names. The technique has been explained on DSXchange in the past.