Suggestion: load into a text column and then calculate or UPDATE to a time
column. SMOVEs inside the RTIME.
RRR
Bernard Lis wrote:
>
> loading a comma delimited file into a table where the time column
> contains:
> time is set to hh:mm:ss
> value is 7:24:00 loads ok
> value is 724 get col tmord must be a valid time ; sqlcode <> 0, row not
> loaded
> value is 0724 loads ok
> set time to hhmm and value is 724 get same error
> set time to hmm and get garbage
>
> What's a poor soul to do when some of the rows have a 3 digit time?
>
> Bernie Lis
> Megabytes, Inc.
