SO I am using ibm_db library for fetch necessary information. Now I want to get the full table creation script along with index and all. I can see there is one db2look command to generate the same Is there an equivalent thing in ibm_db? Answer No, there is not an exact equivalent in the python ibm_db for the db2look tool.
Tag: db2
How to check status of long lasting ibm_db connection in python
I’m developing and API that reads data from DB2 and returns corresponding result (using Flask on Python). Initially I had connection open on each API call but since number of connections per second is growing I thought it’s better to open DB connection once and re-open it only if it closed/failed for any reason. And that is exactly what I
Create dynamically insert into table in Python
i am trying to read from some db2 schema all the tables and for those tables to get their columns so i can create dynamically insert into statement My data is stored in a list in this format: where tableName is the name of the table in my schema. So far i read from db catalog all tables and their