Search code examples
db2ibm-clouddb2-luw

IBM Lift CLI - Load with error "A delimiter is not valid or is used more than once"


I try this load command in Lift CLI with target Db2 on Cloud:

lift load -f xxx700.csv -ts SCHEMA -tt xxx700 -pf lift-parm -fo user \
  -a replace -dd þ -df DD.MM.YYYY -fd 0x3B -tsf YYYY-MM-DD-HH.MI.SS.FFFFFF

and get the message "A delimiter is not valid or is used more than once"

Before I "put" the CSV-file from a Windows-Client to the landing zone. Why is the -data-delimiter þ (ANSI 0xFE) not valid ?


Solution

  • I solve the problem: With IBM lift only character below 0x80 are valid as data-delimiter