club-seiden/-ibmi_netstat_py

[OLD VERSION] Python script for IBM i that provides NETSTAT information (see readme for current location)

-ibmi_netstat_py's Issues

Add exception handing to connection

Add try/except logic to catch a failed database connection.

Allow omission of user/password on db connection

With the latest version of the ibm_db Python adapter you can now omit the user/password and it will run under the profile that is invoking the script. Below is a sample script. Note the use of None.

Btw, I just got this working on Litmis Spaces if anyone wants to take a swing at it and doesn't yet have the latest PTFs on their machine.

import ibm_db
db_name = '*LOCAL'
schema = '<insert Schema>'
username = None
password = None
try:
  conn = ibm_db.connect(db_name, username, password)
except:
  print("no connection:", ibm_db.conn_errormsg())
if conn:
  result_set = ibm_db.exec_immediate(conn, "SET SCHEMA " + schema)
  result_set = ibm_db.exec_immediate(conn, "CREATE TABLE CUSTOMER ( CUSNUM NUMERIC(6, 0), LSTNAM VARCHAR(50) )")
  result_set = ibm_db.exec_immediate(conn, "INSERT INTO CUSTOMER VALUES(123,'Smith')")
  result_set = ibm_db.exec_immediate(conn, "SELECT * FROM CUSTOMER")
  ibm_db.fetch_row(result_set)
  print(ibm_db.result(result_set, 0))
  print(ibm_db.result(result_set, 1))
  ibm_db.close(conn)
else:
  print ('connection failed')

Supply database name and credentials with variables

Instead of:
conn = ibm_db.connect('dbname', 'username', 'password', {})
set and pass in variables, which will make the example easier to understand and modify:
conn = ibm_db.connect(db_name, username, password, {})