error at offset

[priyaram]

i am having a job, that imports an date timestamp.
i am not having that date actually in a table, so the job is giving the error
" date has whitespace delimiter, error at offset 19'

what is that error in offset means??

thanks in advance

[ogmios]

i am having a job, that imports an date timestamp.
i am not having that date actually in a table, so the job is giving the error
" date has whitespace delimiter, error at offset 19'

what is that error in offset means??

thanks in advance

Which kind of database? If you get the error while writing to the database, try to get the output you would normally write to the database in a file and post it here.

"Error at offset 19" means that your field is in error at character 19. Offset 19 would seem to be large for only a date column. Also post the full error message.

Ogmios

[priyaram]

oracle is the database.
and space 19 is for timestamp

[ogmios]

oracle is the database.
and space 19 is for timestamp

Since you mention timestamp I assume you're on Oracle 9 or higher. Timestamp are normally something as:

Code: Select all

                  10-JUN-04 08.15.53.195414 PM

Can you post what you actually make of the your input: post your transformation in DataStage, or the todate format specifier you use.

Ogmios