I created this generator using the DSQL through the connection as
follows

create generator RCRECEIPTNO_GEN (this is just like the example in
the data definition guide)

I have tried different case such as RCReceiptNo_GEN or
rcreceiptno_gen and any other cominbination I can think of. When I
look at the list of generators it shows as all caps.

I am saving the value of the generator into a field in my setup
record and I set that field up as a numeric because the data
definition guide says the column that holds the generated value must
be defined as numeric or decimal.

How do you query the system tables? Or where can I look for
directions on how to query the system tables?

As always thanks for the great support.

Kristy