import MultiLoad problem


import MultiLoad problem


I have some problems to load a char(06) variable wich represent hours.

I'm trying to import this variable in a TIME variable with a format like this HH:MI:SS.

What is the command (format) that MultiLoad wants to be able to load it in my table.

Thanks in advance !!

Re: import MultiLoad problem

Hi Valery,
Guess this reply isn't quickest but i haven't logged in for a long time due to work. I faced a similar problem with multi loads with date, time and timestamp fields. Just remove the format statement in the multi load and load the data with the format "hh:mi:ss". Hence the data should be in this format but the multi load should not contain this formatting statement as this is the default format for the TIME fiedl type. Only then the data will load. Hope that helps.