Search found 42189 matches

by chulett
Tue Mar 03, 2009 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp with Microseconds in Parallel
Replies: 6
Views: 2791

:? You've already got the microseconds... not really sure what you're asking here.
by chulett
Tue Mar 03, 2009 1:52 pm
Forum: General
Topic: Constraint on Sequencer job to attach doc to email only if..
Replies: 1
Views: 1129

No script needed. You can build yourself a generic routine that takes a Job, Stage and Link name as parameters and leverages DSGetLinkInfo to get the record count written down the link to your sequential file. The trigger to your Notification Activity could then check if the count was > 0. If the fi...
by chulett
Tue Mar 03, 2009 1:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp with Microseconds in Parallel
Replies: 6
Views: 2791

You should be able to take that value directly into Oracle with the TO_TIMESTAMP() function provided your Oracle TIMESTAMP field was created with that fractional seconds precision. Luckily, 6 is the default so more than likely you should be ok there. I would think you should keep the target datatype...
by chulett
Tue Mar 03, 2009 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Project
Replies: 3
Views: 1048

Or that would be fine as well. Really just wanted to stop any idea about manipulating repository tables via 'UV commands' but sticking with the published API - GUI or otherwise - is fine.
by chulett
Tue Mar 03, 2009 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create Project
Replies: 3
Views: 1048

No, stick with the Administrator GUI.
by chulett
Tue Mar 03, 2009 12:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to call a routine in PX job
Replies: 5
Views: 1328

You don't need to do so, use the built-in Parallel functions you have instead. A combination of StringToDate() followed by a DateToString() would be what you need for a date field, there are also Timestamp equivalents. These functions are listed in the appendix of the Parallel Job Developer's Guide ...
by chulett
Tue Mar 03, 2009 11:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Install time for minimal 8.1 config
Replies: 3
Views: 1574

So much for the 'less than half-way thru', eh? :wink:
by chulett
Tue Mar 03, 2009 10:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle sequence resued for processing.
Replies: 15
Views: 3239

Once they've been replied to, they cannot be deleted, which is why it's important to check right away when you suspect there might have been a problem. Best you could do now would be to edit two of them and just say 'duplicate post' or some such in the body.
by chulett
Tue Mar 03, 2009 10:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size Limit Environment variable
Replies: 4
Views: 3179

How are you checking? You can't use "the same user" and check from the command line, you need to check from a job's environment. Take any job and add an "ExecSH" before-job call to "ulimit -a" and see what it logs... unless you've already done that?
by chulett
Tue Mar 03, 2009 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Size Limit Environment variable
Replies: 4
Views: 3179

That's controlled by the operating system via the ulimit function. Have a chat with your SysAdmin and see if they're willing to bump that up for your user.
by chulett
Tue Mar 03, 2009 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle sequence resued for processing.
Replies: 15
Views: 3239

Sheesh... posts so good they need to be repeated - three times. Seriously, please start checking after you post and delete any duplicates, especially if it takes 'some time' to complete - that's pretty much a sure sign you'll have duplicate posts.
by chulett
Tue Mar 03, 2009 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML OUTPUT stage with same tag name
Replies: 5
Views: 1645

Please post your XPath Expressions.
by chulett
Tue Mar 03, 2009 8:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML OUTPUT stage with same tag name
Replies: 5
Views: 1645

Have you tried marking that column as a Key?
by chulett
Tue Mar 03, 2009 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage
Replies: 1
Views: 695

It was built primarily for feeding the XML Input stage, from what I've read, but can be used to read filenames from a directory or write multiple files to a directory.