Is there a limit to the length of the SQL Statement?
Posted: Mon May 09, 2005 8:30 pm
DataStage Server Edition 7.5.1
Hi There,
I'm wondering if anyone can provide an answer my question (in the subject line). I've seen some references to the issue on this forum, but no answer to the question.
We've encountered this problem recently when using a Sybase_OC stage. It wasn't possible to break up the SQL statement, so we ended up having to create a database view, which we then used at the source.
The reason I'm asking is that we're creating jobs that will have "dynamic" where clauses, created outside of DataStage, and it is possible that we may hit this limit. I'm hoping we may be able to trap this problem prior to running the DataStage jobs.
Cheers,
Pete
Hi There,
I'm wondering if anyone can provide an answer my question (in the subject line). I've seen some references to the issue on this forum, but no answer to the question.
We've encountered this problem recently when using a Sybase_OC stage. It wasn't possible to break up the SQL statement, so we ended up having to create a database view, which we then used at the source.
The reason I'm asking is that we're creating jobs that will have "dynamic" where clauses, created outside of DataStage, and it is possible that we may hit this limit. I'm hoping we may be able to trap this problem prior to running the DataStage jobs.
Cheers,
Pete