Search found 50 matches

by Juls
Thu Apr 12, 2007 9:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using Transform in Trigger expression
Replies: 6
Views: 3080

Using Transform in Trigger expression

Hi, I have a sequence job where a Nested Condition stage has multiple custom Trigger expressions for multiple links. I call it my decission point. Each expression uses a transform to get the result and based on the result I will continue. Expressions looks like this: UtilityHashLookup('ha_EDW_FAC_AC...
by Juls
Wed Nov 29, 2006 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transformer satge output links
Replies: 3
Views: 1120

Transformer satge output links

Hello, I have a rather beginer question. In the transformer stage, if I have 3 output links each with constraint will a row be processed first against link1 and if meets the constraint it will move on to next row or will this same row1 then be checked against link2? I am guessing it will move to nex...
by Juls
Thu Jul 20, 2006 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export schedules
Replies: 9
Views: 2586

I am running on Windows and using AT scheduler.

What if I delete my current project and create a new one with the same name, import the jobs. Would the schedules still be valid? or will they be deleted from AT when I delete project?
by Juls
Thu Jul 20, 2006 2:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export schedules
Replies: 9
Views: 2586

I thought tthat schedules are stored somewhere in DS files like it stores environment variables and list of jobs, etc...
by Juls
Thu Jul 20, 2006 2:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export schedules
Replies: 9
Views: 2586

Export schedules

HI, My project is corrupted to a point that a REINDEX does not help and DS support tried every command possible to help, but without a result. So I decided to maybe create a new project and import all the good jobs in. I have a lot of schedules for different jobs in this project and do not really wa...
by Juls
Thu Jun 15, 2006 9:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call job on a different server to run from sequence
Replies: 2
Views: 1356

Call job on a different server to run from sequence

Hi, I am sure someone has done it before. I need to call a sequence job located on server2 from a sequence job located on server1. I realize it can be done somehow using a command stage and call a batch file that has a command line in it for the job from server2. I looked at dsjob command but didn't...
by Juls
Tue Apr 04, 2006 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transform in Routine
Replies: 2
Views: 1598

Transform in Routine

Hi, I get an error when compiling a routine that calls a transform. All I have in a routine for now is: Ans=TAG.TO.DATE("2006-03-24"); and I get an error when I compile: "Array 'TAG.TO.DATE' never dimensioned." What am I missing? I also tried to use the following and I get the sa...
by Juls
Tue Mar 28, 2006 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 37597

If the value is set in one sub-sequence and needs to be accessed in another, that second sub-sequence will need a Routine Activity stage that can retrieve the User Status area from any named job in order to bring that value over into the second sub-sequence. Assuming, of course, that the job that s...
by Juls
Mon Mar 27, 2006 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 37597

Thanks a lot! I got it working also using a transformer stage variable: 1) I assigned the value to the transformer stage variable 2) wrote an after routine that pulls the value of this stage variable and assigns it to USERSTATUS. 3) in the sequence job I call another routine that I wrote that extrac...
by Juls
Fri Mar 24, 2006 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Different routine results
Replies: 2
Views: 714

SO SIMPLE!!!!!! trim worked!!!!

But I could swear that there weren't any spaces!!!!

I guess you can never be too sure until you TRIM.

Thanks!!!
by Juls
Fri Mar 24, 2006 3:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Different routine results
Replies: 2
Views: 714

Different routine results

Hi, I wrote a routine that takes 3 arguments and outputs a number. When I "Test" the routine with a set of values then it returns the correct value. When I put the same routine in my transformer and pass the same arguments it returns the wrong value. I am lost.. I checked and rechesked the...
by Juls
Fri Mar 24, 2006 11:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 37597

Thanks, But where in the server job will I call DSSetUSerStatus if I want to set it to the value that I calculate in a Transformer stage? Basically I want the USERSTATUS to be equal to a Derivation I have in a Transformer stage. When job runs the derivation has a result that is being written to a DB...
by Juls
Thu Mar 23, 2006 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 37597

Passing parameter out of datastage job

I am looking for a way to pass parameter value out of a server job to be used as value in parameter of another server job. I realize that this is not possible to do easily and I don't want to put a value into hash value and then retrieve it using UtilityHashLookup in sequence job. I was thinking to ...
by Juls
Thu Nov 17, 2005 6:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SAP BW PACK Version 4.2 Install
Replies: 2
Views: 1060

It says at first : BW Open Hub Extract Failure. Then ProcessChain Log Entry Log ID: C8K320FX6KYS06OAQIC7306GO Disposition: Error Action: Data Export into External Systems Varient: DOC_TYPE Attributes ID: SPOK_71L0X2HSJZKB9DX2TUWE25NRC Result: Ended with errors Then timeout waiting for BW to start lo...
by Juls
Thu Nov 17, 2005 5:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SAP BW PACK Version 4.2 Install
Replies: 2
Views: 1060

SAP BW PACK Version 4.2 Install

Hi, I have been working with SAP BW pack version 4.1 and was told to upgrade to next one 4.2 to fix some issues. Now that I upgraded, everything is failing with the message that seems like a communication issue. My RFC is up and running and connected to BW. The problem comes in when it runs process ...