Author Topic: DECFLOAT  (Read 3535 times)

pankaj.puranik

  • Sr. Member
  • ****
  • Posts: 374
    • View Profile
DECFLOAT
« 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.

jeffs42885

  • Guest
Re: DECFLOAT
« Reply #1 on: December 14, 2012, 05:42:42 AM »
What kind of file is it?

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2230
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: DECFLOAT
« Reply #2 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!
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

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

jeffs42885

  • Guest
Re: DECFLOAT
« Reply #3 on: December 14, 2012, 08:16:12 AM »
^^Thats exactly where i was going :)