Search found 42189 matches

by chulett
Thu Jun 29, 2006 2:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

Definitely server related as the client doesn't matter. And yes, all projects are 'out of bounds' as none on this particular server can be connected to. My production server is still fine, so whatever changed changed just on the dev/test server. No, no roaming home. I agree, it does seem like a perm...
by chulett
Thu Jun 29, 2006 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To check the output file rowcount
Replies: 10
Views: 2409

Search for DSGetLinkInfo as a starting point.
by chulett
Thu Jun 29, 2006 12:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

Connection Error

Been through the forum but can't seem to find anything that fixes the problem that has suddenly cropped up today. And before anyone asks, no I have no idea what may have changed, as there is nothing pertinent to this that either I am aware of or should have changed. Some users can connect just fine,...
by chulett
Thu Jun 29, 2006 9:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Memory setting Datastage
Replies: 8
Views: 3035

A made up acronym for Non Premium.
by chulett
Thu Jun 29, 2006 7:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to configure Data Stage 7.5.1 A for Veritas Cluster(VCS)
Replies: 5
Views: 1617

I was involved with setting up DataStage 6.x on a Tru64 Cluster with EMS storage 'back in the day'. We installed the software on all nodes but only ran it on one at any given time. Clustering scripts were written so it knew how to check for failure, fail the software over from node to node, start / ...
by chulett
Thu Jun 29, 2006 7:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date conversion
Replies: 10
Views: 2929

Yerk... hope nobody is sending dates as ambiuous as that. I've seen ones where the month may not include a leading zero but the day would always, so the answer in that case would be 2005-01-11.

But it does complicate things... for no good reason...
by chulett
Thu Jun 29, 2006 7:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Memory setting Datastage
Replies: 8
Views: 3035

ray.wurlod wrote: :idea: In general, the default values will be appropriate. :idea:

Forgive me, but I thought it best to pull this out for the NP folks in the audience...
by chulett
Thu Jun 29, 2006 7:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date conversion
Replies: 10
Views: 2929

What "3-4 formats of DATE" do you speak? You've only shown one.

If you really need to handle that, a custom routine is in order. One that attempts to detect the incoming format and handles it accordingly, whatever that may mean.

Please post what you've tried so far.
by chulett
Thu Jun 29, 2006 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to read data from a flat file
Replies: 2
Views: 981

The Sequential File stage. Usually.
by chulett
Thu Jun 29, 2006 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between Control job and Sequencer....
Replies: 10
Views: 4916

Ah yes, that too. To misquote an old Genesis song 'The Apostrophe Police Never Sleeps'. :lol:
by chulett
Thu Jun 29, 2006 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SELECTING ROWS FROM A FILE
Replies: 10
Views: 1608

Or... well, never mind. That's about enough different ways for one day.
by chulett
Thu Jun 29, 2006 7:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: specifying path for xml output column
Replies: 3
Views: 1079

Ok... what the heck *is* your derivation for that field? How are you determining if it should be 'True' or 'False'? At its most basic, I'm suggesting something like:

Code: Select all

If (something is true) Then 'True' Else 'False'

As the proper derivation.
by chulett
Thu Jun 29, 2006 6:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot run uv to unlock jobs
Replies: 5
Views: 1916

Or that.
by chulett
Thu Jun 29, 2006 6:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: specifying path for xml output column
Replies: 3
Views: 1079

You mean XPath not simply path... it was a little confusing at first. And your output while wrong is technically correct - 1 = true, 0 = false.

You need to correct your 'DSLink100.PublishFlag' derivation to translate it into words, it would seem.

Oh, and nice link name. :wink:
by chulett
Thu Jun 29, 2006 6:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot run uv to unlock jobs
Replies: 5
Views: 1916

What happens when you try 'uvsh' rather than 'uv'?