Hi

I'm running on a program as to migrate multiple tables to one table

the program seems worked on informix environment but not in postgress

Im getting the following error when running the program on postgress


| pgs.c:01466(3) : Nat stmt1 = declare cu4 cursor for
| pgs.c:01472(2) : Could not prepare the statement.
| pgs.c:01473(2) : ERROR: syntax error at end of input
LINE 1: declare cu4 cursor for
^

| pgs.c:00321(3) : Diagnostic info:
| pgs.c:00322(3) : SQL State: 42601
| pgs.c:00323(3) : Message : syntax error at end of input
| pgs.c:01801(2) : Could not execute statement with result set.
| sqlcode : -201
| sqlstate : 42601
| sqlerrd2 : -1
| sql message : syntax error at end of input
| sql msg param :
| sql driver : ident='dbmpgs83x'

Program stopped at 'db_upg77R060.4gl', line number 289.
SQL statement error number -201 (-1).

PREPARE q_cbdbaudit_tables FROM p_query
DECLARE c_cbdbaudit_tables CURSOR FOR q_cbdbaudit_tables

FOREACH c_cbdbaudit_tables INTO p_audittable<---line number 289
IF DOWNSHIFT(p_audittable) NOT MATCHES "cb_db[0-9][0-9][0-9][0-9][a-z][a-z]" THEN
CONTINUE FOREACH
END IF


need your help on this.thanks