Search found 50 matches
- 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...
- 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...
- Thu Jul 20, 2006 3:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Export schedules
- Replies: 9
- Views: 2586
- Thu Jul 20, 2006 2:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Export schedules
- Replies: 9
- Views: 2586
- 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...
- 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...
- 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...
- 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...
- 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...
- Fri Mar 24, 2006 4:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Different routine results
- Replies: 2
- Views: 714
- 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...
- 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...
- 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 ...
- 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...
- 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 ...