Warning Message - Table not found
Moderators: chulett, rschirm, roy
Warning Message - Table not found
We're running PX 8.5 on Unix and during a run, we received a warning message stating that a table was not found. I know from previous experiences with Datastage that it would abort when this happens. The difference I see is, we are using Aliases and there was no data to load.
We are running on DB2.
Has anyone ever experienced this and opened a PMR regarding it.
Thanks in advance
We are running on DB2.
Has anyone ever experienced this and opened a PMR regarding it.
Thanks in advance
Jim Stewart
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Table not found" is very different from "table exists but has no rows to process". DataStage will abort in the former case but will happily process those zero rows in the latter case.
Check again that you have spelled the table/alias name correctly, that the alias does actually exist, and that your credentialled user has privileges to SELECT. Also that you're executing in the correct schema.
Check again that you have spelled the table/alias name correctly, that the alias does actually exist, and that your credentialled user has privileges to SELECT. Also that you're executing in the correct schema.
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:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Would you believe I once worked on a project where there was a source table called TARGET? Should've been SALES_TARGET, but I didn't have enough weaponry with me at the time to mount a convincing argument.
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: 50
- Joined: Tue Jan 19, 2010 4:14 am