I'm using DB2 to develop an app, I have the tables products, price and cost, these tables store products data at this way: As you can see, for this example
we're migrating our IBM i System from OS 6.0 to 7.4; we're testing all the applications which somehow connect and read/write data to it and we found a weird beh
Is there a way to build a DB2 query to search a combination of strings in a field? I am trying to do this: select ITEM, ITEM_DESC where instr(ITEM_DESC,>par
Like picture above Are there some options to control the encoding? (switch between UTF8 and GBK?) I found a DEFAULT_CHARSET property(the value is utf8) in io.v
I have recently migrated some scheduled jobs from a Windows Server 2012 virtual server to a new Windows Server 2019 virtual server, and have noticed some notabl
I'm executing a query on IBM DB2 server with ibm_db_dbi. Here is my query: connection = ibm_db_dbi.connect(hostSettings, '', '') ret = pd.read_sql(query, connec
I want to find the data which is having positive number . How many records have the positive values. find out the ' . ' in the data We are using db2 database h
Hi I am trying to call an as400 stored procedure using OleDB. Could you please post an example of how to do it cause I've been following some tutorials but not
Is there a way to find the number of days in a month in DB2. For example I have a datetime field which I display as Jan-2020, Feb-2020 and so on. Based on this
I'm having trouble with an error that says: UDA-SQL-0144 An arithmetic exception was detected.[IBM][CLI Driver][DB2/NT64] SQL20448N "1993" cannot be interprete
I have a dynamic sql file in which name of TBCREATOR changes as given in a parameter. I use a simple python script to change the TBCREATOR=<variable here>
How to get/change db2 database owner?
The previous DB2 Express-C versions were working fine over the years, but the basic commands not running on no cost Db2 Community Edition 11.5.5 (latest) . afte
I am using Spring batch framework to read from db2 and getting error. Please note that same is working fine with Mysql. When using db2 its making entry in meta
I would like to display 71% in my RESULTS field. I have rounded the decimal percentage first (it was 71.04), now I want to turn it into a string so that I can c
When I connect to a DB2 database via ODBC using the recently released R 4.2.0 the database appears to have no objects. Connecting to AWS has no such issues, and
This is what I am trying to do: SELECT id, name FROM users WHERE isActive=true (AND CASE WHEN {param} != null THEN name={param} ELSE null E
I would like to have the list of stored procedure created in a certain database. I tried db2 "display procedure MyDb.*" But I get error DB21034E The comman
%sql select Name_of_School, Safety_Score from SCHOOLS where \ Safety_Score= (select MAX(Safety_Score) from SCHOOLS) i am trying to execute this query i got t
I am connected to IBM DB2 database with java but data is stored as binary format in database so when I fetch any value it comes as binary or hexdecimal format.