Search found 96 matches
- Fri Jul 20, 2012 1:05 pm
- Forum: General
- Topic: how to delete a parameter from a sequence stage
- Replies: 8
- Views: 3801
- Thu Jul 19, 2012 12:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine returning -1 in the Actual Job
- Replies: 6
- Views: 2965
- Thu Jul 19, 2012 11:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine returning -1 in the Actual Job
- Replies: 6
- Views: 2965
- Thu Jul 19, 2012 11:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine returning -1 in the Actual Job
- Replies: 6
- Views: 2965
I wrote a Server Routine.
Below is the code.
And then I am trying to call this Routine inside a transformer using the Code below:
Below is the code.
Code: Select all
$INCLUDE DSINCLUDE JOBCONTROL.H
Jobhandle=DSAttachJob(Arg1,DSJ.ERRNONE)
Ans=DSGetJobInfo(Jobhandle,DSJ.JOBSTATUS)
Code: Select all
GetJobStatusRoutine(TRIM(svJOBNAME))
- Thu Jul 19, 2012 10:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine returning -1 in the Actual Job
- Replies: 6
- Views: 2965
Server Routine returning -1 in the Actual Job
Hi,
I have built a user defined Server Routine.
I compiled and tested the Server Routine, it works fine.
When I called this Server Routine in another Server Job, it is returning me -1 value.
Any help will be appreciated.....
I have built a user defined Server Routine.
I compiled and tested the Server Routine, it works fine.
When I called this Server Routine in another Server Job, it is returning me -1 value.
Any help will be appreciated.....
- Wed Jul 18, 2012 2:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ETL logic using server jobs
- Replies: 4
- Views: 3764
- Tue Jul 17, 2012 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ETL Logic
- Replies: 6
- Views: 4048
- Mon Jul 16, 2012 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help with Logic - How to split the records into groups
- Replies: 2
- Views: 1053
- Mon Jul 16, 2012 8:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Vertical Pivot missing in Pivot Enterprise Stage
- Replies: 0
- Views: 852
Vertical Pivot missing in Pivot Enterprise Stage
Hi,
Issue: Missing Vertical Pivot
Description: When I use Pivot Enterprise Stage in DataStage. I am not able to see Vertical Option in Pivot Type(Stage---> Properties ---> Pivot Action ---> Pivot Type). But, I can see that option in the other projects.
Issue: Missing Vertical Pivot
Description: When I use Pivot Enterprise Stage in DataStage. I am not able to see Vertical Option in Pivot Type(Stage---> Properties ---> Pivot Action ---> Pivot Type). But, I can see that option in the other projects.
- Fri Jul 13, 2012 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Index Position of Last Occurrence of String
- Replies: 13
- Views: 10694
- Fri Jul 13, 2012 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Index Position of Last Occurrence of String
- Replies: 13
- Views: 10694
Try to get the string after @ in a Stage Variable and then try to find period. For example, SV1 ---> @name.co.uk SV2 ---> Try to find period in SV1 using Index using Index(SV1,'.',1) If SV2 has any value other than 0, it means that it has period in it. And if SV2 has value 0, it means that there is ...
- Thu Jul 12, 2012 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help on rounding a decimal to nearest integer multiple
- Replies: 14
- Views: 4709
- Thu Jul 12, 2012 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: pattern matching job
- Replies: 6
- Views: 2862
- Wed Jul 11, 2012 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help on rounding a decimal to nearest integer multiple
- Replies: 14
- Views: 4709
- Wed Jul 11, 2012 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup not producing expected results
- Replies: 4
- Views: 2648