Search found 84 matches
- Tue Nov 05, 2019 2:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored procedure when executed in before sql does not work
- Replies: 9
- Views: 8450
- Mon Nov 04, 2019 1:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored procedure when executed in before sql does not work
- Replies: 9
- Views: 8450
- Thu Oct 31, 2019 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored procedure when executed in before sql does not work
- Replies: 9
- Views: 8450
Stored procedure when executed in before sql does not work
Hi, Hope all are doing great. We migrated 8.5 version of jobs (Unix env.) to 11.5 version (Linux env.) recently. We are having trouble with a job that is executing a SQL Server stored procedure from ODBC connector. The same job runs fine in 8.5 but in 11.5 job completes but does perform the required...
- Fri Jun 03, 2016 8:22 am
- Forum: General
- Topic: Field function issue
- Replies: 5
- Views: 3809
- Thu Jun 02, 2016 2:50 pm
- Forum: General
- Topic: Field function issue
- Replies: 5
- Views: 3809
Field function issue
Hi, Basically we are trying to generate and extract when the run flag is "YES" and process type is "A" (or) "YES" and process type is "M" (or) "NO" and process type is "M". Step 1 - An output text file is created with 2 columns and delimite...
- Thu Nov 20, 2014 3:59 pm
- Forum: General
- Topic: Could not uninstall Datastage
- Replies: 1
- Views: 2160
Could not uninstall Datastage
Hi, Had done the installation of Datastage 8.5 version (on Windows 7) and it worked fine, later when the patch (fix pack 3) was installed, it did not go through fine. No error messages were returned, it just came out. When tried to uninstall Datastage the following error was thrown. java.io.IOExcept...
- Wed May 07, 2014 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: WVARCHAR column into a VARCHAR
- Replies: 1
- Views: 5713
WVARCHAR column into a VARCHAR
Hello, I have a parallel job that executes a SQL Server stored procedure as source and it returns an output of few columns. One of the columns is STATUS which is hardcoded (data type is varchar)in the procedure and that is returned but when the job is run got the following warning. The target data t...
- Mon Sep 30, 2013 8:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a sql server stored procedure
- Replies: 7
- Views: 6433
- Mon Sep 30, 2013 7:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a sql server stored procedure
- Replies: 7
- Views: 6433
- Sun Sep 29, 2013 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a sql server stored procedure
- Replies: 7
- Views: 6433
Issue while executing a sql server stored procedure
Hi, We actually execute a sql server stored procedure through a Datastage job and to capture the output of the procedure. The procedure on successfull execution would return 0 else -1 and return mesage either 'Success' or 'Failed' ie. 2 output paramenters from the procedure. We the Datastage job is ...
- Mon Aug 19, 2013 1:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handle reject file
- Replies: 4
- Views: 3232
- Thu Aug 15, 2013 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Handle reject file
- Replies: 4
- Views: 3232
Handle reject file
Hi, We have an issue in way we get the records in a output sequential file in parallel job and the design is straight forward. We have a 3 step validation for input records (from sequential file), first step is to validate column A and if it fails the record goes on to a reject file and if it pass g...
- Tue Jun 25, 2013 8:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a stored procedure
- Replies: 4
- Views: 5315
- Mon Jun 24, 2013 2:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a stored procedure
- Replies: 4
- Views: 5315
- Thu Jun 20, 2013 8:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a stored procedure
- Replies: 4
- Views: 5315
Issue while executing a stored procedure
Hi, The job is fairly simple and straight forward as, oracle stage -> stored procedure stage Here only 1 value (date) is returned from oracle stage and it is passwed to STP stage as input to the procedure, executes the stored procedure which is in Sybase. If the procedure is executed manually it wor...