Top "Db2" questions

Declare a variable in DB2 SQL

Does anyone know how to run the following SQL Server code in DB2? I am converting SQL Server scripts so …

tsql variables db2

In DB2 Display a table's definition

Hello everybody I am learning DB2 and would like to know how to see a table's characteristics after I create …

db2

Trying to get the average of a count resultset

I have the following SQL:(bitemp) SELECT COUNT (*) AS Count FROM Table T WHERE (T.Update_time = (SELECT MAX (B.…

sql count db2 resultset average

How to AUTO_INCREMENT in db2?

I thought this would be simple, but I can't seem to use AUTO_INCREMENT in my db2 database. I did …

db2 auto-increment

Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries …

sql database db2

DB2 SQL Convert Decimal to Character with Padded Zeros

How can I convert my DECIMAL(11) field from 12345678 to a character value of 00012345678?

sql db2

Description of columns in a DB2 table

How can we know the description of every column in a table(DB2) through SQL? My data base is DB2.

sql db2

How to split a string value based on a delimiter in DB2

How do you split a string value in DB2? For example, given the value: CHG-FFH. I want to split on …

split db2

Comparing DB2 dates

I have a DB2 DATE type field in a DB2 table. I want to select data by a date filter. …

db2

How can I find all indexes available on a table in DB2

How to find all indexes available on table in db2?

indexing db2