ISQL, dbload from ascii, money fields

Posted in 1991

Mark Elliott — Tue, 6 Aug 91 10:00:47 PDT — source: Informix-list mailing list archive (1991-1998)

I am using Informix SQL 2.10 on an Intel 320, SCO Xenix system V. I am trying to use DBLOAD to insert data into a table. One of the columns is defined as money(16/2). When I run dbload, the money column is not recognizing the decimal point and all values are 100 times what they should be. Do I need a USING statement in the command file or what? Thanks in advance. -------- 2LT Mark G. Elliott Washington Army National Guard doma%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil Comm (206) 581-8235 DSN: 355-8235 --------