All Forums Database
kunokb 14 posts Joined 08/11
29 Nov 2011
Why it is prohibited using the CURRENT_DATE value for a valid time column in a temporal database's VT table?

I always get the 9388. error from the Teradata Database 13.10's Messages document:

"Value assigned to VT column should not contain CURRENT_DATE or CURRENT_TIMESTAMP.
Explanation: Error will be reported if the value assigned to VT column contains CURRENT_DATE or CURRENT_TIMESTAMP either assigned directly or through PA."

From here: http://www.info.teradata.com/edownload.cfm? itemid=102320024

dnoeth 4628 posts Joined 11/04
29 Nov 2011

"Remedy: Correct the statement by removing
CURRENT_DATE and CURRENT_TIMESTAMP and
resubmit the request."

Maybe they should rephrase :-)

Remedy: Correct the statement by replacing
CURRENT_DATE and CURRENT_TIMESTAMP with
TEMPORAL_DATE/TEMPORAL_TIMESTAMP and
resubmit the request.

Dieter

Dieter

kunokb 14 posts Joined 08/11
30 Nov 2011

Ahh, so that's the solution! Thanks! :)

You must sign in to leave a comment.