Search found 91 matches

by kab123
Mon Jun 04, 2007 2:53 pm
Forum: General
Topic: Call a Routine in a Parameter value
Replies: 11
Views: 4939

Call a Routine in a Parameter value

Hi,

Can we call a routine as a parameter value in job properties.
like, I would like to use previous month end date as a parameter.
I know if it is a UNIX server, we can use a shellscript. but we are using a NT server.
Can somebody give me some inputs..

Thanks
by kab123
Sun Apr 15, 2007 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: abnormal termination detected
Replies: 4
Views: 1401

when I kicked off the batch, the logs of the MI jobs got cleared.however from the unix log files, if i look at the three instance jobs logs each failed at different transformers. The following is the only info I could see from the logs. 1429\2007-04-14 23:04:11\2\PART1\1\Abnormal termination of stag...
by kab123
Fri Apr 13, 2007 3:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: abnormal termination detected
Replies: 4
Views: 1401

abnormal termination detected

I have been getting this error very frequently Error: Abnormal termination of stage JobName.xfm_Map.PART2 detected. This job is built to run on a multiple instance. Each time, we run the batch either of the instance is getting failed due to the above error. And when i re-ran the batch, it runs well....
by kab123
Tue Nov 07, 2006 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Retreiving results from server
Replies: 7
Views: 1757

you are trying to load a value which is out of its range.
ex: If target column's datatype is Decimal(2,2) and you send a value 20.300 you will get this problem. try to truncate the data and load 20.30 and see if that problem exists.
by kab123
Thu Dec 01, 2005 9:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent sequence number reset to 1
Replies: 5
Views: 1958

Can some body tell where these file SDK files get created...?
by kab123
Mon Nov 07, 2005 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Stage
Replies: 10
Views: 6916

Thank you all for ur suggestions..
From the opinions above, I feel that message handler is the best option to stick too..
by kab123
Fri Nov 04, 2005 12:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Stage
Replies: 10
Views: 6916

exactly..I supressed this message using message handler in dev ... but this message handler I dont think will get migrated as well with code to production and I dont even have access to add that rule...I dont want to confuse them about this warning..so I thought I would get some suggestions from the...
by kab123
Fri Nov 04, 2005 10:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Stage
Replies: 10
Views: 6916

I guess there are not many people using CDC stage... :(
by kab123
Thu Nov 03, 2005 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Stage
Replies: 10
Views: 6916

CDC Stage

Hi, I am trying to compare history file to current file using CDC stage... The jobs runs fine and could do CDC correctly..but i get some warnings on the other columns which are not keys..and change values Warning: "CDC: When checking operator: Defaulting "P_PHONE" in transfer from &qu...
by kab123
Thu Nov 03, 2005 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter Compilation Error
Replies: 8
Views: 2209

well..that saying is right but when things work weirdly,..we get different thoughts in our mind... :wink:
anyway, thanks ray..
by kab123
Tue Nov 01, 2005 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter Compilation Error
Replies: 8
Views: 2209

Thanks ray..

It did work when we compile using Multi-job complier but didnt work for individual sequence compilation...
previously, It worked viceversa..looks strange..
but your opinion sounds right...unless there is some configuration or someother appln problem...what is ur comment on this..?
by kab123
Tue Nov 01, 2005 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Parameter Compilation Error
Replies: 8
Views: 2209

Job Parameter Compilation Error

Hi, "Activity abc: trigger Expression CareteTarget - Variable 'paramname' not defined" We are getting this error sometimes when we try to complie the sequence job individually and sometimes when we do multi-job compilation. and we checked the parameter is defined in Job Properties and the ...
by kab123
Thu Jun 30, 2005 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge Stage
Replies: 4
Views: 1293

It didnt work with '00' too..
it didn't let 3 characters..
any clue..
by kab123
Thu Jun 30, 2005 10:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem
Replies: 3
Views: 1173

No I dont have any such stage..
by kab123
Thu Jun 30, 2005 10:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem
Replies: 3
Views: 1173

Controller Problem

Hi , When a job failed due to some reason..and when the sequencer is re-launched again next time, I get this error... seqXXX..JobControl (@seqXXYY): Controller problem: Error calling DSRunJob(seqXXYY), code=-14 [Timed out while waiting for an event] It runs fine only If I compile that specific job a...