warning- Query returns no rows
Moderators: chulett, rschirm, roy
warning- Query returns no rows
Hi,
I have a Teradata Enterprise stage which is the source and it loads the data into the target stage-teradata tpump. This loading is based on the user defined SQl at the source Teradat Enterprise stage. But this query returns no result set. Datastage logs a warning stating "Query returned no results. No read will be performed".
Can somebody help with removing this warning?
Thanks
I have a Teradata Enterprise stage which is the source and it loads the data into the target stage-teradata tpump. This loading is based on the user defined SQl at the source Teradat Enterprise stage. But this query returns no result set. Datastage logs a warning stating "Query returned no results. No read will be performed".
Can somebody help with removing this warning?
Thanks
Are you asking how to remove the warning message from the log or how to fix the 0-rows problem? For the first the answer is "message handlers", but without more information nobody here can answer the second.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
There is no help for it that I am aware of. You'll have to use a MsgHandler or run the SQL beforehand to see if there are rows to load in some kind of overly complicated Sequence. We use a MsgHandler and demote the warning to Informational so that the wrapper shell script doesn't return a failure.
I don't think it is reasonable to throw a warning to the log upon no rows returned but that's the way IBM coded the stage.
I don't think it is reasonable to throw a warning to the log upon no rows returned but that's the way IBM coded the stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Warnings are not necessarily for bad things, they are also alerts for unusual things. In the ordinary course of events DataStage does not expect to process zero rows, so it alerts the operator when a query returns zero rows.
This is the underlying philosophy behind the "Warning" severity.
This is the underlying philosophy behind the "Warning" severity.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
right-mouse click on the warning message in the director, then choose "Add rule to message handler" and continue from there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>