create table dbo.iq_test(
pkey numeric( 18 , 0 ) identity, 
id numeric( 18 , 0 ) not null,
value nvarchar( 10 ) not null,
b bit not null,
constraint it_PK primary key nonclustered(pkey)
)
go
insert into dbo.iq_test(id,value,b) values( 13 ,'первая запись', 0 )
go
insert into dbo.iq_test(id,value,b) values( 17 ,'вторая запись', 1 )
go

create table dba.iq_test(
pkey numeric( 18 , 0 ) default autoincrement, 
id numeric( 18 , 0 ) not null,
value varchar( 20 ) not null,
b bit not null,
constraint it_PK primary key nonclustered(pkey)
);

set option identity_insert='dba.iq_test';
load table dba.iq_test
    (    pkey ',',
    id ',',
    value      ',',
    b   '\r\n'
)
from 'C:\\IQ\\load\\biplane\\iq_test_utf8.txt'
format ascii
quotes off
escapes off
message log 'c:\\iq\\load\1.msg'
row log 'c:\\iq\\load\1.row'
;
set option identity_insert='';

set temporary option ESCAPE_CHARACTER='ON';
set temporary option conversion_error='Off';
set temporary option date_format='yyyy.mm.dd';
truncate table dba.tmp_payment;
load table dba.tmp_payment(    
pb_pkey '][',
pb_date_pay '][',
.....................
cc_kod '][\x0a'
)
from '/data/load/payment_cp1251.txt'
quotes off
escapes off
message log '/data/iqdb/message.msg'
row log '/data/iqdb/message.row'
ONLY LOG all
LOG DELIMITED BY '#'
preview on
;

set option public.Main_Cache_Memory_MB= 1600 ;
set option public.Temp_Cache_Memory_MB= 2400 ;

create database '/data/iqdb/michael.db'
transaction log on
java on
jconnect on
page size  4096 
collation '1251cyr'
case ignore
password case ignore
iq path '/data/iqdb/michael.dat'
iq size  2000 
iq page size  131072 
temporary path '/data/iqdb/michael.iqtmp'
temporary size  2000 ;

set option Public.Main_Cache_Memory_MB='1600';
set option Public.Temp_Cache_Memory_MB='2400';