Search found 20 matches

by uzl
Wed Jan 02, 2013 3:44 am
Forum: General
Topic: Triggers in a Sequence job
Replies: 11
Views: 4748

Triggers in a Sequence job

I don't understand this. Does this mean that triggers don't work in a sequence ? I tried the following. For a Job Activity I have two triggers : file_to_stage OK file_to_stage_fail Custom : NOT(DSJS.RUNOK) If the job gives a warning the sequence is stopped. Neither trigger is executed ? I also tried...
by uzl
Tue Dec 18, 2012 3:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored procedure on Sybase ASE
Replies: 3
Views: 1589

thanks

Thanks for the info. I'll try setting the type to "target" as soon as possible. But I find it strange that I have to change it to "target" just because I have an input parameter. Functionally, this stage is a "source"-stage...
by uzl
Fri Dec 14, 2012 2:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored procedure on Sybase ASE
Replies: 3
Views: 1589

Stored procedure on Sybase ASE

I'm trying to use a stored procedure on Sybase ASE. All works fine as long as the stored procedure doesn't use any input parameters. When I use an input parameter I get the error : 'Procedure TV_testOutputParams_simple expects parameter @type_in, which was not supplied. '. On SQL Server, I have no p...
by uzl
Fri Dec 07, 2012 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Procedure - Invalid Argument Value
Replies: 2
Views: 2344

Thanks Joyce, I could have searched forerver
by uzl
Wed Sep 26, 2012 2:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to pass current date as filename in datastage server
Replies: 7
Views: 16511

I use a User Variables Activity in my sequence. Here i define the variable current_date as Oconv(@DATE,'D-YMD[4,2,2]') :'_':Oconv(@TIME,'MTS.'). This variable I pass to the job in the Job Activitythat follows the User Variables Activity.