Search found 42189 matches

by chulett
Wed Nov 28, 2007 8:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in merging files at Sort stage
Replies: 4
Views: 3207

How many records are you sorting? How long was 'long time'? The Server Sort stage is not meant for large volumes, leverage your O/S sort instead.
by chulett
Wed Nov 28, 2007 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems running a routine to compile a single job
Replies: 15
Views: 4984

This was actually 'pinched' from Kenneth Bland's KBA Job Control Utilities, comments and all. It even still includes the structures it needs to process an array of job names at a time or that are part of his job control. Looks to me like you've got your CompileStatus values bass-ackwards. Zero would...
by chulett
Wed Nov 28, 2007 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems running a routine to compile a single job
Replies: 15
Views: 4984

Re: Problems running a routine to compile a single job

(Sorry if the code is not indented, indents seem to have been stripped out in the posting process) That's what the Code tags are for. ********** Begin ****************** ******************************************************************************** ** This routine tries to compile the job specifi...
by chulett
Wed Nov 28, 2007 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Weird Behaviour of dsjob -lparams
Replies: 9
Views: 2728

I executed the command in the usual manner, ie. dsjob -lparams projname job1 But the result of this command yields a set of parameters which are not used in the job 'job1'. Rather it yields a set of parameters from some other job 'job2'. This makes absolutely zero sense. Status of the job makes no ...
by chulett
Wed Nov 28, 2007 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: stop sequence issue
Replies: 1
Views: 672

You don't really have a 'stop a Sequence' problem, that you do by clicking on the Stop button as you've already tried. You've got a much more specific problem - how to stop a hung batch file, something the Sequence itself can't easily stop. I would suggest you find the process of the batch file itse...
by chulett
Tue Nov 27, 2007 9:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 'Improper Data Type ' Error in Server Routine
Replies: 5
Views: 2294

Re: Sample code

Your sample code when wrapped in 'code' tags: Sample code ***Initialization section Ans="" v_cents_yen="" v_cents="" v_cycledate = CYCLE_DT **If CRNCY OR QUOTED_CRNCY IS IN MINOR CURNCY SET FLAG =2 IF (FLAG = 2) THEN v_yen=Index(UpCase(FUT_QTE_UNITS)...
by chulett
Tue Nov 27, 2007 12:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compiling all jobs
Replies: 10
Views: 2689

Careful - that's a trick question! :P
by chulett
Tue Nov 27, 2007 10:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compiling all jobs
Replies: 10
Views: 2689

From the Tools menu of the Manager. It's... slow.
by chulett
Tue Nov 27, 2007 9:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort communication in Sequence calling Sequence
Replies: 9
Views: 3117

You have to propogate the error 'upwards', cause the main Sequence to abort when there's trouble with a sub-sequence. Look into the 'Utility' routines to write log messages, including fatal ones.
by chulett
Tue Nov 27, 2007 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Info vs Warning events in DS 7.5 and 7.5.2
Replies: 3
Views: 1148

You need to wrap your 'ASCII art' in [code] tags and make liberal use of the Preview option to check your work. They will preserve your spaces. Actually, that is a bug fix and it is now working properly under 7.5.2. I hated the fact that under earlier versions, large bulk loads could throw jillions ...
by chulett
Tue Nov 27, 2007 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Weird Behaviour of dsjob -lparams
Replies: 9
Views: 2728

:? Can you explain what 'different set' or 'wrong set' of parameters means? What exactly was different or wrong about them? What was different about the Sequence when it gave these results - was it in an Aborted/Restartable status, for example?
by chulett
Tue Nov 27, 2007 7:38 am
Forum: General
Topic: dsrecords command error
Replies: 6
Views: 10290

Re: dsrecords command error

can you check in unix this command .......wc file name. you can get total number of records. that will not give the records. It will give the word count i believe Actually, it will. While "wc" does mean "word count", without a specific modifier it will return all counts: bytes, words and lines wher...
by chulett
Mon Nov 26, 2007 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Parameters override
Replies: 11
Views: 2384

Not sure how many times or different ways you want me to say it. The child's job parameters will always be in effect unless you specifically pass (or 'override' if you prefer) them in the Sequence job. To be pedantic, that means on the Job tab of Job Activity stage, putting the Sequence job's parame...
by chulett
Mon Nov 26, 2007 7:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Parameters override
Replies: 11
Views: 2384

No, not automagically. Simply having 'the same parameters' defined in both doesn't mean squat - they must be passed from parent to child to 'override' the default values in the child.
by chulett
Mon Nov 26, 2007 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: project location
Replies: 5
Views: 2080

rohitchattar wrote:for one projects i want to create the location in different machine itself.is it possible??

ray.wurlod wrote:Yes.

Yes? Different machine? :?