Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I am getting an error, below is the sample code. Any help is appreciated.
- import teradata
- import xlrd
- udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0",
- logConsole=False)
- session = udaExec.connect(method="odbc", system="abc",
- username="abc", password="xyz",authentication="abc",driver="Teradata");
- loc = ("//")
- wb = xlrd.open_workbook(loc)
- wbsheet=wb.sheet_by_name("Queries")
- total_rows=wbsheet.nrows
- print(total_rows)
- query_list=[]
- for row1 in range(0,total_rows):
- exceldata = wbsheet.row(row1)
- query_list.append(exceldata)
- for row2 in query_list:
- session.execute(row2)
Add Comment
Please, Sign In to add comment