python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Rename the data (not the columns) that the query (sql) brings without affecting the database (DB2)
The question is the following, I need to rename the data when it is brought in the query without affecting the database, for example, when the name of a column is changed using AS and this does not af...
Erik Martinez Barraza
Votes: 0
Answers: 1
Need to get Average count
I would like to get average of product=A that a client have. Say inner select return 1,2,1,4,4,4 for 6 clients
I would like to see result as 4 which means the avg product count a client can have is 4
...
Darlson
Votes: 0
Answers: 1
Tricky query in DB2
I have a DB2 table with Users and another one with Groups.
This both tables are connected by ID.
At the table Groups I got many lines for a single user, like:
ID
Group
Jhonn
Admin
Jhonn
Comm...
Vitor Larini
Votes: 0
Answers: 3
Performance issue with DB2 on high latency network after move to Azure over ExpressRoute
Recently moved some VM's to Azure. We now have significantly higher latency to on-prem where we load data from DB2. Around 25ms over the ExpressRoute vs 1-2ms on-prem->on-prem.
We are now suffering...
Robert Petersson
Votes: 0
Answers: 0