Search found 53125 matches

by ray.wurlod
Tue Aug 11, 2015 5:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: getting error in datastage 11.3
Replies: 6
Views: 4351

I was surprised to see in this thread that DataStage reports No default type conversion from type "date" to type "string[10]". ​ I had formed the view that everything could be implicitly converted to string if the size is large enough. However, upon checking the IBM Knowledge Cen...
by ray.wurlod
Tue Aug 11, 2015 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML input stage
Replies: 5
Views: 1993

karry450 wrote:Sorry I don't have a premium membership to lookinto can you please help

Why not get one? You're over 200 posts, so clearly benefiting from DSXchange. Premium memberships make up the funding mechanism that keeps DSXchange alive.
by ray.wurlod
Tue Aug 11, 2015 4:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Transformer Quesion
Replies: 2
Views: 1350

Make sure that you do this, or specify one of the environment variables that prevent DataStage from inserting a tsort operator. Otherwise your sorted data will be re-sorted, a waste of everyone's time.
by ray.wurlod
Mon Aug 10, 2015 11:57 pm
Forum: Site/Forum
Topic: Premium Membership issue
Replies: 7
Views: 10776

So, to the computer hosting DSXchange, pavan5035 and pavi are not the same.

Login as pavi and you should be able to see the premium content.
by ray.wurlod
Mon Aug 10, 2015 11:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reformatting records
Replies: 2
Views: 1528

... and pay particular attention to partitioning requirements therefor.
by ray.wurlod
Mon Aug 10, 2015 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance bench marks on External source stage
Replies: 8
Views: 4282

How many more "for one time" requests will you make? Get a premium membership; this is the mechanism that keeps DSXchange alive (funded).
by ray.wurlod
Mon Aug 10, 2015 4:27 pm
Forum: General
Topic: MultiInstance Sequncer failing with Error code 255
Replies: 19
Views: 5042

Try removing -wait from the dsjob command. Technically -wait and -jobstatus are incompatible options. The -jobstatus option will still cause the command to wait until the job completes, so that it can report the job status.
by ray.wurlod
Mon Aug 10, 2015 4:22 pm
Forum: General
Topic: Way to Retrieve the Transformations of a Job
Replies: 17
Views: 6354

Metadata Workbench does not require that you have a sequence. It does, however, require that you've used, or converted to, shared table definitions.
by ray.wurlod
Mon Aug 10, 2015 4:20 pm
Forum: IBM QualityStage
Topic: Pattern Action File Coding Help
Replies: 4
Views: 4127

Does what you've done throw an error, or merely an incorrect result?
^ is a numeric token, so would never match any part of "metal chassis". Try this pattern/action instead:

Code: Select all

A|B|? [ {} = "metal chassis" ]|^|**
COPY "specialpattern" {OutputColumn}
by ray.wurlod
Fri Aug 07, 2015 5:29 am
Forum: General
Topic: Sequence status is 99
Replies: 18
Views: 6600

What happens if you specify DSJ.JOBINTERIMSTATUS in the call to DSGetJobInfo() ?
by ray.wurlod
Fri Aug 07, 2015 5:28 am
Forum: General
Topic: NullPointerException occurs during installation
Replies: 11
Views: 6621

You must be a local Administrator. Domain Administrator will not do it.
by ray.wurlod
Fri Aug 07, 2015 5:27 am
Forum: General
Topic: Way to Retrieve the Transformations of a Job
Replies: 17
Views: 6354

If you have Metadata Workbench you can request a data lineage report that will give you the transformations.
by ray.wurlod
Thu Aug 06, 2015 3:41 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Data Source Password Change Causing Column Analysis to Fail
Replies: 11
Views: 8747

Can't you update the password in the Connector you are using to read from source?
by ray.wurlod
Wed Aug 05, 2015 10:15 pm
Forum: General
Topic: Sequence status is 99
Replies: 18
Views: 6600

SURA wrote:That's not seems consistence to me!
Given that the official decoding of 99 is "other" it is entirely consistent.
by ray.wurlod
Wed Aug 05, 2015 10:10 pm
Forum: General
Topic: Parameterset Import issue
Replies: 3
Views: 1373

Can you try using the istool command to export and import the Parameter Set? (or its GUI, Information Server Manager)