Search found 42189 matches

by chulett
Mon Aug 11, 2008 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data using External_Source stage
Replies: 2
Views: 807

Moderator please move to the PX forum.
by chulett
Mon Aug 11, 2008 6:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data using External_Source stage
Replies: 2
Views: 807

Suprisingly, the details on this stage are in the manual. Please read the Parallel Job Developer's Guide chapter for this and then let us know if you have questions. If you are looking for an example of what it might be used for, the classic seems to be to get a list of filenames from your O/S to fe...
by chulett
Mon Aug 11, 2008 6:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to subtract between two timestamps in datastage server
Replies: 2
Views: 5437

Basically the same way but you need to convert the time separately (using "MTS"), add the time to the date then subtract. Lastly, convert the result back to hours.
by chulett
Sun Aug 10, 2008 9:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 32
Views: 9455

It's telling you it exists in the template but was not set in your call. It you really want to check the template, you'll find it in each Project directory but sounds like it doesn't like what you are passing to it.
by chulett
Sun Aug 10, 2008 2:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata API not deleting data
Replies: 2
Views: 899

In my mind, the first thing to double-check is that you are actually sending the data that you think you are sending that matches the key fields in the where clause. Make sure that it does, in fact, exactly match what is in the target table and there are no extra spaces (etc) in what you send to the...
by chulett
Sun Aug 10, 2008 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dsrunjob with Invocationid
Replies: 1
Views: 1053

Include the invocation id as part of the job's name with a 'dot' separator:

Jobname.InvocationID

Same as you would for dsjob from the command line.
by chulett
Sun Aug 10, 2008 2:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 32
Views: 9455

:? You are making it hard for us to help you by not providing the details requested. Open the job's log in the Director and post any errors or warnings you find there. Copy to the clipboard and paste here the entire error messages.
by chulett
Sun Aug 10, 2008 9:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character set issue
Replies: 6
Views: 2251

chulett wrote:Does NLS ISO8859-6 support these Arabic characters? If not, then there's no amount of magic you can do to make this work. As noted, US7ASCII sure won't. :?

Guess I should have looked up what it was. :lol:
by chulett
Sun Aug 10, 2008 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Character set issue
Replies: 6
Views: 2251

Does NLS ISO8859-6 support these Arabic characters? If not, then there's no amount of magic you can do to make this work. As noted, US7ASCII sure won't. Is that your character set at both the source and the target? If so, you'll need to override the setting of any other character set while the job r...
by chulett
Sun Aug 10, 2008 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot show Job Sequence properties
Replies: 3
Views: 998

This sounds like the classic "need the Service Pack 2 patch" problem, assuming your XP has SP2 installed. If so, you'll need to request the patch from your support provider.
by chulett
Sat Aug 09, 2008 9:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 32
Views: 9455

You have to pass a string in the format needed by the routine, one that contains "from", "to", etc properly delimited. As noted, double-click on the routine (sdk\Built-In\Before/After) for the details. It's all documented there.
by chulett
Sat Aug 09, 2008 1:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email Notification
Replies: 32
Views: 9455

The Notification Activity stage is a Sequence job stage. To use DSSendMail directly, just pick it from the list of 'After Job' routines. Open it in the Manager to learn what to pass to it.
by chulett
Sat Aug 09, 2008 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How To Convert EXE Jobs into Design.
Replies: 2
Views: 807

Please explain exactly what you have left to work with. Also be curious what happened to get you into this state. :?
by chulett
Fri Aug 08, 2008 5:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe/Hash file lookup - Job running too long
Replies: 12
Views: 3318

Oh, yah... that was the kicker - UniVerse table. :wink:
by chulett
Fri Aug 08, 2008 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Format
Replies: 7
Views: 2183

That's certainly one variation. :wink: