Search found 114 matches

by clshore
Mon Nov 10, 2003 1:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a DataStage Job using a high level programming Lang
Replies: 9
Views: 2134

Kim, I'd like to see it too; it's still at the client site, 2 years later, unused now I'm sure. It was a bit messy and problem specific, a 'throw-away'. We had boilerplate jobs that were created using metadata extracted from the DB dictionary; if and as the modellers changed schema (sometimes daily)...
by clshore
Mon Nov 10, 2003 1:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Full Outer Join
Replies: 2
Views: 1232

I have encountered situations in PX where I had to rename data elements downstream to avoid what appeared to be 'name collision' error messages like that. It's also possible that Runtime Column Propagation is contributing to the error, as I believe that this makes the namespace global to all stages ...
by clshore
Mon Nov 10, 2003 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage server version plus ?
Replies: 4
Views: 2161

FWIW, when I worked at CBIS (now Convergys), they DNS mapped the mainframe, so that we could view and manipulate MF files from our UNIX boxes and applications. We're talking 7x24 production instances, doing Usage/Rating/Billing processing of Call Detail Records for multi-million subscribers. Made ou...
by clshore
Mon Nov 10, 2003 1:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Format File
Replies: 10
Views: 3165

Click the file stage Properties, then Input/Format tabs, on the Properties panel, select 'Record level', then choose and add property 'Fill char', and assign 'space' as the value from the listbox.

Carter
by clshore
Mon Nov 10, 2003 11:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Format File
Replies: 10
Views: 3165

With Px target flat files, I believe that you will have to change the column types from Varchar to Char, and then perhaps also specify the fill character as 'space' (it may default, can't remember).

Carter
by clshore
Fri Nov 07, 2003 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating a DataStage Job using a high level programming Lang
Replies: 9
Views: 2134

I've done something like this for specific purpose with Perl, but as has been said, 'why?'.
by clshore
Wed Nov 05, 2003 11:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parallel job problem
Replies: 3
Views: 1226

You can view and build the 7.0 PX jobs on the Wintel platform, but not (yet) compile and run them there.
I think this is actually pretty neat, since I can do my work in standalone mode on my laptop when remote, then export/import them to the real target UNIX platform later.

Carter Shore
by clshore
Thu Oct 30, 2003 1:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML with DS 6/7 and Oracle 9i
Replies: 6
Views: 2358

XML with DS 6/7 and Oracle 9i

I'm developing jobs to manipulate sets of records where it is proposed that they will be delivered to me encapsulated in an XML document. I'm concerned that performance may be a problem. Any members willing to share experience/opinions? Running DS 7.0 Parallel, currently on a Sun ES15K, but will be ...
by clshore
Thu Oct 23, 2003 2:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Version 7 Experiences
Replies: 7
Views: 5569

'BASIC Transformer' problem

In 7.0 there is a 'BASIC Transformer' stage and a 'Transformer' stage, with the same icon. I ran into a problem with the BASIC Transformer stage on Px jobs (it was on my shortcut palette somehow). Jobs would compile OK, but fail at runtime. Support said the BASIC Xfm ought to have worked, albeit at ...