Search found 10 matches

by TD_Chile
Tue Nov 04, 2008 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine - Transform Function bug - missing Return(Ans)
Replies: 7
Views: 3082

Re: Routine - Transform Function bug - missing Return(Ans)

This is not a major problem, but an annoying bug which I cannot seem to fix, without creating a new routine, and rebuilding from scratch. I am writing a routine to calculate NCD's, which will be called by the transform function. While writing this routine, I save then compile and then test the rout...
by TD_Chile
Mon Oct 06, 2008 9:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with multiple instance jobs
Replies: 1
Views: 1477

Problem with multiple instance jobs

Some help please: We migrated from 7.5 to 8.0.1 (Server). When had a multiple instance job on 7.5 they ran without problems even when more than 15 instances where called at the same time (with different invocationID of course). Now on 8.0.1 the same jobs only can run as much as 4 at the time and the...
by TD_Chile
Wed Sep 03, 2008 10:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: INT function in 7.5x2 vs 8.0.1
Replies: 4
Views: 2083

well, after doing a lot of tests the conclusion is that null values on DS7 are treated different (clearly it's a bug) and in DS8 null values are always treated as null, in both sequential files and hashed files. I also checked the NULL mapping in the sequential files but it's the same, so all that w...
by TD_Chile
Wed Sep 03, 2008 10:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Funnel
Replies: 9
Views: 3891

sorry, I forgot to specified that the sequential files must be one after the other to do the append
by TD_Chile
Wed Sep 03, 2008 8:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Funnel
Replies: 9
Views: 3891

By the way, if you are joining only two files you can also append the files using 2 sequential file stages and in the input from the second specified the option "append to existing file"
by TD_Chile
Wed Sep 03, 2008 8:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Funnel
Replies: 9
Views: 3891

By the way, if you are joining only two files you can also append the files using 2 sequential file stages and in the input from the second specified the option "append to existing file"
by TD_Chile
Wed Sep 03, 2008 8:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Funnel
Replies: 9
Views: 3891

Ray, how could the link collector cause problems? I use it all the time and sometimes with 10 differents archives (with the same metadata off course) and always works fine.
The CAT, COPY and TYPE commands are also good options too.
by TD_Chile
Mon Sep 01, 2008 11:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: INT function in 7.5x2 vs 8.0.1
Replies: 4
Views: 2083

I don't know if I can specified a different NULL mapping, if yes that could affect the hash files in wich a NULL always it's a NULL, no?
by TD_Chile
Mon Sep 01, 2008 10:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: INT function in 7.5x2 vs 8.0.1
Replies: 4
Views: 2083

INT function in 7.5x2 vs 8.0.1

We're migrating from 7.5x2 to 8.0.1 and when doing the tests we found this problem: the INT () function doesn't return the same value!!! maybe because the value is null but in 7.5x2 a null value in a sequential file it's the same than empty and INT(emptyvalue)=0!!!... but in 8.0.1 a null value in a ...
by TD_Chile
Mon Aug 04, 2008 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error trying configure and compile a Parallel Job
Replies: 1
Views: 1838

Error trying configure and compile a Parallel Job

I have this problem in a job with two flat files and a transformer: (Win 2003 Server, DS 8.0.1) Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 11:57:22(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4458 Copyright (c) 2001, 2005-2007 IBM Corporation. All r...