Alex Rivera | Logout

Questions tagged db2

30 questions

Sort by: Newest Votes Active
9
votes
1
answers

How can I limit the display length of a field returned in DB2 CLP (z/OS)?

db2 format zos
asked 2013-04-05T15:39:16.203
15
votes
1
answers

ERRORCODE=-4461, SQLSTATE=42815 in DB2

java sql db2
asked 2012-07-10T10:10:55.603
41
votes
7
answers

Select Query by Pair of fields using an in clause

sql database db2 in-clause
asked 2012-05-23T18:38:51.330
19
votes
7
answers

DB2- How to check if varchar field value has integers

sql db2
asked 2012-05-07T21:54:08.377
22
votes
3
answers

DB2 database in Oracle SQL developer

database oracle-database db2 mainframe oracle-sqldeveloper
asked 2012-04-20T17:09:55.617
19
votes
3
answers

Way to decrease column length in DB2

sql database db2
asked 2012-03-06T06:40:52.343
15
votes
5
answers

Calculating how many days are between two dates in DB2?

sql database db2
asked 2012-03-02T18:40:05.533
19
votes
4
answers

Is there any opensource DB2 client?

db2
asked 2011-12-22T07:40:32.080
16
votes
9
answers

Connect DB2 with Java

java db2
asked 2011-12-16T06:45:08.350
13
votes
5
answers

db2: update multiple rows and field with a select on a different table

sql db2
asked 2011-12-12T17:21:30.093
14
votes
5
answers

SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2

c# .net db2
asked 2011-09-20T11:27:19.243
14
votes
2
answers

How to use NOT EXISTS with COMPOSITE KEYS in SQL for inserting data from POJO

java sql database db2 composite-key
asked 2011-08-22T12:08:36.497
27
votes
4
answers

Query validation using C#

c# sql sql-server db2
asked 2011-06-09T03:39:09.833
9
votes
5
answers

Suggestions for a good IDE for DB2

db2
asked 2011-01-05T15:16:55.360
56
votes
8
answers

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

linux string bash db2
asked 2010-12-17T04:38:35.953
101
votes
10
answers

Equivalent of LIMIT for DB2

db2 limit ibm-midrange
asked 2010-10-07T19:28:04.063
9
votes
1
answers

Inserting a date into db2

sql database db2
asked 2010-10-04T06:10:16.533
10
votes
2
answers

How to efficiently remove all rows from a table in DB2

sql performance db2
asked 2010-09-01T09:11:12.277
16
votes
1
answers

Connect to IBM DB2 with .Net using only .dll reference

.net database db2 ibm-midrange
asked 2010-07-28T21:07:30.670
54
votes
22
answers

How to view DB2 Table structure

db2
asked 2010-06-04T10:15:28.467
20
votes
2
answers

How can I set the current schema for DB2 using Hibernate/JDBC?

jdbc schema db2
asked 2010-06-01T21:09:00.317
11
votes
2
answers

What is the Varchar(Max) equivalent for DB2?

sql sql-server db2 varchar
asked 2010-06-01T12:21:37.480
17
votes
3
answers

How to call a stored procedure in IBM System i Access for Windows GUI Tool

stored-procedures db2 ibm-midrange
asked 2010-01-22T17:13:26.597
9
votes
4
answers

Db2 connection problem with java

java jdbc db2 db2-luw
asked 2009-10-19T13:33:14.170
10
votes
9
answers

How do I LIMIT the number of rows in a DELETE with DB2?

sql db2 limit
asked 2009-06-30T10:40:31.157
27
votes
6
answers

Exporting result of select statement to CSV format in DB2

csv db2 export
asked 2009-06-29T13:49:35.737
21
votes
5
answers

SQL query of multi-member file on AS400

sql jdbc db2 ibm-midrange jt400
asked 2008-12-06T17:27:43.210
9
votes
9
answers

SQL - How do you compare a CLOB

sql triggers db2 compare clob
asked 2008-09-21T09:04:24.107
20
votes
8
answers

IsNull function in DB2 SQL?

sql null db2
asked 2008-09-15T17:47:43.333
37
votes
9
answers

Connect PHP to IBM i (AS/400)

php database odbc db2 ibm-midrange
asked 2008-08-03T14:03:28.830