substitute in SQL.INI

forum.sqlbase (2000-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

substitute in SQL.INI

Post by NewsgroupServer » 21 Jun 2010, 15:18

 Posted by:  Christoph Kukulies 

The SUBSTITUTE syntax allows to substitute a pattern against another
pattern, useful e.g. in the [oragtwy] section to Gupta/Centura/Unify
functions to Oracle:

SUBSTITUTE=@ROUND,ROUND

Would that work in a manner like C-language #define MACROS as well, like
saying:

SUBSTITUTE=@YEARNO(x),TO_NUMBER(TO_CHAR(x,'YYYY'))

--
Christoph Kukulies

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

substitute in SQL.INI

Post by NewsgroupServer » 24 Jun 2010, 05:36

 Posted by:  Hyacinth Pfeiffer 

Hi Christoph,

I don´t think so; as far as I know substitute is a plain text
substitution, not a macro call.

hth
hyacinth

Return to “forum.sqlbase”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests