I receive the following when running: (FOC14067) STATEMENT CONTAINS UNKNOWN SCALAR FUNCTION 'to_timestamp' ON LINE 28
Please note that my question is to be used in a regular flow not a DBMS SQL Flow. In a DBMS Flow, I can use TO_DATE, TO_TIMESTAMP. However, I would like to use a regular flow.
About your reminder: 1. Somehow when copying the code to the forum, the left parenthesis is replaced by [ 2. &myDate is stored in a flat file and has format A19V. It is passed into the flow using the "Get parameter using synonym".
iWay Data Migrator v7704M Windows, All Outputs
November 03, 2015, 11:14 AM
Hi David, Have no idea the difference, don't know IWAY, just know WebFOCUS.
In a SELECT statement use the simplified function:
This does beg the question as to why are you still using 7.7.04? It was first release 3 1/2 years ago in April 2012 and it's scheduled to functionally stabilized at the end of December 2015. That's next month.
One way to do this in older releases (albeit with restrictions on non APT queries) is to use SQL. which is the less functional predecessor of DB_EXPR to call a database function:
SQL.TO_DATE('&MYDATE' , 'YYYY/MM/DD HH24:MI:SS' )
November 12, 2015, 10:30 AM
Tom, Kmvgt and Clif, Thanks a lot for your suggestion.
I've try all of your suggestions in a regular data flow but it still doesn't work. As a workaround, I use a DBMS SQL Flow for now .
We are waiting on management decision to upgrade to new iWay version.