i am at a loss and this is only forum that i know of.
i am using AcuXDBC (genesis odbc) and am needing to gather output of a insert statement.
i have tried to use insert into tablea values ('record one') @output record_number
but i get a syntax error no matter what i try regarding the word output.
I ask for help from the development side and they pushed it to their community forum which no one had an answer, so that is why i am on here looking for anything to try with regards to an ODBC commands. Reason for this is that the file in question is what cobol calls a relative format. a column record_number kind of works like an identity column BUT is not part of the table, just implied.
i can read this file select * from tablea where record_number =50; but if you look at the design of table you get one column column_a char(64);