Multiple result sets support
FrankWangAU opened this issue · 1 comments
FrankWangAU commented
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
FrankWangAU commented
Hi Team,
I just found it does support multiple result sets, just need to call cursor.nextset().
I close this issue now.
Thanks,
Frank