Search found 3835 matches

by eostic
Fri Sep 03, 2010 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: while reading from MQ need to remove header
Replies: 2
Views: 1502

What problems are you having right now? You normally won't get any header information in your way if its a standard MQ message ...just have a single message for your payload on your output link........if it (the message) was placed there by JMS, then it will have RFH2 details in it......I haven't lo...
by eostic
Thu Sep 02, 2010 7:52 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to Merge Changed Metadata
Replies: 1
Views: 1112

What bridge/connector/broker/tooling are you using for your imports?

Ernie
by eostic
Thu Sep 02, 2010 7:56 am
Forum: General
Topic: Javadocs For JAR files provided in Datastage 8.0
Replies: 1
Views: 1295

What are you trying to gain access to? There aren't any published api's for accessing the repository, but there are many ways to garner metadata...depends on what you need....

Ernie
by eostic
Wed Sep 01, 2010 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How much big xml file a XML input stage can process
Replies: 4
Views: 1664

Chances are you will run into issues. I have done "some" documents of that size, but as noted earlier, it depends on the number and size of the elements, etc. If you happen to be on Windows, check out a tool called XMLMax ....it has options for breaking apart xml into smaller pieces. I've ...
by eostic
Wed Sep 01, 2010 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How much big xml file a XML input stage can process
Replies: 4
Views: 1664

Do some searches..this subject has come up often.....you should be fine in the under 200Meg range...there may be some APT_ variables that you will need to set, but that depends more on your approach to reading the xml from disk or message queue. If you hit such a limit, there are tools and technique...
by eostic
Tue Aug 31, 2010 12:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml writer
Replies: 3
Views: 1728

Both are equivalent. If the tooling receiving this does not allow </outlet> then they are not supporting industry standard XML. You can get rid of it if you need, by passing the final string to a transformer stage....put an output link on your xml with one big column (such as "myxmloutput"...
by eostic
Tue Aug 31, 2010 10:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml writer
Replies: 3
Views: 1728

The doc is pretty good, but in brief, put an XMLOutput Stage on your canvas....it has lots of options for how and where you want to send the xml. Your xml snippet below doesn't exactly look correct, but it's close...... what you need is the following xpath expressions (or close to these) in the Desc...
by eostic
Sun Aug 29, 2010 7:33 am
Forum:
Topic: Table Definitions vs Database Tables
Replies: 3
Views: 1499

In the current release, deleting and re-importing is the best way to go.

Ernie
by eostic
Sun Aug 29, 2010 7:31 am
Forum:
Topic: Shared Tables in MW
Replies: 9
Views: 4416

Ultimately, what's your goal? Most of this is simply historical. DataStage tabledefs came along many releases prior to Shared Tables. The "link" between DataStage tables and Shared tables is one of convenience. If you break it by updating the table, so what? About the only purpose that Sha...
by eostic
Fri Aug 27, 2010 7:19 am
Forum:
Topic: Table Definitions vs Database Tables
Replies: 3
Views: 1499

by eostic
Fri Aug 27, 2010 7:17 am
Forum:
Topic: Shared Tables in MW
Replies: 9
Views: 4416

I meant to say above "then pulling those tables into DS after initially importing them via IA or FastTrack makes sense"..... ....in the end, it depends largely on your flow. What I try to do is avoid duplication.......so if the table is already there, generally no need to import it "a...
by eostic
Fri Aug 27, 2010 7:15 am
Forum:
Topic: Shared Tables in MW
Replies: 9
Views: 4416

I depends a lot on the tooling that you are using. If you start with FastTrack or Information Analyzer, then pulling those tables into DS makes sense....but if DS is the "starting point" then what you are doing is fine. MWB on its own cannot import tables...it just refleclts what it sees. ...
by eostic
Thu Aug 26, 2010 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML node aggregation
Replies: 6
Views: 2707

It looks like it's more complex than that... I might have read it too quick......certainly the key is an issue, and it should probably be on that lowest level empno column.... However, there is more that you need to do. You probably will need a containment element around your empno details. In your ...
by eostic
Thu Aug 26, 2010 1:41 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Creating Webservice (WISD Job) with Array Input
Replies: 1
Views: 2625

Your Java developer will have to know how to use Axis (or other equivalent SOAP engine) to generate arrays for SOAP input, and/or to process an array that is returned. This is a more advanced concept in SOAP client development, althogh most IDE's handle it just fine these days. In the meantime, for ...
by eostic
Wed Aug 25, 2010 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Expose Job sequence as web service
Replies: 2
Views: 1934

write a simple server job that uses DSUtilityRunJob (see the sdk routines) in a transformer. to kick off the Sequence Job....and publish that simple job as a service.