Search found 53125 matches

by ray.wurlod
Sun Feb 21, 2016 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert Normal Date Into Julian Date
Replies: 12
Views: 9465

Try Oconv(Iconv(InLink.TheDate, "DYMD"), "DYJ['1',2,3]" : @VM : "MCN") You may like to finagle the century indicator based on the second character of the date string. InLink.TheDate[2,1] + 1 : Oconv(Iconv(InLink.TheDate, "DYMD"), "DYJ[2,3]" : @VM : &...
by ray.wurlod
Sun Feb 21, 2016 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion error warning
Replies: 4
Views: 2217

Or just enable the Unicode extension on your output field so that it, too, is data type ustring.
by ray.wurlod
Sun Feb 21, 2016 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage partitioning
Replies: 6
Views: 2896

I don't think IBM's money was wasted, Uncle Kim. :wink:
by ray.wurlod
Sun Feb 21, 2016 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 11.5 Backward compatibility not working
Replies: 6
Views: 12011

It's called the Connector Migration Tool, and is mentioned in the error messages.

Another change in 11.x is that HTTP for connecting is no longer supported. People seem to have taken that one in their stride.
by ray.wurlod
Sun Feb 21, 2016 3:30 pm
Forum: General
Topic: How to concatenate two parameter and pass as Invocation Id
Replies: 2
Views: 1710

The second # is flagging the end of a reference value, it would appear.

Try inserting a user variables activity to construct the full required instance ID, and use the user variable as the invocation ID.
by ray.wurlod
Sun Feb 21, 2016 3:23 pm
Forum: General
Topic: Stewardship Center
Replies: 3
Views: 1624

Thanks, Vincent I had a bit of a play with it at Insight 2015, and of course attended the DSXchange webinars on the topic presented by Robert Dickson and Ernie Ostic, but now my customers are getting to the end of the "thinking about it" phase. I guess I'm after customer stories and any go...
by ray.wurlod
Sun Feb 21, 2016 3:18 pm
Forum: General
Topic: XMETA database is down. shall I run the jobs?
Replies: 3
Views: 2248

Theoretically you should stop engine, services and repository in that order, and start them in the reverse of that order.

Practically all tiers are reasonably robust, and will re-establish connections. In version 11.x even the client tier is able to re-establish connection.
by ray.wurlod
Thu Feb 18, 2016 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage partitioning
Replies: 6
Views: 2896

Effective, yes, but moot. Partitioning spreads records over all the available nodes. In your case the number of available nodes is 1. It will still "work", though with all rows being processed on that node as specified by your configuration. The good news is that, if you have programmed th...
by ray.wurlod
Thu Feb 18, 2016 4:31 pm
Forum: General
Topic: Output of shell command in email notification
Replies: 4
Views: 1944

It remains true that the body can not be parameterized. However you can direct the output into a file (perhaps using tee command) and specify an attachment to the email. The pathname of the attachment CAN be parameterized.
by ray.wurlod
Thu Feb 18, 2016 4:26 pm
Forum: General
Topic: Automate Datastage Job cleanup
Replies: 2
Views: 1643

There is, but you will have to specify the deletion rules first. Under what circumstances may you delete jobs? What manner of version control is in use? Is it needed to archive old jobs before deletion?

The command you will need is istool delete which is used to delete DataStage assets.
by ray.wurlod
Thu Feb 18, 2016 4:21 pm
Forum: General
Topic: Trigger DataStage Sequence from Email
Replies: 5
Views: 2444

Do the jobs started from the sequence require the content of the email? In that case, in addition to all the advice given above, you will probably need some mechanism for extracting the email content. This is most easily accomplished using Java code.
by ray.wurlod
Thu Feb 18, 2016 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Code Integration - Basic question - New Learner
Replies: 4
Views: 3657

Welcome aboard. That's a rather unfair assignment for someone new to both technologies! The DataStage engine tier is the machine on which the DataStage projects exist. Jobs are started from this machine. Execution may occur on this machine and/or others, for example in a cluster or grid environment....
by ray.wurlod
Thu Feb 18, 2016 4:10 pm
Forum: IBM QualityStage
Topic: Investigate Reports
Replies: 12
Views: 10995

Which particular report did you try to create, of the templates that are provided? Did you actually run the report? To be honest, and without checking, I'm not sure that Investigation outputs are available through the reports mechanism. Look at the available report templates to verify this (certainl...
by ray.wurlod
Thu Feb 18, 2016 2:05 am
Forum: General
Topic: Stewardship Center
Replies: 3
Views: 1624

Stewardship Center

Is anyone yet using the Stewardship Center over Information Governance Catalog? Would you be prepared to share your experiences with me?
by ray.wurlod
Thu Feb 18, 2016 2:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetch XML CLOB data through Oracle Connector faster
Replies: 9
Views: 4507

Can you please explain how you get 7 partitions from three nodes? This may, of course, be confusion of terminology.