var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: [SYBASE IQ] Loading fixed width into decimal column
Can anyone tell me if this is possible and hopefully how to do it?
I have a datafile that looks like so:
The first column is a barcode, the 2nd a quantity, and the 3rd is a value.
My issue is with the 2nd column.
In the table - the quantity column is DECIMAL(12,3).
The value in the database after the insert should read "0.071".
My problem is when I use this as a column spec in the load statement
",del_qty ASCII(9)" - it loads the data as "71.000" which is obviously not what I need.
Can anyone help me out?