Search found 42189 matches

by chulett
Thu May 07, 2009 2:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import routine from dsx file
Replies: 16
Views: 8734

I've seen the same behaviour on a 7.5.1A server where it would sometimes just refuse to import routines if that was all that was in the export file. I don't remember if there was a resolution or not, I think what I ended up having to do was include at least one job in the mix. It definitely smelled ...
by chulett
Thu May 07, 2009 1:30 pm
Forum: General
Topic: Client licensing clarification
Replies: 5
Views: 1487

Client licensing clarification

Specifically wondering how exactly it works when multiple auth codes are out in the wild with different concurrent user limits. What I was asked (that I didn't know the answer) was this - is the client's concurrent limit checked against the group of people connected with the same serial number only ...
by chulett
Thu May 07, 2009 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare files taken from FTP
Replies: 5
Views: 1893

At the file level? Not directly, no. This is where you would leverage your operating system, something easily incorporated into a DataStage job stream using a Sequence job, however.
by chulett
Thu May 07, 2009 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pb using Isnull function : doesn't work
Replies: 9
Views: 2403

Apparently, yes, if your assertions regarding the data source and all else being the same are indeed correct. No clue why but that's where I'd start.
by chulett
Thu May 07, 2009 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pb using Isnull function : doesn't work
Replies: 9
Views: 2403

These two projects... they are on two separate servers I would wager, yes? Something is different between the two, problem is going to be tracking it down. O/S patches? Environment variable settings? :?
by chulett
Thu May 07, 2009 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare files taken from FTP
Replies: 5
Views: 1893

Right, whomever gave you that requirement should also be able to tell you how you would calculate that 'checksum' value in your organization. Hopefully some sort of command line utility, easily scripted.
by chulett
Thu May 07, 2009 6:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't able to start the server
Replies: 13
Views: 17972

As noted by Ray - rather than giving up hope, banging head against wall and waiting for those occasions that we post, do involve your official support provider - after all, you're paying them to support you.
by chulett
Thu May 07, 2009 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pb using Isnull function : doesn't work
Replies: 9
Views: 2403

You can't. You can, however, upload them to any of the many free file hosting sites and then link to them in your post using the [img] or "image" tags.
by chulett
Thu May 07, 2009 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TIMESTAMP CONVERSION
Replies: 8
Views: 2709

ICONV(TRIM(INPUT_COLUMN[1,6]),"D4YMD[4,2,2]") is one problem. Now you are pulling 6 but telling IConv it is 8 all together. And Kryt0n already pointed out your delimiter issue. Try this instead:

ICONV(INPUT_COLUMN[1,6],"DYMD[2,2,2]")
by chulett
Thu May 07, 2009 6:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Download ZIP file from FTP server
Replies: 1
Views: 900

If you mean by using the FTP stage then no, stick with command line ftp for that.
by chulett
Wed May 06, 2009 11:36 pm
Forum: General
Topic: Getting part of a filename
Replies: 16
Views: 7262

Inconceivable! Think? "You keep using that word. I do not think it means what you think it means." :wink:
by chulett
Wed May 06, 2009 11:13 pm
Forum: General
Topic: Getting part of a filename
Replies: 16
Views: 7262

8) Except the numbers aren't what they need from the filename.
by chulett
Wed May 06, 2009 11:11 pm
Forum: General
Topic: Loop Iteration Number in Sequencer
Replies: 9
Views: 2183

Oh... err... <twitch> I thought there was a way to reference just the value of the counter itself. Guess that must be another false memory implanted by my therapist. [sigh]
by chulett
Wed May 06, 2009 10:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row comparison in parallel
Replies: 3
Views: 1311

I'm assuming the output should actually end up as:

a xyzpgryrd

Yes?
by chulett
Wed May 06, 2009 10:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Very slow job stat display in director / crashing
Replies: 3
Views: 1632

Which exact 8.x version are you running? 8.1 defaults to storing the job logs in the XMETA database from what I recall, but there's a "logging" ini parameter you can change to switch it back to the "Universe" repository. Don't recall the exact name, though. That should help. For ...