DSXchange

OK, so here is some more info (1) INPUT PARM : MKT_CODE CHAR(1) (2) OUTPUT PARM : ERROR_FLAG CHAR(1) Result Set Column (will always return more than 1 row for each input) (1) MKT_C CHAR(1) (2) DIV_C CHAR(1) (3) REG_C CHAR(3) Below is what I am doing Source TEXT FILE > STP STAGE (Transformer Type) > ...

I have checked all documentation that I had access to and sniffed many forums, but still no luck. The stored procedure that has been designed just output 1 row as OUTPUT PARM that indicates whether the SP ran OK or not. The actual data is stored in Cursor ResultSet. The STP Stage does mentions how t...

Anyone? Any idea?

I am calling DB2 Stored Procedure through STP Stage (Transform). The output parameter that I get contains only columns containing ERROR_FLAG from procedure. If SQL runs fine ERROR_FLAG returns Y else returns N. The actual data that I want is in Result Set as Cursor. Can STP Stage access Result Set? ...

I imported a DB2 Stored Procedure that has 2 OUTPUT parameter as defined below OUTPUT_1 VARCHAR(2000) OUTPUT_2 VARCHAR(367) When I see the METADATA after importing, both the columns became LongVarchar(). Any idea why Varchar Type Column is automatically changed to LongVarchar() in DataStage 7.5.2?

Hello All, I have searched this forum but couldn't get any thread related to my issue with a possible resolution. Also I have searched the documentation but couldn't find any related to DB2 Stored Execution with STP Stage. I have a stored procedure that takes an input parameter and then should retur...

Ray,

How would I do that in DataStage? Is it something with Data Stage or at DB2 Stored Procedure side?

While importing the Stored Procedure from Manager, what should I pass in the argument list?

I am using stored procedure stage to execute a DB2 Stored procedure that takes 1 input parameter and outputs 4 parameter. The job aborts with this message APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004 What could be wrong? How to addre...

I have a DB2 Stored Procedure, SYSPROC.STPRC009 that I want to run from Data Stage using the Stored Procedure Stage. The Stored Procedure accepts 1 character imut like 'U' 'I' 'P' and return multiple row for the input character passed. Input Parameter COUNTRY_CODE CHAR(1) Output of Stored Procedure ...

I have not used Stored Procedure Stage before, but I see that it has the option to select DB2 in the database type select drop down. So assuming that we actually can call a DB2 stored procedure from within DataStage, How can we use While Loop to read the TEXT file and call DB2 procedure for each row.

I guess use of STORED PROCEDURE STAGE will do the job, but how to do a while loop so that for every row in a text file this Stored Procedure Stage is executed?

I have a stored procedure that will take 1 parameter and will return some output. I will have the parameter values in a text file. Below is an example:- (1) My Data file FinancialYear.txt will have below values 1995 1996 1997 2001 2008 (2) DB2 Stored Procedure will accept above 4 character (year) as...

Even though we know why SELECT access to above tables are needed, it cannot be implemented in my environment. DBA simply refused to give access to these table and I can see a valid point there! DBA says if we are given SELECT privileges, we will be able to know all information about any table on the...

Hello All, Our DBA has refused to grant access to any SYS tables that needs SELECT acess in order to use the Oracle Enterprise Stage. We can use either Oracle Enterprise Stage or Dynamic Relational Stage to access ORACLE Data. My question is (1) Why does ORACLE Enterprise Stage needs access to the S...