SQR Insert

["Janecek, Kevin J." <JANECKJ@AUS0000P01.AUST.TDPRS.STATE.TX.US>]

Hi guys,

I just subscribed to this user group and already have found some useful
information.  I have a question about SQR.

I currently have an SQR program which reads several tables and provides
detailed information along with sub-totals and totals.  Now, I want to take
these sub-totals and totals and insert them into a Statistics database
table.

I cant seem to get my Insert statement to work....any ideas?

My current statement is:
BEGIN-SQL

   INSERT INTO STAT_TABLE  (CD_STAT_PP_CODE,
                               CD_STAT_PP_REG,
                               CD_STAT_PP_UNIT,
                               NBR_STAT_PP_COUNT)
                values        ($stat_code,
                               $stat_reg,
                               $stat_unit,
                               $stat_count)

END-SQL

Thanks in advance,
Kevin