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 ?
I solve the problem: With IBM lift only character below 0x80 are valid as data-delimiter