Search found 42189 matches

by chulett
Wed Jul 27, 2016 10:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Having issues reading XML files with line breaks
Replies: 5
Views: 6098

True dat. No clue what the limit is any more but back in the day when we were processing "large" XML files, it seemed better to just pass the URL to the XML Input stage and let it do all of the work. From what I recall. :wink:
by chulett
Wed Jul 27, 2016 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Maximim file size that CFF stage can handle
Replies: 3
Views: 2183

Don't see why not, that's not especially "large" in my book. If you are really concerned, I'd say that would be a support question.
by chulett
Wed Jul 27, 2016 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Having issues reading XML files with line breaks
Replies: 5
Views: 6098

Can you confirm for us what the first stage in your job is - sequential file stage? If so, suggest you replace it with a Folder stage (ideally just passing in the filename and letting the XML Input stage do the reading) and see if the problem persists.
by chulett
Tue Jul 26, 2016 9:40 am
Forum: General
Topic: Tier Level for Datastage
Replies: 6
Views: 2541

:D
by chulett
Tue Jul 26, 2016 6:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 3164

SURA - almost 1200 posts and you are still quoting entire messages to reply? Please learn to love the Reply to topic button, less for me to clean up that way. :wink:
by chulett
Mon Jul 25, 2016 7:27 am
Forum: General
Topic: How to get yesterday date in job sequence
Replies: 5
Views: 2967

Seriously, it's not like you're the first person to ask this over the years. Short answer? Today's date in internal format, subtract 1, convert to external.
by chulett
Sun Jul 24, 2016 11:38 pm
Forum: Site/Forum
Topic: Keep asking password while reply
Replies: 4
Views: 7656

Hello? Is someone there?

<odd, could have sworn I heard something>
by chulett
Sun Jul 24, 2016 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector Stage - Delete vs Truncate
Replies: 5
Views: 3888

Right. No-one said there was no difference, just that's there's no need to do both.
by chulett
Sun Jul 24, 2016 6:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Long running Oracle SQL ..Implement stats in DataStage job
Replies: 4
Views: 2752

You job's running user will certainly NOT have grants to analyze anything owned by sysadm... that is strictly DBA Only territory. If that is a "user" table, get it out of that schema.
by chulett
Sun Jul 24, 2016 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 3164

rkashyap wrote:Could you share the requirement in words. Examples are good, but only in conjunction with a requirement description. ;-)
Real examples are good. Made up ones? Not so much.
by chulett
Sun Jul 24, 2016 6:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle connector Stage - Delete vs Truncate
Replies: 5
Views: 3888

Concur - why? One or the other, zero need for both.
by chulett
Sun Jul 24, 2016 6:16 pm
Forum: Site/Forum
Topic: Keep asking password while reply
Replies: 4
Views: 7656

Yup. :wink:

Clearing all cookies may help, me thinks.
by chulett
Tue Jul 19, 2016 1:36 pm
Forum: General
Topic: Determine if a ExeCmd is invoked inside Exception Block
Replies: 7
Views: 3095

As already noted, there's no such API. Hence the other suggestions.
by chulett
Mon Jul 18, 2016 12:12 pm
Forum: IBM QualityStage
Topic: AVI Setup or Installation Process
Replies: 16
Views: 20740

Why not just run a 'find' on the server, let it locate it for you?
by chulett
Mon Jul 18, 2016 6:42 am
Forum: General
Topic: Determine if a ExeCmd is invoked inside Exception Block
Replies: 7
Views: 3095

There's a way to check the "interimstatus" of a job to see if it is going to abort when it wraps up, that might be helpful but AFAIK it's only available from a routine, not from the command line. Just a thought but don't you know if it is "executing inside the Exception Handler" ...