We are testing programs that we migrated from 4.36 to 5.25, and encountered a problem. The code uses passthru SQL to oracle, and one of the fields selected is an Oracle Date format field. 4.36 recognizes this as YYMD. 5.25 declares this as HYYMDS, and subsequent defines that use this field fail.

What is HYYMDS? How can I get it back to YYMD with minimal code change? This impacts a ton of existing program code.

In the 5.x release of the Reporting Server, the default for dates was changed from YYMD (date field) to HYYMDS (datetime field). You can manually changed the MFD from HYYMDS/HYYMDS (usage/actual) to YYMD/DATE (usage/actual). To change back to the old default, simply add the following line to your server profile (EDASPROF.PRF).

SQL SQLORA SET DATETIME OFF

Any new metadata (MFDs, masters, etc), will now be created with YYMD/DATE as the default usage/actual.

Perfect!!
Thanks a million for the info.

Kyle,
I changed my edaprof and created a new master file description but it still has the HYYMDS. Is there something else I need to do .... ?

I need to be able to test for the following condition TERM_DATE EQ 2005/01/01 00:00:00AM...

Thanks in advance for any and all help....