DATASTAGE ODBC query get current_timestamp

Asked

Viewed 50 times

0

I am doing a job in Datastage and when I enter the query in ODBC I need the Current timestamp, and it always passes me to null when writing in the table. I’ve used CURRENT_TIMESTAMP, (CURRENT_TIMESTAMP), '#CURRENT_TIMESTAMP#', etc...

Follow the query.

(INSERT INTO dev_dw.compress_log VALUES ('#ORIGIN_TABLE#' , '#DESTINATION_TABLE#', '#CONDITION#' , CURRENT_TIMESTAMP )).

Someone can help me?

I created a table in parquet in Hive, when running the job I cannot insert the current_timestamp in the table I created.

INSERT INTO dev_dw.compress_log VALUES ('#ORIGIN_TABLE#' , 
    '#DESTINATION_TABLE#', '#CONDITION#' , CURRENT_TIMESTAMP )
sql
  • 1

    You’re a little confused man, you can explain a little better?

  • Which database, SQL Server?

  • I created a table in parquet in Hive, when running the job I cannot insert the current_timestamp in the table I created.

1 answer

-1

Good night! You can make an Insert by passing a new column from a Transformer with the Currenttime function()

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.