Oninit cdi / Archive
Talk to an expert →

problem with DECIMAL type

Posted in 1999

Topics: General Discussion

sirdna3411@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hello, All! I have a problem with following statement: create table experiment ( name char(35), numb1 decimal(5), numb2 decimal(5,3) ) And on row 'numb2 decimal(5,3)' I got an error -201, SQL syntax error. Why, what's wrong? It's IDS-WorkGroup 7.23 for Windows NT. Informix client SDK 2.30. Thanks in advance! Mark. --== Sent via Deja.com http://www.deja.com/ ==-- Share what you know. Learn what you don't.

↪ replying to sirdna3411@my-deja.com
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Looks fine to me. I also tried it myself in 7.21UD3 and 7.31UC2 with no problems at all. Art S. Kagel sirdna3411@my-deja.com wrote: > > Hello, All! > > I have a problem with following > statement: > > create table experiment > ( > name char(35), > numb1 decimal(5), > numb2 decimal(5,3) > )> > And on row 'numb2 decimal(5,3)' I got > an error -201, SQL syntax error. > > Why, what's wrong? > > It's IDS-WorkGroup 7.23 for Windows NT. > Informix client SDK 2.30. > > Thanks in advance! > Mark. > > --== Sent via Deja.com http://www.deja.com/ ==-- > Share what you know. Learn what you don't.

Related threads