Runtime Error
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
Runtime Error
Hi All,
Fatal Error: Invalid character encountered in table
When I run the a Job it is giving me the above error.
Please suggest me.
Fatal Error: Invalid character encountered in table
When I run the a Job it is giving me the above error.
Please suggest me.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
You can't expect the forum members to guess your table name, column names, and data contents. Or the database type and stage you are using and any or all of those will play a role. In addition, the complete error message would also help in helping you.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Hi
I am assuming the datatype as varchar for the column IM_ITEM_NBR please confirm
did u try executing in oracle,if u get out put then in ds also is should not be a prob
please send a few records with data
I guess the problem is with the kind of data the table has
put the condition
IM_ITEM_NBR <> 'xx' and check in both oracle and datastage if it is working on oracle and not in ds means ds is not able to recognize the data or sp chars
I am assuming the datatype as varchar for the column IM_ITEM_NBR please confirm
did u try executing in oracle,if u get out put then in ds also is should not be a prob
please send a few records with data
I guess the problem is with the kind of data the table has
put the condition
IM_ITEM_NBR <> 'xx' and check in both oracle and datastage if it is working on oracle and not in ds means ds is not able to recognize the data or sp chars
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago