pyodbc 从带有 DB2 的存储过程中返回多个游标 [英] pyodbc return multiple cursors from stored procedure with DB2

问题描述

我有一个从 db2 数据库调用存储过程的 python 程序.我正在使用 results = cursor.fetchall() 来处理我的存储过程的结果.但是，我的存储过程返回两个游标.results 只包含第一个.我需要一种方法来遍历尽可能多的游标.我希望 fetchmany() 会是我的答案，但事实并非如此.

I have a python program that calls a stored procedure from db2 database. I am using results = cursor.fetchall() to process the results of my stored procedure. However, my stored procedure returns two cursors. results only contains the first one. I need a way to loop through as many cursors as I want. I was hoping fetchmany() would be my answer but it is not.

我需要能够处理多个结果集，因为我正在编写的程序只能调用一个存储过程.回去要花很多时间才能打电话给两个.除了这些东西之一，我需要让 10 个游标返回.一切都是动态的，因此应用程序不知道它正在运行什么程序，它只是获取数据并将其吐入不知道含义的 Excel 中.我需要一个游标用于数据，另一个游标用于不同类型的计数和总计.

I need to be able to do multiple result sets as the program I am writing can only call one stored procedure. It would take a lot to go back and make it to be able to call two. Besides with one of these things I need to make 10 cursors return. Everything is dynamic, so the application doesn't know what procedure it is running, it just gets the data and spits it into excel not knowing the meaning. I need one cursor for the data, and the other cursors for different types of counts and totals.

我正在寻找一个内置函数来执行此操作，或者甚至可能是一个不同的库，因为我已经完成了我的谷歌搜索，看起来 pyodbc 不为 DB2 执行此操作.DB2 是必需的.

I am looking for a built in function to do this, or maybe even a different library because I have done my share of googling and it looks like pyodbc does not do this for DB2. DB2 is a requirement.

推荐答案

使用游标的nextset()方法:https://github.com/mkleehammer/pyodbc/wiki/Cursor#nextset

示例代码:

# fetch rows from first set
rows = cursor.fetchall()    
# process first set rows here

# advance to next result set
while (cursor.nextset()):    
    # fetch rows from next set, discarding first
    rows = cursor.fetchall()    
    # process next set rows here

如果有其他结果集可用，

nextset() 将返回 True，随后的游标提取方法将返回下一组中的行.如果没有其他可用的集合，则该方法返回 None.

nextset() will return True if additional result sets are available, and subsequent cursor fetch methods will return rows from the next set. The method returns None if no additional sets are available.

这篇关于pyodbc 从带有 DB2 的存储过程中返回多个游标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！