如何检查当db2查询返回0条记录

Question

我正在从python3.x执行一个db2查询。在执行查询之前，我要提取python字符串，以便在squirrel中进行查询和检查。查询正在执行并返回结果。这是我的问题

select distinct Cno  from df_J_CUST where ID in ('95427','95405','95429') and  GRP not in ('K915B','K9F0S','K9M4U','K9QBJ','K0012AS','K0015R5','K001877','K001H1N','K95U5','K9GEX','K9M6L','K9YGP','K00159S','K00184E','K226QMF') and  CODE in ('1PY2','5AR1','9U1Y') and TYPE = 'L'

但是在使用以下代码从python执行它时

    import pandasql as pdsql
    str1 = """select distinct Cno  from df_J_CUST where %s"""
    str="ID in ('95427','95405','95429') and GRP not in ('K915B','K9F0S','K9M4U','K9QBJ','K0012AS','K0015R5','K00187‌​7','K001H1N','K95U5'‌​,'K9GEX','K9M6L','K9‌​YGP','K00159S','K001‌​84E','K226QMF') and CODE in ('1PY2','5AR1','9U1Y') and TYPE = 'L'"
    str2 = str1%(str)
    print("str2=", str2)
    pysql = lambda q: pdsql.sqldf(q, globals())
    df1 = pysql(str2)

我没有看到任何错误消息，但查询返回0条记录。你能告诉我要检查什么才能发现问题吗？你知道吗