OnDemand User Group

Support Forums => Report Indexing => Topic started by: pankaj.puranik on December 14, 2012, 12:40:15 AM

Title: DECFLOAT
Post by: pankaj.puranik on December 14, 2012, 12:40:15 AM

Hi

I am trying to load some data into CMOD 8.5.0.5 using Generic Indexer.
I get the following error.

.SQL0420N Invalid character found in a character string argument of the function "DECFLOAT"

I do not get what invalid character it is talking about?

Thanks
Pankaj.

Title: Re: DECFLOAT
Post by: jeffs42885 on December 14, 2012, 05:42:42 AM

What kind of file is it?

Title: Re: DECFLOAT
Post by: Justin Derrick on December 14, 2012, 07:00:04 AM

Take a look at the file with a hex editor.  Strange (yet unprintable) characters can find their way into data.  The most frustrating one I found was a vendor who was inserting tab characters at the end of some fields in the generic index file -- they were invisible when displayed in most text editors!

Title: Re: DECFLOAT
Post by: jeffs42885 on December 14, 2012, 08:16:12 AM

^^Thats exactly where i was going :)