Guest User

Untitled

a guest
May 22nd, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. import ibm_db
  2.  
  3. c1 = ibm_db.connect('*LOCAL','userid','password')
  4. sql = """INSERT INTO TEMPLIB.TEMPPF (TYPE, DRPARTY, CRPARTY,
  5. AMOUNT,ACNUM, DESCRIPT)
  6. VALUES('%s', '%s', '%s', '%s', '%s', '%s'),
  7. %(self.type, self.debitparty, self.creditparty, self.amount,
  8. self.craccountnumber, self.description) with NC
  9. """
  10.  
  11. stmt = ibm_db.exec_immediate(c1, sql )
  12.  
  13. sql = "select * from TEMPLIB.TEMPPF"
Add Comment
Please, Sign In to add comment