Hello, there are different ways to activate the oracle mode for precompiler applications:
- set the precompiler option "-S oracle" when you precompile your program cpc -S oracle <progname> - or set the environment variable "SQLOPT=-S oracle" before running your program You can also set a special sqlmode for a single precompiler command: EXEC <sqlmode> SELECT * FROM DUAL /*possible sqlmodes are INTERNAL|ANSI|DB2|ORACLE*/ Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 12. M�rz 2003 11:28 > To: [EMAIL PROTECTED] > Subject: RE: to_date and migration from Oracle > > > Thanks for the quick answer, but there still are some > questions. I have > read the next lines on the reference manual: > > "SQLMODE > The specification SQLMODE <INTERNAL|ANSI|DB2|ORACLE> can be > used to select > the SQL mode [Page 39]. > The default SQL mode is INTERNAL. > The CONNECT option SQLMODE <INTERNAL|ANSI|DB2|ORACLE> is not > allowed in > programs. > The appropriate precompiler option must be used to specify an SQLMODE > other than INTERNAL." > > 1. The option SQLMODE is not allowed in programs, so all > solutions only > apply when working with SQL Studio and scripts ? > 2. What is the precompiler option ? It means that we have to compile > something of SAP DB ? > > Thanks one more time ! > > Ignacio. > > > > > Hi Ignacio, > > you may want to try the Oracle mode for your statements. (See > http://www.sapdb.org/7.4/htmhelp/81/ee4d3c596f0b26e10000000a11 402f/content. htm) There are also several function defined by Oracle available (see http://www.sapdb.org/7.4/htmhelp/b4/034e3ce0f9fe3fe10000000a114084/content. htm), including TOD_DATE, TO_CHAR, TO_NUMBER to some extend. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 12, 2003 10:26 AM > To: [EMAIL PROTECTED] > Subject: to_date and migration from Oracle > > > Hello everybody, > > we are just starting with SAP DB and we have to migrate some intranet > applications from Oracle to SAP DB. The migration process > with export / > import of scripts goes well. The problem is within the > application, because > it extensively uses TO_DATE and TO_CHAR when works with date fields. > > Is there any quick solution, without change all SQL code ? > > Thanks in advance. > > Ignacio > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
