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
