The DB2 default value for BLOBS is 1 MB. The maximum size of BLOBs are 2GB.
What problems are there in creating all BLOB columns with the max size of 2GB?
I have a few Oracle SQL statements that I need to run in ISeries DB2. I'm not having much sucess.
Here is the idea. make a backup of Envelope table DatabaseA, empty out the Envelope Databa...
Hello,
I've two tables, one called westpac_data and the other called pol_policy. The linking field between those two tables is cardnbr on the westpac_data table and plc_bill_acctnum on the...
I get the following error on a SUSE Linux Box 8.00
Db2 V8.1
Websphere Express 5.02
linux4:/opt/IBM/db2/V8.1/bin # ./db2 start
SQL10007N Message "-1390" could not be retrieved. Reason...
Hi.
I am trying to switch from an Oracle 8i to DB2 database and I need to update the Java code to support the DB2 CLOB.
Here is a sample of the existing code that I am using to write a...
[IBM iSeries running AS400]
I created the following stored procedure:
=======
CREATE PROCEDURE TBLNAME.proc_test (IN p_custnum VARCHAR(8),
...
Hello,
how to grant a user a permission for a certain database in db2?
Thanks very much for your kind attention,
lilyyan
I have installed DB2 v 8.1 on my system. When I try to execute the command "db2start" from the command prompt, I get the following error:
-----------------------------------------------------...
I am able to import csv's into a db2 database using:
db2 connect to DB01user USERNAME using PASSWORD
db2 -tvf C:\files\create_tables.sql
However this ignores the column header and impor...
Well the question looks complicated actually is it possible to have a select within a case which is a part of select thats my question.
Select field a, field b
CASE ...
Hi Experts,
I'm struggling with something that I thought would be very easy! I'm trying to find a simple / free ODBC driver for IBM DB2. I have a Windows 2003 machine with DB2 on a networ...
I've tried several commands to do a describe for a table. I can't find one that works. I've tried using DESCRIBE TABLE schema.tablename and it doesn't work. What I'm I missing? This should...
I'm configuring online backup for my DB2 using Tivoli Storage Manager. Following DB2 and TSM document, I think I got it right.
In my testing the backup(online) and restore, this is what I di...
I coded a one time script as follows in Command Editor : ( do not want to make it a stored procedure)
*******************************************************************
begin
DECLARE xxid ...
1) We are using DB2 8.0.1 Express on Red Hat Linux 9
2) SELECT MAX(POINT_SEQ) + 1 FROM SFUCHECK WHERE POINT_DATE = CURRENT DATE FOR UPDATE WITH RS; is not working due to one of the many SELEC...
I am a newbie DB2 DBA. My understandings about how Db2 communicates using the TCP port is using port 50000. It seems to be ok from my workstation (WinXP) but for some reasons another machine...
Greetings,
I noticed on my RHES4 linux system running DB2 8.2 that there are 20 db2sysc processes running, and I also noticed there are 20 users running a desktop application on their PCs t...
I need some help with using the DB2 current date in my select where clause below for my VB program. I know this is not the correct format. Can someone please help.
oCant.Append "...
Hi,
I'm using DB2 UDB V8.2 in AIX 5.3
1. Is there a command to manually clear Transaction log entries?? If so, what is it.
2. When I take Offline Backup of the database, does it not c...
Hi Experts,
I need to make a NULL Column to NOT NULL Column in db2. Iam using IBM DB2 version IBM DB2 v8.1.7.445.
I have writted query
ALTER TABLE ORDER_QUEUE_HISTORY ALTER COLUMN QUEU...
I want to create a select clause that have a column always has null value. Please show me how to do that with DB2.
Ex:
SELECT NULL AS nullColumn, * FROM TBL_A
Thanks so much!
How to create a emtyp file in DB2, i am trying to truncate the table using load import form /dev/null of del replace schema.tablename, but it keeps saying path not found or no table to read.
...
I'm confused. I've now moved into VisualBasic.NET and I'm trying to use IBM.Data.DB2.iSeries.iDB2Connection.
Does IBM.Data.DB2.iSeries.iDB2Connection use ODBC?
Help file titled: "IBM DB2 U...
Using SQL stored procedue on iSeries how can I return the identity value that was assigned after an insert using a stored procedure?
I have an example of a stored procedure on SQL server, b...
My select statement returns multiple rows as below
ST_CD
======
PA
NY
NJ
CA
But need to convert those rows into a string column
ST_CD
=======
PA,NY,NJ,CA
can you guys tell me...
