Search found 50 matches

by Mat01
Wed Dec 08, 2004 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job routines
Replies: 3
Views: 2487

Hi Rajeev, If you need more info about routines, the installation CD contains a folder called Samples (see the help files on Parallel routines). Basically, a parallel routine is a c++ function. I know it wasn't like that in v6 (only custom stages where available as Ray said) but in v7.5, you can def...
by Mat01
Mon Nov 08, 2004 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unlocking jobs
Replies: 17
Views: 8291

Thanks all!

Mat
by Mat01
Mon Nov 08, 2004 11:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unlocking jobs
Replies: 17
Views: 8291

I receive the message: "This command is not supported" when I type LOGTO UV. Maybe v7.5 does not support it anymore...
by Mat01
Mon Nov 08, 2004 11:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unlocking jobs
Replies: 17
Views: 8291

Yes I am logged in as dsadm. I know when I did this previuosly that I had to type something like COPY SOMETHING TO VOC FILE but I can't remember what...

Thanks
by Mat01
Mon Nov 08, 2004 11:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unlocking jobs
Replies: 17
Views: 8291

unlocking jobs

Hi All, I have a problem with the unlock command in Administrator. I am issuing the command: LIST.READU to get the Inode of the process I want to clear. But when I do: UNLOCK INODE #node_number# ALL I get the message: "UNLOCK" is not in you VOC file. I remember that I need to copy somethin...
by Mat01
Mon Nov 01, 2004 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Erros in using Transformer Stage
Replies: 7
Views: 2512

Hi,

Try the test I suggested on this post:
viewtopic.php?t=89710

If you encounter compilation problems with an "empty transformer" (as in a transformer doing nothing), it is a good indicator that your compiler may be the issue.

Regards,

Mat
by Mat01
Mon Nov 01, 2004 8:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error running transformer in PX but in Server working fine
Replies: 5
Views: 2459

Hi, We had this error previously. It is probably related to a problem with your c++ compiler. Try this: Build a simple job mapping a file directly to another one. If this works, insert a transformer between the files to do the mapping (without any transformation). If it fails when you compile, check...
by Mat01
Thu Sep 16, 2004 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer and job parameters type
Replies: 5
Views: 2841

My data types (file, stage var and job params) are all integer, I have no string type in this job. I don't know why PX interprets the variables as strings. But it seems we also have compiler issues so this might be the problem.

Thanks

Mat
by Mat01
Wed Sep 15, 2004 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer and job parameters type
Replies: 5
Views: 2841

Transformer and job parameters type

Hi All, I am building a transformer in PX. My job has integer type parameters but the transformer gives me a conversion error when I compile it (string to int32). When I look at the generated code, I see that my parameters are defined as string in the transformer code. Since I perform mathematical o...
by Mat01
Tue Sep 14, 2004 8:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting data by periods
Replies: 4
Views: 1845

Thanks guys!

Mat
by Mat01
Sun Sep 12, 2004 2:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting data by periods
Replies: 4
Views: 1845

Splitting data by periods

Hi All, I have a requirement to split my incoming data in multiple rows by periods. I have to read 2 fields: begin_day and termination_day and split the incoming record into as many records as needed with each of them having a one month lengh. For example, if I have begin_day = 01/01/2004 and termin...
by Mat01
Sat Sep 11, 2004 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automatically handle activities that fail.
Replies: 9
Views: 5107

I added an "otherwise" trigger to my routine and it did work this time. I guess if you don't have a "failure trigger" it keeps checking for this 0 return value...I do not usually use a failure trigger with every routine...some are so simple that they could not really fail. Well t...
by Mat01
Fri Sep 10, 2004 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automatically handle activities that fail.
Replies: 9
Views: 5107

Sorry guys. I'm probably very slow... So I added a second routine to my test sequence and used a custom trigger (Routine_Activity_0.$ReturnValue = 1) instead of the return value trigger alone. As you see, I want my next job to be triggered when the return value is 1. It still fails and if you look a...
by Mat01
Fri Sep 10, 2004 10:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automatically handle activities that fail.
Replies: 9
Views: 5107

Hi, I found out why this is happening. The generated job control code for the sequencer checks the return code of the routine. If the return code is not 0, it fails!!! I tested it with a routine that returns 0 and...no failure this time. This means that we can't use any of our routines which return ...
by Mat01
Fri Sep 10, 2004 10:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automatically handle activities that fail.
Replies: 9
Views: 5107

Thanks, It may have something to do with the return value of the routine. I set up a test with a sequencer that has only a routine activity (With a standard write to log routine). My sequencer doesn't have any trigger since there is only one "activity". The job sequencer fails anyway after...