Search found 42189 matches

by chulett
Thu Aug 25, 2005 9:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control life cycle
Replies: 7
Views: 1865

I have promoted entire populations of jobs from VC into Test or Production when doing the initial loads. Just meant I don't always just do singletons or small groups.
by chulett
Thu Aug 25, 2005 9:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control life cycle
Replies: 7
Views: 1865

Yuck. Suggest you call Ascential support and report that as a bug - as long as your version is 7.5.something.
by chulett
Thu Aug 25, 2005 8:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control life cycle
Replies: 7
Views: 1865

Going through this myself right now. Deletes are a PITA in Version Control. When jobs get renamed you end up with old and new names in VC and no good way to deal as it never really deletes anything. HOWEVER, I was under the impression you could: a) Allow logical 'deletes' to happen via the 'Allow Co...
by chulett
Thu Aug 25, 2005 8:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with sequencer. It freezes my computer
Replies: 5
Views: 1841

Have you tried install the SP2 related patch on Ascential's eSupport site?
by chulett
Thu Aug 25, 2005 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Started but Nothing is Done!
Replies: 8
Views: 1840

Welcome aboard. Unfortunately, I've seen the same behaviour in the past in v6, opened a case with Ascential and never got a resolution. Biggest impediment being the fact that the problem is not reproducible. If it is like what I saw (from memory) the Status view made it look like the job never ran. ...
by chulett
Thu Aug 25, 2005 12:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot Copy Stage from One Job to other
Replies: 6
Views: 1229

Try reinstalling the client software.
by chulett
Wed Aug 24, 2005 6:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Wrong Routine value returned
Replies: 9
Views: 1625

Hmmm... document design before coding... have to write that one down. :wink:
by chulett
Wed Aug 24, 2005 6:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036: illegal variable name/number
Replies: 13
Views: 7693

No, this just confuses things more. :? Which one of the two values 'when changed to 100 got rid of the error'?

Ray said Array Size > Transaction Size. That wasn't your problem, as best as I can tell.
by chulett
Wed Aug 24, 2005 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: installing two different version of DS client
Replies: 9
Views: 1919

Of course, that's the part that 'takes some time'. Just wanted to point out that - if you have the standard shortcuts on your desktop - it will automagically switch the properties of those for you to point to the currently active client version.

Something cool I didn't realise it did at first. 8)
by chulett
Wed Aug 24, 2005 3:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User-Defined SQL behaves differently in 7.5.1A
Replies: 16
Views: 3702

Just wanted to followup on this as the possibility of this being a problem has been haunting me... I have 7.5.1A installed on an HP/UX test server right now, putting things through their paces. I can find no problems when using heavily commented User Defined SQL in our weapon of choice - the OCI sta...
by chulett
Wed Aug 24, 2005 2:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: installing two different version of DS client
Replies: 9
Views: 1919

Exactly. :wink:

Install the client to two different directories but suggest you keep only one set of icons on the desktop. The MCM will switch those icons back and forth between the two versions as only one can be 'active' at any given time.
by chulett
Wed Aug 24, 2005 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Library
Replies: 8
Views: 1986

Have you been using Oracle stages up to this point and are now using a new stage (like OracBulk) or have you yet to get any Oracle stages working? On a UNIX server, it is configured in the dsenv file. There should be a Plug-In Configuration Guide which should walk you through the changes needed. Bas...
by chulett
Tue Aug 23, 2005 3:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job sequence
Replies: 4
Views: 910

Sounds like the dreaded Windows XP Service Pack 2 related problem. There is a patch available on Ascential's eSupport website, download and install it and it should fix you right up.
by chulett
Tue Aug 23, 2005 1:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to manually set the jobstatus of a job
Replies: 6
Views: 1248

Re: How to manually set the jobstatus of a job

I need to manually set the Jobstatus of the current job to aborted You can't manually set it, so put that approach out of your head. What you can do is build a routine to read the file which you can execute via the Routine Activity stage between the two jobs. Abort the routine (ie, call DSLogFatal)...
by chulett
Tue Aug 23, 2005 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to read from a hash file...
Replies: 13
Views: 3881

Does this mean that the hash file has null values in it? if so, what would be my next step in the process to debug the issue... No, it means the fields returned by the lookup will be null - not the data in the hashed file itself. So, yes, time to dig in and start debugging why the lookup is failing...