I have a situation where I have created a proxy table in an "Adaptive server Anywhere 220.127.116.1102" database to pull in data from another SQL database (cache? not sure what version). For some reason the field lenth of one of the fields (Account_num) in this proxy table is showing up as a 'Numeric 7,0', however, this field is actually 'Numeric 8,0' on the original database. If I try to query the table from sybase for an 8 digit account nuumber I get an error, but if I try to pull info into Excel via ODBC I can succesfully run a query on an 8 digit account number.
Any ideas on this? Let me know if more information is needed, I am new at this and still learning.