search

Teradata / PyTd

A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
MIT License
108 stars 43 forks source link

Multiple result sets support #51

Closed FrankWangAU closed 8 years ago

FrankWangAU commented 8 years ago

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 8 years ago

Hi Team,

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

Thanks, Frank