Search found 53125 matches

by ray.wurlod
Mon Feb 25, 2013 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Web Service Client Fails: Service invocation exception
Replies: 7
Views: 6144

A java.lang.NullPointerException usually indicates some required information not getting through. Can you invoke this particular service using some other tool such as SOAPui (which is downloadable for free)?

Have you successfully imported the WSDL for this web service?
by ray.wurlod
Mon Feb 25, 2013 2:46 pm
Forum: General
Topic: Need help on job comparsion utility
Replies: 1
Views: 903

I'm not aware of any restrictions. This one looks like a bug to me; you could raise it with your official support provider. You might also check at Fix Central whether there's a patch or fix pack that addresses this particular issue.
by ray.wurlod
Mon Feb 25, 2013 2:32 pm
Forum: IBM QualityStage
Topic: Phonetic Code Generation
Replies: 9
Views: 5113

You can do all of this with QualityStage - no need to use Ab Initio. Maybe Ab Initio can do it all too - that I don't know.
by ray.wurlod
Sun Feb 24, 2013 7:07 pm
Forum: General
Topic: Operations Console issues in 9.1
Replies: 5
Views: 14113

I understood that Ops Console is automatically pre-installed in 9.1. Is this not the case? (Currently at 8.7 site.)
by ray.wurlod
Sun Feb 24, 2013 7:05 pm
Forum: General
Topic: Information Server Architecture –Clarification
Replies: 3
Views: 1205

Seems to me this information is required pre-installation. Might even be an interview question.
by ray.wurlod
Sun Feb 24, 2013 12:16 pm
Forum: General
Topic: Information Server Architecture –Clarification
Replies: 3
Views: 1205

Try IBM Information Center - particularly the Installing section.
by ray.wurlod
Sat Feb 23, 2013 2:34 pm
Forum: IBM QualityStage
Topic: Phonetic Code Generation
Replies: 9
Views: 5113

It's possible, but only if you're creating your own PAL script. Is this the case?
by ray.wurlod
Fri Feb 22, 2013 11:06 pm
Forum: General
Topic: Oracle SQL join vs Data Stage join
Replies: 3
Views: 3356

Welcome aboard. If the join conditions are supported by indexes they will always be faster in the database than DataStage could manage. If the join conditions are not supported by indexes they may still be faster in the database (check the execution plan) or they may be faster in DataStage. DataStag...
by ray.wurlod
Fri Feb 22, 2013 3:54 pm
Forum: General
Topic: Rename folder is still showing with previous name in direcor
Replies: 9
Views: 1893

I don't believe so, Craig. Case-sensitivity is the rule for identifier names in the DataStage environment.
by ray.wurlod
Fri Feb 22, 2013 3:51 pm
Forum: General
Topic: Design scenario for calling sequence multiple times
Replies: 9
Views: 2446

Definitely. Use a "list of things" loop. Pass it a delimited list of file pathnames. Within the loop access the activity variable StartLoop.$Counter which will contain the pathname of the file for that iteration. (StartLoop needs to be replaced with the name you used for your Start Loop ac...
by ray.wurlod
Fri Feb 22, 2013 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile error--invoke GenRuntime using phantom process helpe
Replies: 13
Views: 19663

That's because the ASCII representation for the Euro symbol (Char(128) is the same as that which DataStage uses internally for NULL. DataStage had this long before the Euro was invented. There is an environment variable that can be set to specify a different internal representation of NULL (for exam...
by ray.wurlod
Fri Feb 22, 2013 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Find Pointers - created out of account directory
Replies: 1
Views: 1136

There is a pre-stored command for listing remote hashed files.

Code: Select all

LISTFR
Slightly more accurate, since LISTFR includes the DSEngine directory, would be

Code: Select all

SELECT F0 AS HashedFileName, F2 AS PathName FMT '50L' FROM VOC WHERE F1 LIKE 'F%' AND F2 LIKE '%/%' AND F2 NOT LIKE '%DSEngine%';
by ray.wurlod
Fri Feb 22, 2013 3:37 pm
Forum: General
Topic: Get previous job completion status
Replies: 5
Views: 2640

You could check the sequence's log, where there may be enough old entries for you to determine the most recent successful completion (after all, log purge does not occur if a job (or sequence) fails). Otherwise, if you're on version 8.7 or later and have implemented DataStage Operations Console, the...
by ray.wurlod
Fri Feb 22, 2013 3:35 pm
Forum: General
Topic: Rename folder is still showing with previous name in direcor
Replies: 9
Views: 1893

Then it appears that your rename has worked in only one of the two repositories. This can be remedied using SyncProject (a part of ISALite).
by ray.wurlod
Fri Feb 22, 2013 3:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: issue when migrating jobs from datastage 8.1 to 8.7
Replies: 1
Views: 2242

Welcome aboard.

253 is an important value in DataStage server edition; it encodes "value mark", one of the dynamic array delimiters.

You could try entering it in hexadecimal. I can't recall exactly how to do this (currently in an airport lounge) but it would be something like &xFD