Search found 4605 matches

by kduke
Fri Oct 29, 2004 11:24 am
Forum: Site/Forum
Topic: Question to Ascential Management
Replies: 12
Views: 8449

I think they should answer here. If not then whats the point. They use this site as way to promote their product. Ascential make a commitment to DSX. Make us a true part of the team. Bring back TJ too.

Do the right thing. I know you read this stuff.
by kduke
Fri Oct 29, 2004 6:44 am
Forum: Site/Forum
Topic: Question to Ascential Management
Replies: 12
Views: 8449

Another question, if we are on the same team then why can't Ascential employees answer questions on this forum?
by kduke
Thu Oct 28, 2004 3:16 pm
Forum: Site/Forum
Topic: Question to Ascential Management
Replies: 12
Views: 8449

Question to Ascential Management

Recently at Ascential World there was a speaker from Harley Davidson. The ex-CEO explained how they created such brand loyalty and turned their company around. He stated the key was treating even their suppliers as part of their team. They wanted everyone on this team to be successful. He also expla...
by kduke
Thu Oct 28, 2004 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

* ------------------------------------------------------------ * SetJobParameters(Arg1, Arg2, Arg3) * Decription: Set parameters * Written by: * Notes: * Bag of Tricks Version 2.3.0 Release Date 2001-10-01 * Arg1 = Parameter List ( <1> = parameter names, <2> = parameter values) * Ar...
by kduke
Thu Oct 28, 2004 2:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

* ------------------------------------------------------------ * GetParameterArray(Arg1) * Decription: Get parameters * Written by: * Notes: * Bag of Tricks Version 2.3.0 Release Date 2001-10-01 * Arg1 = Path and Name of Parameter File * * Result = ( <1> = Parameter names, <2> = Paramet...
by kduke
Thu Oct 28, 2004 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

* ------------------------------------------------------------ * UICISetJobParamsFromFile(ParamFile, SkipParams, Debug) * Decription: Set parameters from a file * Written by: Kim Duke * Notes: * ------------------------------------------------------------ $INCLUDE DSINCLUDE JOBCONTROL.H $IN...
by kduke
Thu Oct 28, 2004 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

Okay: * ----------------------------------------------------------------- * UICISetParamsFromFile(ParamFile,FromParams,ToParams,Debug) * Decription: Set parameters in a running sequence. * Written by: Peter Lai * Notes: * ----------------------------------------------------------------- $INC...
by kduke
Thu Oct 28, 2004 12:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORACLE9i issue
Replies: 19
Views: 6167

There is some overhead for multiple instance jobs especially in the log files and status. So it does hurt performance. Some jobs will not run in a multiple instance. If you have a job which clears a hash file then a second job will erase some or all of the first jobs results depending on if it runs ...
by kduke
Thu Oct 28, 2004 12:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automatically handle activities that fail
Replies: 11
Views: 9494

I think the same issue is in effect. A routine needs to return a 0 for "OK". The way a sequence works is very powerful you can tell it to ignore the result of this routine by doing an otherwise. You can also tell it to not make this step restartable which means it will not care if this step fails. V...
by kduke
Wed Oct 27, 2004 9:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File update based on field list
Replies: 4
Views: 1146

I think what I would do is create a new link and output the fields you want. It sounds like this is more for debugging than a perm solution. This way your original link still has all the columns it needs.
by kduke
Tue Oct 26, 2004 4:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file in account/directory path
Replies: 4
Views: 1400

JB is correct. You can move files around because the VOC in the account is not updated. You can still move them if you know Universe but you may have to switch to a file path. Having a VOC entry allows you to LIST or SQL SELECT against your hash file file. It is also easier to run HASH.HELP or ANALY...
by kduke
Tue Oct 26, 2004 4:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Sequencer process
Replies: 3
Views: 603

This also works in Ds7.1 but no earlier releases.
by kduke
Tue Oct 26, 2004 4:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JobReport fails
Replies: 5
Views: 799

Be careful there is DSJobReport.dsx and JobReport.dsx which are something different. This is also JobReport.dsx. There are 2 versions. My stuff works witht the first post. It probably works with the second version. I have not tried it yet. You get source code to most of my stuff so you can modify it...
by kduke
Tue Oct 26, 2004 4:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JobReport fails
Replies: 5
Views: 799

JobReport creates a really nice html document for a job. You can download it on ADN at m. I wrote a wrapper for it which will build an All_Index.html which has a link to each job osrted by job and another sorted by category. I also wrote a similar html document for each routine. Download KgdGenHtml....
by kduke
Mon Oct 25, 2004 4:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error log
Replies: 2
Views: 608

I would use a UV stage and point it at one of the RT_LOGxxx files. Where xxx is the job number for this job. You will need to parameterize this job number. You should be able to select * from RT_LOG#JobNumber# and load it any where you want.