Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Timestamp not in valid format using CPYFRMIMPF

A timestamp error is caused by either not specifying the proper string delimiter on the CPYFRMIMPF command or not formatting the quote properly.

I am trying to import a tab seperated file that is an export from MySQL. I have timestamp fields on my AS/400 DB2 file.

The format on the MySQL is
'2008-09-05 14:15:00'

The format in my DB2 table is

When using CPYFRMIMPF to port the data in it states the timestamp is not in a valid format.

Based on the information provided, I am guessing that your error is caused by not specifying the proper string delimiter on the CPYFRMIMPF command. You need to make sure that a single quote (') is specified on the string delimiter command.


Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.