Sorry for the DB2/Java cross post, I was not sure who could best answer my question)
Hi I am having a problem getting db tables from a DB2 mainframe over ODBC (I have to use ODBC).
I connect with the below code and write out the table and column names rather than getting the correct table and column names for this schema (eg Customer.name, Customer-Age) I get the below information.
V53_BMCLGRNX.LGRDBID - CHARacter
V53_BMCLGRNX.LGRPSID - CHARacter
V53_BMCLGRNX.LGRUCDT - CHARacter
V53_BMCLGRNX.LGRUCTM - CHARacter
V53_BMCLGRNX.LGRSRBA - CHARacter
V53_BMCLGRNX.LGRSPBA - CHARacter
V53_BMCLGRNX.LGRPART - SMALLINT
V53_BMCLGRNX.LGRSLRSN - CHARacter
V53_BMCLGRNX.LGRELRSN - CHARacter
V53_BMCLGRNX.LGRMEMBER - CHARacter
I get loads of these tables.
Can some one tell me what these tables are, should I asking for different table types?