Top "Db2" questions

SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

What does sqlcode -302 means? Where do i get the sqlcode definitions? Please advice Thanks,

db2

How to view DB2 Table structure

How to view the table structure in DB2 database

db2

DB2 Query to retrieve all table names for a given schema

I'm just looking for a simple query to select all the table names for a given schema. For example, our …

sql db2 database-schema

show all tables in DB2 using the LIST command

This is embarrassing, but I can't seem to find a way to list the names of the tables in our …

sql db2

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

I am getting this JDBC exception. I googled it but the explanation was very abstract. DB2 SQL error: SQLCODE: -206, …

db2

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : …

database oracle db2 blob clob

DB2 Date format

I just want to format current date into yyyymmdd in DB2. I see the date formats available, but how can …

sql date db2 date-format

How to find substring inside a string (or how to grep a variable)?

I'm using BASH, and I don't know how to find a substring. It keeps failing, I've got a string (should …

linux string bash db2

Create a copy of a table within the same database DB2

Is there an easy way to copy a table to the same database of course with different name. I tried …

copy db2 aix

How to update multiple columns in single update statement in DB2

I want to update multiple columns of a table in DB2 with single Update statement. Any hint or idea will …

sql database db2 sql-update