We have created a schema on a Windows Machine for one of our SQL tables that uses BIGINT datatype.
On our main UNIX machine (running 10.2B) we can connect to this database, and read data. When trying to write data, we ran across the issue:
"Incompatible data types in expression or assignment."
We dumped the df file of the schema/MSS database on the Windows machine and noticed that progress created it as INT64:
ADD FIELD "ProductionID" OF "Production" AS int64 ... FOREIGN-TYPE "BIGINT"
The only issue is, our UNIX system does not support INT64 (10.2B...we tried to add a field to a database and got an error message stating we could only use decimal, character, etc.)
Is there a work-around for this?