Search found 42189 matches

by chulett
Tue May 20, 2008 4:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC call from BASIC
Replies: 3
Views: 1540

Unless this has changed in 8.x you are not licensed to use the ODBC drivers that ship with the product outside of the GUI on a UNIX server. Any such BCI code will work for 30 days and then stop working. You'd need to purchase 3rd party drivers to make this work.

Right? :?
by chulett
Tue May 20, 2008 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage scheduler not showing scheduled jobs
Replies: 8
Views: 4024

Not sure what to say. I know how it works, so not sure why you can't see jobs you've just scheduled. Where were you looking for these when you didn't see them? ps. For a 'next five minutes' job, those go into 'at' rather than 'cron' which is for recurring jobs. And once an 'at' job runs it is remove...
by chulett
Tue May 20, 2008 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage scheduler not showing scheduled jobs
Replies: 8
Views: 4024

It only shows jobs scheduled by the current, logged on user. It just reads the user's crontab, so if you didn't schedule it there's nothing to show you.
by chulett
Tue May 20, 2008 3:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No Limit settings
Replies: 4
Views: 2153

As noted, this default value is not a Project level setting, it applies equally to all Projects connected to from that particular client.
by chulett
Tue May 20, 2008 1:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: read txt from a job sequence
Replies: 17
Views: 6277

:D
by chulett
Tue May 20, 2008 1:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pass a value as parameter and use for later job
Replies: 1
Views: 1126

Search the forums for USERSTATUS, all the details are out there.
by chulett
Tue May 20, 2008 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Notification Activity - Email body
Replies: 1
Views: 1144

Not with that stage AFAIK. You could roll your own routine and call DSSendMail() there as one solution. Or a scripted call to sendmail.
by chulett
Tue May 20, 2008 8:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: read txt from a job sequence
Replies: 17
Views: 6277

From a Routine Activity stage, sure. Inside the routine use DSExecute and then remove any @FM before returning the result.
by chulett
Tue May 20, 2008 8:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fatal error in the Master sequence -Datastage Job
Replies: 1
Views: 1475

Welcome aboard. Sorry to whack you on your first post, but is this any kind of a 'testimonial'? In other words, you have posted in an inappropriate forum. There are two forums for questions of this nature (well, technically three if you count the catch-all 'General' forum), one meant for each job ty...
by chulett
Tue May 20, 2008 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: retrive the data from sequential file
Replies: 2
Views: 786

You might want to consider posting your actual abort messages. Otherwise, people will be just... guessing.
by chulett
Tue May 20, 2008 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator Role Issues - Jobs not Found
Replies: 8
Views: 1336

Right, now I recall the DSDIR versus DSDES distinction. None of this will solve the 'View the logs but not run the jobs' problem, though.

Is there now a role in 8.x for this? Or some other way to accomplish this?
by chulett
Tue May 20, 2008 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Verify Trigger Expression
Replies: 6
Views: 2888

Close, you should actually use the documented status codes rather than a direct numeric value:

Code: Select all

StageName.$JobStatus=DSJS.RUNOK Or StageName.$JobStatus=DSJS.RUNWARN
by chulett
Tue May 20, 2008 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Verify Trigger Expression
Replies: 6
Views: 2888

Meaning, you are 'combining' them by choosing a Custom trigger and typing that string that you posted directly into the trigger expression? If so, it's not really working. As noted, those aren't expression but rather two text strings that you are or'ing. That should always resolve to 'true'... did y...
by chulett
Tue May 20, 2008 8:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Abort/Fail PX job
Replies: 6
Views: 2102

Ah, yes... but the Borg don't shout.
by chulett
Tue May 20, 2008 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Abort/Fail PX job
Replies: 6
Views: 2102

Resistance is futile.

:wink: