Add syntax to start of sql statement

building semantic layer
1

Hi there,

I’m after a way to add syntax at the beginning of each sql statement, similar to the universe parameter “END_SQL” that allows syntax to be added at the end of each sql statement.

Any ideas?

:confused:

Fulcher (BOB member since 2005-05-10)

2

I used to have to define Oracle hints at one stage and the only way was to define objects with the code. They had to appear 1st, so I made the users select them as the 1st object for all queries.
I don’t know offhand of a way to automate this generically.
I wonder if you could alter any of the prm/ora/rss files that handle the syntax specifics so that you change the Select command?

MikeD :south_africa: (BOB member since 2002-06-18)