sybase load table使用實例

load table ftbCgi( intBranchId,intBscId,intSgsnId )
from
    '/opt/iq/userDB/1281496975827.txt' delimited 
by
    ',' row delimited 
by
    '
' escapes off quotes off with checkpoint on;




Load Table month
(   month_key        '|',
    month_text       '|',
    month_number     '|',
    fiscal_period    '|',
    year             '|',
    period_and_year  '|',
    month_and_year   '\x0a')
FROM 'D:\SybaseIQ\data\month.dat'
escapes off
quotes off
Notify 100
WITH CHECKPOINT ON;

COMMIT;

Load Table service
(   service_key			'|',
    call_waiting_flag		'|',
    caller_id_flag		'|',
    voice_mail_flag		'|',
    cellular_flag		'|',
    internet_flag		'|',
    isdn_flag			'\x0a'  )
FROM 'D:\SybaseIQ\data\service.dat'
escapes off
quotes off
Notify 10000
WITH CHECKPOINT ON;

COMMIT;


Load Table status
(   status_key			'|',
    new_customer		'|',
    new_address			'|',
    call_waiting_status		'|',
    caller_id_status		'|',
    voice_mail_status           '|',
    cellular_status		'|',
    internet_status		'|',
    isdn_status			'|',
    closed_this_period	'\x0a'  )
FROM 'D:\SybaseIQ\data\status.dat'
escapes off
quotes off
Notify 100
WITH CHECKPOINT ON;

COMMIT;