IBM Mainframe Forum

Hi,

I have a program wich accesses many tables, and would like to know if there is anything similar, to the SQLCA - SQL Communications Area, that I can declare and use in the COBOL program, but with information about the last table accessed by an SQL instruction? That could provide me with the name of the table.

Thanks for the help !

How about just putting the table name into a variable just as you are about to execute the query?

NicC wrote:How about just putting the table name into a variable just as you are about to execute the query?

It works sure, but it's not what I'm looking for I really want to know if db2 sql keeps that info somewhere...

Thanks for the help anyway

Well, then. Post in the DB2 section not the COBOL section.

NicC wrote:Well, then. Post in the DB2 section not the COBOL section.

I want to know how to do it, via SQL, like SQLCA, but not... But from within the COBOL source code of the program, so I posted it here.

Thanks

Well, I gave you a COBOL answer but you say you want a DB2 answer - maybe accessed using COBOL but that is a by-the-bye as it could be accessed by any language that has an interface to DB2. You want to know if DB2 keeps such a thing - probably not - but if it did the answer is a DB2 answer so it is more relevant to that section so that anyone wanting that information, but using a different language, should be able to find it.

NicC wrote:Well, I gave you a COBOL answer but you say you want a DB2 answer - maybe accessed using COBOL but that is a by-the-bye as it could be accessed by any language that has an interface to DB2. You want to know if DB2 keeps such a thing - probably not - but if it did the answer is a DB2 answer so it is more relevant to that section so that anyone wanting that information, but using a different language, should be able to find it.

Thanks for the help !

bump. . .