DECFLOAT

Previous topic - Next topic

pankaj.puranik

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.

jeffs42885

What kind of file is it?

Justin Derrick

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!
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

jeffs42885

^^Thats exactly where i was going :)