Search found 3835 matches

by eostic
Fri Aug 06, 2021 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchical Stage - load file to API with REST
Replies: 1
Views: 30715

Re: Hierarchical Stage - load file to API with REST

It's been awhile, but one of the trace modes provides extremely deep detail. As I recall, the message in the log tells you where to find a very extensive and deeper log that has the full payload. ...but I don't have access anymore to recall the exact trace value needed.

Ernie
by eostic
Fri Aug 06, 2021 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Edit XML Table Definitions
Replies: 1
Views: 10036

Re: Edit XML Table Definitions

Not sure......I assume you are using the old XMLInput Stage? You are probably better off just putting in the xpath yourself. The old importer was never that good with xsd's anyway...it was far better to use it with actual snippets of xml that you cared about....and keep in mind that you don't need t...
by eostic
Fri Aug 06, 2021 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue in XML Hierarchical stage
Replies: 3
Views: 13136

Re: Issue in XML Hierarchical stage

Sorry for the late reply. I remember setting up Assemblies where I would force validation, and then be able to send the entire incoming payload (the whole row of xml content) to a separate reject link --- and if not, it would go to second instance of the Hierarchical Stage to be processes. It wouldn...
by eostic
Sun Aug 23, 2020 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic job to convert ebcdic files to ascii.
Replies: 3
Views: 13215

The main problem you will run into, is when the definition of "EBCDIC file" conflicts with what is really in the data set. Unfortunately, many times you might be given what someone calls an "EBCDIC" file, only to find that it is really a "complete binary" file from the ...
by eostic
Sun Aug 23, 2020 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic job to convert ebcdic files to ascii.
Replies: 3
Views: 13215

The main problem you will run into, is when the definition of "EBCDIC file" conflicts with what is really in the data set. Unfortunately, many times you might be given what someone calls an "EBCDIC" file, only to find that it is really a "complete binary" file from the ...
by eostic
Tue May 19, 2020 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Connector - Sending vs JMSType
Replies: 3
Views: 13092

Well....that depends. That Connector was written with a whole lot of powerful features, assuming that they are all still supported. Have you been thru and experimented with all the formal DataStage Data Elements that it supports, such as MSMQ.REPLYTOQ ? (there are a lot of others with the MSMQ prefi...
by eostic
Mon May 18, 2020 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Connector - Sending vs JMSType
Replies: 3
Views: 13092

Been awhile' but the MQ Connector and the Stage before it had nice support for Data Elements.....and if set, would force interaction with the actual MQ Header. JMS Type doesnt ring a bell, but search the doc and resources around data elements.....

Ernie
by eostic
Mon May 11, 2020 9:14 am
Forum: IBM QualityStage
Topic: need Impact Analysis data stage jobs if the DB name changed
Replies: 5
Views: 14263

Review both of our answers above very carefully. What I believe qt_ky is referring to is the abstraction that is naturally available with most connectivity solutions.....whereby if DataStage connects to Database01, but now it is Database01A, the underlying connectivity solution can still provide Dat...
by eostic
Mon May 11, 2020 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Local MQ Manager vs Remote MQ Manager - guaranteed Delivery
Replies: 1
Views: 10641

It has been a very loooooonnnnnggggg time since I have had a chance to work with the various MQ APIs, but as I recall (at that time), ensured delivery required that you were co-resident with the queue manager so that you could establish a a connection that supported the required level of commit. Was...
by eostic
Thu May 07, 2020 6:22 am
Forum: IBM QualityStage
Topic: need Impact Analysis data stage jobs if the DB name changed
Replies: 5
Views: 14263

Hi Rucha. That's a wide open question, primarily because there are so many different ways that you might specify a "database" in DataStage/QualityStage. How does the team indicate their names in the Jobs? Are they hard coded strings? Do you use Job Parameters? Are they consistent across yo...
by eostic
Thu Mar 26, 2020 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Expose DataStage job a service - JSON Format
Replies: 3
Views: 8258

The JSON payload format is fixed --- meaning not very adjustable...and is a convenience of doing the binding. The simplest thing to do is to have your developers who are receiving the payload use what they are getting and adjust things on their side after they receive it. The reason the "result...
by eostic
Tue Feb 18, 2020 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using the Hierarchical Stage for a series of REST calls
Replies: 1
Views: 4107

Are you trying to make a single call, three times? (once for each incoming row)...or make three different kinds of calls within the Stage? It might be in the way you are defining the "input" into the Assembly. It should be invoking the call for "each" row that comes through. Ernie
by eostic
Tue Feb 18, 2020 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchical stage - XML parsing
Replies: 2
Views: 5054

Simpler solution --- work on dumping the entire response as a single "chunked" text column (like "myXMLresponse")... send it to a sequential file with NONE for delimiter and for quote character and make sure it looks "clean" (just like you have it up above). Then pass i...
by eostic
Wed Dec 04, 2019 9:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How Datastage handle streaming events (MQ / Kafka messages)
Replies: 1
Views: 4172

It's been a really long time (probably pre-11.3, but this is a feature that I would expect to be quite stable) since I played with these settings (and I've forgotten their exact names, but it's the "apt transport block size" named value. The default behavior is really small. I recall doing...
by eostic
Tue Aug 13, 2019 4:51 am
Forum: General
Topic: Thank you everyone!
Replies: 6
Views: 6739

I won't be able to stay away... ; ) DataStage is a part of me (and its related topics).....

Ernie