Teradata/PyTd

Multiple result sets support

FrankWangAU opened this issue · 1 comments

Hi Team,

Great work. It makes teradata development in Python much more easier and quicker.

I think ODBC does support return multiple result sets from one single SQL request. E.g. "show qualified select * from a_view;", it should return view DDL and all referenced tables and views DDLs as multiple result sets.

I tried to run above example in current version of PyTd, it only returned last line of first result set.

Any plan to add this feature in near future?

Thanks,
Frank

Hi Team,

I just found it does support multiple result sets, just need to call cursor.nextset().
I close this issue now.

Thanks,
Frank