Re: ODBC: "Your import data source is not valid"

[rob@xxxxxxxxx]

There are options in the odbc setup to print out the joblog and trace 
information when done.  Something which shows up in the joblog for all 
users except me (when querying the exact same data) is
SQL0802    Diagnostic              30   10/12/10  14:17:47.998737  QSQRUN3 
     QSYS        *STMT    QSQRUN3     QSYS
> From user . . . . . . . . . :   DARRENS
> From module . . . . . . . . :   QSQOPEN
> From procedure  . . . . . . :   CLEANUP
Statement . . . . . . . . . :   26288 
To module . . . . . . . . . :   QSQOPEN
To procedure  . . . . . . . :   CLEANUP
Statement . . . . . . . . . :   26288 
Message . . . . :   Data conversion or data mapping error.  
Cause . . . . . :   Error type 1 has occurred. Error types and their 
meanings
  are: 1 -- Arithmetic overflow.

I can't begin to fathom how it might be the data in the file itself when 
this does not happen for me but happens for QSECOFR and everyone else.


Rob Berendt