Error in ODBC stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
devsonali
Premium Member
Premium Member
Posts: 155
Joined: Sun Mar 18, 2007 2:31 pm

Error in ODBC stage

Post by devsonali »

Hi All

We are currently in EE 7.5.1 and when I try to view data from an empty table it gives me an error which says floating point data mismatch error on top of saying that there is no data in the table.
when i try to push in some rows and view the data the view data works fine and it shows up all the rows .

Do you think that its a DS version bug ?

Please give in your inputs for the same


Thanks
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Yeah, if the view data doesn't return any rows, it throws out these type of errors. I gues its trying to populate Null to the existing field to show up the empty table, and getting this errors out.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply