Problems with STP stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Problems with STP stage

Post by yaminids »

Friends,

I was trying to use STP stage, for the first time, to execute the stored procedure. The design of the job is simple: it executes a procedure without any input parameters

STP stage properties
Stored Procedure Name: PROMOTION_DIM.MAIN_PROCESS
Generate Procedure Call: NO
Procedure Type: Source
Stored Procedure Statement: BEGIN PROMOTION_DIM.MAIN_PROCESS(); END;

The job compiles without errors/warnings but when I try to execute the job it fails with the following error:

"Client Library property required for stage STP_STG.Stored_Procedure_41"

Can someone help me with this error?

Thanks in advance
Yamini
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

Your best (and quickest) help would come from performing a <a href="search.php">search</a> on your error message.

It would have delivered useful topics on your, like perhaps <a href="viewtopic.php?t=104192&highlight=Client ... tage">this one</a>.

J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Post Reply