Try wrapping your SP with a BEGIN ... END. The workaround worked for mexch2005 wrote:I tried to use CALL instead of EXEC to run the stored procedure (in ODBC connector) and unfortunately that did not work either.
Search found 376 matches
- Sun Dec 01, 2019 12:56 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
- Fri May 12, 2017 12:47 pm
- Forum: General
- Topic: Keep repositories in sync
- Replies: 3
- Views: 3701
- Fri May 12, 2017 11:22 am
- Forum: General
- Topic: Keep repositories in sync
- Replies: 3
- Views: 3701
Keep repositories in sync
Hi All,
I'm planning to create a process to export the project repository in production and have it imported into a project in the development area. Can you give me some guidance on how to get started with this?
Perhaps, a script already exists
Thank you
I'm planning to create a process to export the project repository in production and have it imported into a project in the development area. Can you give me some guidance on how to get started with this?
Perhaps, a script already exists
Thank you
- Tue May 09, 2017 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Handling Issue In Transformer
- Replies: 3
- Views: 3882
- Tue May 09, 2017 1:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Handling Issue In Transformer
- Replies: 3
- Views: 3882
Null Handling Issue In Transformer
Hi All, I'm facing a weird sort of an issue. I have an attribute that carries a NULL value. When I try to perform logical operations using IsNull(variable), the transformer doesn't seem to be able to recognize it as a null. However, when I do a Seq(variable) to check the actual value, I get a 0 whic...
- Thu Jan 12, 2017 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: End-Of-File communication channel
- Replies: 2
- Views: 3134
End-Of-File communication channel
Hi, One of our jobs that loads a large volume into the table finishes with the warning - The OCI function OCISessionEnd returned status -1. Error code: 3,113, Error message: ORA-03113: end-of-file on communication channel I'd expect such communication failures to result in aborts and not just warnin...
- Sun Dec 18, 2016 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
- Fri Dec 16, 2016 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
- Thu Dec 15, 2016 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
.... Secondly, could you elaborate a bit on your job design? I'm assuming you are using the Stored Procedure stage for this, if so could you detail the design and the settings you are using in the stage? Hoping it might help. Thanks for opening up the post. My job design is very simple RowGen --> S...
- Wed Dec 14, 2016 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
Help us out here, I'm curious about a couple of things. One is when you wrapped it in a script to call from DS, if you run the script from outside of DataStage does it work? Hopefully the scrip ... Let me try running the script from outside of DataStage. One more thing that I should probably add is...
- Wed Dec 14, 2016 11:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
...Seems like in either case though, you should get a timeout error that the job would detect and abort on. Exactly my thought. I've been in situations where the session would timeout and it would get logged. Here, it just hangs. The DBA checked and told us that inactive sessions longer than 40 min...
- Wed Dec 14, 2016 12:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
- Wed Dec 07, 2016 3:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job with Procedure Hanging
- Replies: 12
- Views: 11841
Job with Procedure Hanging
Hi, I have a job that simply invokes an Oracle Procedure. The procedure takes about 1.5 hours to complete for approx 50 million records. The issue is that the job goes into an indefinite "Running" state. We waited for more than 7 hours only to later realize that the procedure had actually ...
- Tue Nov 15, 2016 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Pattern Read Using Multiple Readers
- Replies: 1
- Views: 2765
Sequential File Pattern Read Using Multiple Readers
Hi All, I've created a job that reads more a batch of files and pushes it further for processing. Using the file pattern tor read the files means that I am constrained to just one reader per node in the sequential file stage. Is there a way to increase the number of readers per node while using file...
- Thu Sep 01, 2016 11:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: User inserted sort does not fulfill the sort requirements
- Replies: 5
- Views: 10832