Search found 42189 matches

by chulett
Thu Aug 28, 2008 9:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job getting Reset before running
Replies: 17
Views: 4183

But you also lose information if you reset automatically afterwards, so I personally think it is a bad idea. My dsjob run script (amongst other things) validates that the job exists, checks to see if it needs to be reset and does so if it needs to and then runs the job.
by chulett
Thu Aug 28, 2008 9:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job getting Reset before running
Replies: 17
Views: 4183

That's what the command does, reset. Only. It is a separate dsjob command from running a job, so if you want to do both you have to call dsjob twice. And typically one would reset before running, not after, as you make it harder to know what happened if you reset before getting a chance to look at t...
by chulett
Thu Aug 28, 2008 9:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Upgrading to Version 8 from 7.1
Replies: 7
Views: 3155

Yes, it is done through exporting to .dsx files.
by chulett
Thu Aug 28, 2008 9:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job getting Reset before running
Replies: 17
Views: 4183

Did you mean to say it is *not* getting reset? :?

You need to clarify exactly what problem you think you are having.
by chulett
Thu Aug 28, 2008 8:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Strange Issue with scheduling a job
Replies: 6
Views: 1655

Wouldn't you be better off posting this question in a Business Objects forum?
by chulett
Thu Aug 28, 2008 8:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run-time error '457'
Replies: 10
Views: 8319

Interesting... a people issue, I assume.
by chulett
Thu Aug 28, 2008 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Stage in PX
Replies: 11
Views: 3572

Have you shown the error message to whomever is the Admin for that server? Asked for their help?
by chulett
Thu Aug 28, 2008 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterizing Attached file path in DSSendmail routine
Replies: 6
Views: 3349

I've had no issues using Job Parameters in the Notification Activity for either email address, the subject nor the attachment, all happily support them. As noted and AFAIK the body doesn't but it's been a long time since I've tried that. Your problem is the fact that you are passing in a literal str...
by chulett
Thu Aug 28, 2008 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterizing Attached file path in DSSendmail routine
Replies: 6
Views: 3349

shaonli wrote:Sorry the job is Parallel

Sorry, the job is Sequence. :wink:
by chulett
Thu Aug 28, 2008 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: VOC :: Pointer creation limit
Replies: 2
Views: 1592

Why not delete them when no longer needed?
by chulett
Thu Aug 28, 2008 7:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Constraint in Job Mainframe,
Replies: 5
Views: 2369

:!: This has nothing to do with the original posted topic and this kind of 'hijack' is frowned upon. Please start a new post in proper forum so we have all your particulars i.e. if you are talking Server or PX job, version number, O/S, etc.
by chulett
Wed Aug 27, 2008 10:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control repository
Replies: 11
Views: 4970

So Larz is now DrPhys, it seems. You could select them all at once, no need for doing it one at a time: SELECT CATEGORY, NAME, JOBNO FROM DS_JOBS WHERE NAME NOT LIKE "\\\%"; If you use the Administrator to run the query, the COMO commands can get you spooled output. Search the forums for '...
by chulett
Wed Aug 27, 2008 9:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple v8 installs on the same server?
Replies: 15
Views: 4043

Don't know how v8 changes the picture, or even if it does, but DS supports multiple servers installed on the same host using an 'itag' installation. Hopefully they've updated the docs - look for a (from memory) multiserv.pdf document in your Docs directory.
by chulett
Wed Aug 27, 2008 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to find Age --using DOB and currDate
Replies: 2
Views: 1062

How about DaysFromDateSince() and then divide by 365?