Search found 98 matches

by hobocamp
Sun Sep 30, 2018 10:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with calling REST API
Replies: 0
Views: 2108

Problem with calling REST API

I'm attempting to perform a simple GET for a REST api, in which I use a predetermined URL to return a series of reports, based on a date range. I'm able to successfully perform the action with both a web browser and Postman, but when running calling it with my DS job (utilizing a hierarchical stage)...
by hobocamp
Thu Jul 19, 2018 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WebService call with SSL authentication
Replies: 3
Views: 3147

Thanks for your reply Ernie.

As I still am trying to resolve this, is there any way that I could see the full post without it being hidden? I paid for a thirty day premium membership a week ago but so far still it still hasn't taken effect. :(
by hobocamp
Thu Jul 12, 2018 10:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WebService call with SSL authentication
Replies: 3
Views: 3147

WebService call with SSL authentication

This is hopefully a pretty basic question, but I've gotten some confusing information from IBM regarding it, so I wanted to seek advice here - I have a requirement to make a web service call (Soap), and using SSL authentication. I've used the WebService pack to make API calls before, but the SSL req...
by hobocamp
Thu Jun 07, 2018 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchical stage - single file output vs multiple files
Replies: 1
Views: 2859

Hierarchical stage - single file output vs multiple files

I ran into this problem previously three or four years ago, and can't recall how I resolved it. I'm using a hierarchical stage to create a pretty basic xml file (based on an imported xsd). I'm getting output of an multiple xml files (one per input row), instead of just one single file containing all...
by hobocamp
Thu May 31, 2018 1:45 pm
Forum: General
Topic: Schemas for flat files and datasets
Replies: 2
Views: 2986

Schemas for flat files and datasets

My searching for this hasn't turned up any results, but figured I'd put the question to the experts. Is there a method for performing a mass extract of the file and dataset schemas within a DS project? I know that for a particular instance, the columns could be saved as a table definition and then e...
by hobocamp
Mon Dec 12, 2016 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with binary data type in CFF stage
Replies: 1
Views: 2757

Solved the issue. I was splitting the file into two parts before processing (via a job that read the file as a whole string of data into two separate cff targets). Somehow in the splitting the binary data was getting mangled.

Marked as resolved.
by hobocamp
Mon Dec 12, 2016 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with binary data type in CFF stage
Replies: 1
Views: 2757

Problem with binary data type in CFF stage

Hello - This one has me perplexed so I'm hoping someone might have a suggestion. I have a number of ebcidic files I'm reading via CFF stage, and outputting to flat files. Going pretty smoothly, except I've hit a snag with one of the files whose definition is thus: 05 SPARMSGU-RECORD. 10 PART-NB PIC ...
by hobocamp
Wed Jul 20, 2016 7:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle read and write rates
Replies: 3
Views: 3577

Thanks Mike. Yep - your summary is exactly right. And I'd wondered if Waves might play into it. I'll keep that in mind for the future. In regards to my current problem, I was able to solve it within the transformer. I made the initial data selection with the Oracle stage (which as I mentioned can re...
by hobocamp
Wed Jul 20, 2016 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle read and write rates
Replies: 3
Views: 3577

Thanks Mike. Yep - your summary is exactly right. And I'd wondered if Waves might play into it. I'll keep that in mind for the future. In regards to my current problem, I was able to solve it within the transformer. I made the initial data selection with the Oracle stage (which as I mentioned can re...
by hobocamp
Tue Jul 19, 2016 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle read and write rates
Replies: 3
Views: 3577

Oracle read and write rates

Greetings - I've been in the forums all morning, and can't quite find a problem similar to the one I'm encountering. I have a simple job that uses an Oracle connector to read a table for a few employee details. It also calls an Oracle procedure to generate a user id, for any records that don't have ...
by hobocamp
Mon May 18, 2015 6:08 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Web Service Client stage returns empty xml file
Replies: 1
Views: 14372

Web Service Client stage returns empty xml file

This is a rather odd problem I believe. The output I'm getting from my webservice call is an empty xml file (containing only a single line feed). I'm getting this result with a couple of different web service calls. Job design is simple - WS Client ---> File (and for "File", I've tried bot...
by hobocamp
Fri May 08, 2015 1:47 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Parameter Sets with WS Client stage
Replies: 4
Views: 17028

Ray - My process was just a single simple job, designed as such: WS ClientStage ----> Sequential File Stage That makes me even more curious as to why the contents of the Value File weren't being recognized within the stage. (In Trace mode, the Soap body showed an empty value for the tag that should ...
by hobocamp
Thu May 07, 2015 5:37 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Parameter Sets with WS Client stage
Replies: 4
Views: 17028

It just seems like the Paremeter Set should work though. I only need to read it at the beginning of the job - just to pass it once, at the beginning of the job, to the web service. Before moving on I'll keep trying to see if I have something wrong. I can see the value in the file, and that it's set ...
by hobocamp
Thu May 07, 2015 2:56 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Parameter Sets with WS Client stage
Replies: 4
Views: 17028

Parameter Sets with WS Client stage

I have a process where I make a web service call to obtain an ID string value, which I then must use as one of the input tags in subsequent web service calls. I'm trying to accomplish this by using a Parameter Set, where I write the value to the "Value file" within the set. I can see that ...
by hobocamp
Wed Apr 22, 2015 10:03 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Web Service Client stage - issue with xpath definition
Replies: 9
Views: 23997

Thanks Ernie. Couple of questions just to clarify - -When you mentioned adding the 'working' payload to a derivation (inside a dummy transformer I'm assuming), do you mean the entire soa envelope content? I'm assuming yes. -Also, you mentioned the input and xml output stage. You also mentioned havin...