Q
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
'2008-09-05.14.15.00'

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.

CPYFRMIMPF FROMSTMF('tstest.txt') TOFILE(tstable) RCDDLM(*CRLF) STRDLM('''')

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.

-ADS BY GOOGLE

SearchDataCenter

Close