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.
I checked all the datatypes,table names,column names and data contents still Iam getting the same error.
##F IIS-DSEE-TDOR-00491 06:40:53(007)<main_program>: Fatal Error: Invalid character encountered in table S17_DLPTGF_TLF
I have taken out the where clause "column name='xx' " then it is working fine.Just wanted to give column name='xx' I should not get any errors. How to do that any suggestions
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
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
Bingo..Iam using varchar Datatype.But it is working fine in Toad(with no records) if I give IM_ITEM_NBR <> 'xx' it is giving me the whole data and ds is also behaving like oracle.