Re: Pro*C and Reserved Words (Help)

In article 9pa_at_news3.digex.net, joe_at_access5.digex.net (Joe Nardone) writes:
> Tim Boemker (tim_boemker_at_zacatecas.optimum.com) wrote:
> : In article <sza1vk7QB4VB083yn_at_medcal1.csustan.edu>
> : JCL_at_medcal1.csustan.edu (John Landers) writes:
 

> : > This may sound a little off but some legavy programs name some fields
> : > in a table as begin and end. These are date fields. The problem comes when a pro*c
> : > program tries to precompile and see the begin & end fields but thinks they are
> : > part of a PL/SQL function
 

> : In many circumstances, it's possible to quote a name. For example, I
> : can create a table with a column named uid (a reserved word) if I say
> : "uid" number... Perhaps the same approach will work with Pro*C.
>
> Yes, this works. You'll also need to do it if you have any fields named
> COUNT.
> (i.e. replace them with "COUNT").
>

If you don't use any PL/SQL blocks in your program another way to get rid of these error messages is to use the SQLCHECK=NONE precompiler option.

hope it helps,
Heike

---
---------------------------------------------------------------------
H. Twele                    twele_at_ives1.ive.uni-hannover.de
IVE
Universitaet Hannover       Tel.:(0511) 762-3454
---------------------------------------------------------------------