input dataset does not have field error

[PeterPol]

Hello,

The following error is displayed when I do view data in an ODBC stage:

Error executing View Data command:

##E TOPK 000000 10:34:26(015) <_PEEK_IDENT_> Input dataset does not have field: "mutdat"

The following user-defined sql statement is executed:

SELECT
mutdat
FROM
test.DBF

in both test.DBF as on the column tab mutdat is defined as date(8)

Peter

[DSguru2B]

Wrong forum for one. And did you try searching on error message "Input dataset does not have field"?

[ArndW]

Also note that your error is not the database access stage but in the PEEK stage.

[kumar_s]

Does the view data work for any other field other than the given date field?
Just check you don't have any other database issues by changing the query to
'SELECT SYSDATE FROM dual '