Search found 2288 matches

by roy
Thu Jan 12, 2017 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output converts " to &quote;
Replies: 4
Views: 5114

Thanks for the replies guys!

Eventually I ended up using the new(er) XML stage which got me to the desired non escaped context and with no line breaks between tags and data.
by roy
Tue Dec 13, 2016 5:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output converts " to &quote;
Replies: 4
Views: 5114

XML Output converts " to &quote;

Hi All, I'm extracting a string from Oracle to a XML output stage using UTF-8 A string of abc"d is being translated to abc&quote;d in the output file. viewing this output via a browser shows the data as abc"d but a validation process is expecting the original string and fails validatio...
by roy
Thu Sep 08, 2016 8:52 am
Forum: General
Topic: dssetparm apt_config_file
Replies: 18
Views: 11445

Am I missing something?
The error implied that you are trying to set a job parameter that doesn't exists in the attached job.
so do you have that parameter as an actual parameter in the job you want to run?
by roy
Thu Sep 08, 2016 8:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter Set Import
Replies: 7
Views: 7553

can this be a permitions issue of your user and the folders in which the project is set up on?
by roy
Thu Sep 08, 2016 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Lookup Stage (Range)
Replies: 2
Views: 3048

Hi,
Try reediting this range lookup; perhaps the entire build the entire stage a new.

The fact that it is red suggest that something is wrong!
by roy
Thu Sep 08, 2016 8:20 am
Forum: General
Topic: Pass encrypted variable to job
Replies: 10
Views: 6228

Hi,
Can you use parameter set files?
they can be set with limited access and can be updated as needs be
would that work for you?
by roy
Sun Aug 28, 2016 6:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle to MySQL Community edition SQL error
Replies: 4
Views: 8877

Hi,
if you try to auto-generate the sql statement what happens?
by roy
Thu Aug 04, 2016 2:09 am
Forum: General
Topic: Fallen Premium Poster: Kim Duke
Replies: 32
Views: 26006

:shock: I was away for alittle while, so just seen this :cry: I was fortunate enough to have met Kim, a few years ago. I was in Dallas for a few days and Kim took me out to a nice dinner and showed me the Xmas decorations that were just put out. Many of us benefitted he's shared wisdom. A real loss ...
by roy
Mon May 02, 2016 11:28 am
Forum: General
Topic: Parallel job runs, but fails from sequence job
Replies: 5
Views: 4057

Hi, I assume you run the parallel job from the designer and running with no limit to warnings when you run it from a sequence it probably hit the default 50 warnings limit Please check and confirm if this is the case P.S. I'll edit the post topic, since the current one is not describing the issue. I...
by roy
Mon Jan 18, 2016 9:41 am
Forum: General
Topic: Recursive lookup
Replies: 1
Views: 2136

Recursive lookup

Hi Guys,
Anyone has a lookup routine hanging around?
can use bot server or parallel version for now.

Just thought it might save me some time.

Thanks.
by roy
Wed Dec 30, 2015 6:43 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Column analysis - aborted job
Replies: 6
Views: 7991

yes Robert, this is caused when trying to analyse a string like "123456E3456789" having this format causes the infered data type to be decimal but the number of the characters after the 'E' is to long for a smallint E is being translated as an exponent if we analyse "1234A234323452E45...
by roy
Tue Dec 29, 2015 11:16 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Column analysis - aborted job
Replies: 6
Views: 7991

I suspect either a bug or misuse of the product.
No definition of any kind was set except a string of 255 characters to all columns; the idea is that IA will suggest the type.

Specific analysis for that column only with 50K sample on random with 100% was successful :shock:
by roy
Tue Dec 29, 2015 11:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to import data files in parallel
Replies: 5
Views: 3974

Have you thought of taking a sample file for the import table definition?

something like:

Code: Select all

head -1000 source_file.txt > source_sample.txt
IHTH (I Hope This Helps),
by roy
Tue Dec 29, 2015 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: character range lookup in lookupstage
Replies: 8
Views: 5028

good to hear in V.11 it works
I also had to get the records not in the range lookup for another flow
so processed so many records twice
So There is the "wrok around" that I implemented
by roy
Tue Dec 29, 2015 9:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: character range lookup in lookupstage
Replies: 8
Views: 5028

I had a similar issue with 8.7 where range lookup faild to work I had a single column with ID + a ranged timestamp column that didn't work as expected. Due to short time to resolve I ended up checking the TimestampToDecimal() values in a transformer. The down side is that is made multiple of the row...