iframe-proxy | Sunbelt Computer Software

29 lines (25 loc) · 1.04 KB

# Copyright 2021 by Teradata Corporation. All rights reserved.
# This sample program demonstrates how to display the output from a show command.
# The show command output includes embedded carriage returns as line terminators,
# which typically must be changed to newlines in order to display properly.
# The show command output may include multiple result sets, and the cursor nextset
# function must be called to advance to subsequent result sets.
import teradatasql
def ShowCommand (cur, s):
    print ("-- " + s)
    cur.execute (s)
    while True:
        print ("-- result set {}".format (n))
        rows = cur.fetchall ()
        for row in rows:
            print ("".join ([ str (col).replace ("\r", "\n") for col in row ]))
        if cur.nextset ():
        else:
            break
with teradatasql.connect (host="whomooz", user="guest", password="please") as con:
    with con.cursor () as cur:
        ShowCommand (cur, "show view DBC.DBCInfo")
        print ()
        ShowCommand (cur, "show select * from DBC.DBCInfo")

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

ShowCommand.py

Latest commit

History

ShowCommand.py

File metadata and controls