Search found 53125 matches

by ray.wurlod
Thu Aug 04, 2011 1:09 pm
Forum: General
Topic: Information Server and DataStage
Replies: 1
Views: 1265

It's not the same. You can no longer buy just DataStage. Information Server is the platform on which quite a few products, including DataStage, Information Analyzer, Business Glossary, etc., run, automatically sharing their metadata in a common repository.
by ray.wurlod
Thu Aug 04, 2011 1:06 pm
Forum: General
Topic: Get last modification date (and other data) for any job
Replies: 4
Views: 2880

You can only use UniVerse stage from a server job (or a server Shared Container in a parallel job).

You could try an ODBC stage, but I'm not certain that that will work.
by ray.wurlod
Thu Aug 04, 2011 1:01 pm
Forum: IBM QualityStage
Topic: USNAME override input pattern
Replies: 1
Views: 1261

Having added the override, click OK to close the Rule Set then right click on your Rule Set in the Repository and choose Provision All from the menu.
by ray.wurlod
Thu Aug 04, 2011 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look up stage output issue
Replies: 6
Views: 2025

My guess is that you're transferring a column (the key column?) from each reference link. This column is NULL on a failed lookup, which you're representing as "" in your file.
by ray.wurlod
Thu Aug 04, 2011 12:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job should get aborted if date not match
Replies: 5
Views: 1465

You don't need any of that. Simply setting ErrorCode to a non-zero value in the before-job subroutine will cause the job to abort when the routine exits.
by ray.wurlod
Thu Aug 04, 2011 12:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: clob to long varchar
Replies: 4
Views: 2231

We don't get paid for doing this. Your official support provider does.
by ray.wurlod
Thu Aug 04, 2011 12:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Long Month Name from Date
Replies: 24
Views: 12124

pandeesh wrote:It should be March right?
Only if your default date format (in your locale) uses YMD order.
Note that the rules for server jobs are different from the rules for parallel jobs.
by ray.wurlod
Thu Aug 04, 2011 12:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is $ISUSER available in server routines?
Replies: 3
Views: 1918

Sure can. But you have to invoke a command, through DSExecute. You may as well use an operating system shell command (echo) in that case.

Code: Select all

Call DSExecute("SH", "echo $ISUSER", Output, ExitStatus)
Ans = Output<1>
by ray.wurlod
Thu Aug 04, 2011 12:11 am
Forum: General
Topic: Integrate Versioning system with DS 8.5
Replies: 2
Views: 1675

Yes. The short answer is that the integration is done through Information Server Manager. Once you have configured it to talk to your SCCS (and maybe downloaded an Eclipse plug-in for it), new menu items appear. At a recent site where I worked we integrated successfully with SubVersion.
by ray.wurlod
Thu Aug 04, 2011 12:09 am
Forum: General
Topic: DS8.5 Software dowload requirements
Replies: 3
Views: 1453

Check with Fix Central for any fix pack or patch update!
by ray.wurlod
Thu Aug 04, 2011 12:09 am
Forum: General
Topic: deleting lock records from xmetalockinfo table
Replies: 3
Views: 2051

Prefer the script. It only destroys abandoned locks. Other locks are there for a reason - protecting some object.
by ray.wurlod
Thu Aug 04, 2011 12:06 am
Forum: General
Topic: FieldToProp: Internal error - Bad number of subobjects
Replies: 10
Views: 2217

Were the objects (routine and sequence) created in, or imported into, the project?
by ray.wurlod
Wed Aug 03, 2011 3:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job should get aborted if date not match
Replies: 5
Views: 1465

In a before-job subroutine check your conditions and set ErrorCode to a non-zero value if they do not match. I'd prefer a solution where the job doesn't get executed at all. Perform your check in a routine or command executed from a sequence, and use that activity's trigger to determine whether to r...
by ray.wurlod
Wed Aug 03, 2011 3:21 am
Forum: General
Topic: Extract Staus informatiom for DataStageJob Log for Audit
Replies: 1
Views: 976

Change the job designs so that all link names are compliant. At least for the two links in whose counts you have an interest.
by ray.wurlod
Wed Aug 03, 2011 2:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error msg about section leader
Replies: 4
Views: 3391

Have you checked that rsh has been configured to allow password-less login?