Hi All,
We are using the Sybase Enterprise Stage to Extract Data, we have a problem when we use more than 4 or 5 union all in the extraction query.
Has anyone faced similar problem, is there any limitation in the sybase enterprise stage editor.
This is the error message that we see.
( The name supplied is aliased to another user )
Regards
Suresh Nair
Sybase Enterprise Stage (Union All Limitation)
Moderators: chulett, rschirm, roy
Sybase Enterprise Stage (Union All Limitation)
Knowledge is Collection of Facts and Wisdom is Simplifying those Facts.
Suresh Nair
Suresh Nair
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, it revolves around the total size of the query string.
Check with your DBA or Sybase manuals about the maximum length of a query string that can be sent from a client.
Try executing the same query from a different client than DataStage.
Check with your DBA or Sybase manuals about the maximum length of a query string that can be sent from a client.
Try executing the same query from a different client than DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.