Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Pip install Teradata
- import teradata
- import pyodbc
- import sys
- udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0",
- logConsole=False)
- session = udaExec.connect(method="odbc", dsn="prod32",
- username="PRODRUN", password="PRODRUN");
- i = 0
- REJECTED = 'R';
- f = file("output.txt","w");sys.stdout=f
- cursor = session.cursor();
- ff_remaining = 0;
- cnt = cursor.execute("SELECT SEQ_NO,FRQFBKDC,PNR_RELOC FROM ttemp.ffremaining ORDER BY 1,2,3 ").rowcount;
- rows = cursor.execute("SELECT SEQ_NO,FRQFBKDC,PNR_RELOC FROM ttemp.ffremaining ORDER BY 1,2,3 ").fetchall();
- for i in range(cnt):
- ff_remaining = cursor.execute("select count(*) as coun from ttemp.ffretroq_paxoff where seq_no=? and status <> ?",(rows[i].seq_no,REJECTED)).fetchall();
- print ff_remaining[0].coun, rows[i].seq_no, REJECTED;
- import pyodbc
- user = 'user'
- pasw = 'pass'
- host = 'host'
- connection = pyodbc.connect('DRIVER=Teradata;DBCNAME=' + host +';UID=' + user + ';PWD=' + pasw +';QUIETMODE=YES', autocommit=True,unicode_results=True)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement