DSXchange

xch2005 wrote:I tried to use CALL instead of EXEC to run the stored procedure (in ODBC connector) and unfortunately that did not work either.

Try wrapping your SP with a BEGIN ... END. The workaround worked for me

Will the istool export not contain message handlers and other user variables?

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

Found the issue.

The value was not technically a NULL for DataStage. It was a string of length 0 which Oracle treats as a NULL but not DataStage.

Seq(Variable)= 0 does not represent a NULL
Seq(Variable)=NULL represents a NULL

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...

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...

Thank you, Andy. Will have to think about how to implement that wrapper procedure considering it'll involve intermittently spawning a process while the actual code is still running. Thanks for your suggestions.

Hi Craig, We have it set to "Target". Meanwhile, I contacted the DBA and this was his response Sessions becomes INACTIVE when it does not make a SQL call to database; meaning it becomes INACTIVE only if the session is not doing anything in the database. In case if the session stays INACTIV...

.... 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...

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...

...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...

How do you think will that help? I tried to wrap it in a UNIX script and call the UNIX script from DS but still faced the same issue

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 ...

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...

Did you check if the order of the keys in which you're sorting is the same as the order of your grouping keys in the aggregator?