Hi,
I'm new to MaxDB loader, and stuck in importing simple data into table. I'm using
MaxDB 7.5.08 on Linux.
Appreciate if anyone can help me out.
Table structure
=================================
Table "SCOTT.SYS_PARAM"
| Column Name | Type | Length | Nullable | KEYPOS |
| ---------------- | ------------- | ------ | -------- | -------- |
| CREATE_DATE | DATE | 10 | YES | ? |
| LAST_UPDATE_BY | VARCHAR ASCII | 32 | YES | ? |
| LAST_UPDATE_DATE | DATE | 10 | YES | ? |
| PARAM_CAT | VARCHAR ASCII | 10 | YES | ? |
| PARAM_DESC | VARCHAR ASCII | 50 | YES | ? |
| PARAM_ID | VARCHAR ASCII | 3 | YES | ? |
| PARAM_TYPE | VARCHAR ASCII | 2 | YES | ? |
| PARAM_VALUE | VARCHAR ASCII | 100 | YES | ? |
Loader command
=================================
loadercli -d sdb1 -u scott,tiger -b cmdfile -o test.out -E 100000
cmdfile =>
dataload table sys_param
ignore duplicates
PARAM_ID 1
PARAM_VALUE 2
PARAM_TYPE 3
PARAM_CAT 4
PARAM_DESC 5
CREATE_DATE 6
LAST_UPDATE_DATE 7
LAST_UPDATE_BY 8
infile 'sys_param.txt'
separator '|'
delimiter ''
date 'yyyy-mm-dd'
NULL '_NULL_'
Test data (sys_param.txt)
=================================
110|10|CS|Test|Maximum Login Retry|2003-11-26|2004-03-12|ECOU
150|6|SM|Test|Redemption Ref. Number Length(Max.8)|2003-11-26|2004-03-12|ECOU
Error received
// M Error at record 1 in infile.
// E -25301: Invalid input for date or time column: 2003-11-26
// M Last transaction committed at input record 0
// *
// M Sum of inserted records 0, sum of rejected records 1
Thanks,
Andy
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
