hello every1,
in my table, there is a column called submittime, the value for this column is the current time when the row was created.
my questions is, after certain time, say one year,...
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...
I am getting the error:
[IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following "".
I am developing in VB.NET 2005.
When using the IBM DB2 Drivers through SYSTEM.DA...
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...
i am trying to run a select count(*) from dim_order and its giving me reason code 3 error can u plz advise why and aht should i do to rectify it?
SQL0668N Operation not allowed for reason co...
Hi all,
do you know where I can find free on line tutorial about As400 and Db2?
I need a very basic level.
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?
What is the command in DB2 to move an index from tablespaceA to tablespaceB?
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...
In DB2 i have a data field char(20)
when i execute the following SQL
select fieldname from tablename
1234
abc12ab123
12ab23c23d
ab1234cd
cd1234
42345
67890
when i do select max(fie...
Hello,
how to grant a user a permission for a certain database in db2?
Thanks very much for your kind attention,
lilyyan
I have a simple SQL that I want to explain using UDB Control Center command editor explain feature. Regardless of what environment that I tried (system test or product or UAT), I get error
"...
hi everbody
before some months i installed the DB2 9 on the windows server 2003. Initially it was working properly. But after that i have not started it for so many days.But today when ...
Hi,
How do i do string join in CONCAT statement i.e
CONCAT(query, STRNAME + 'test 123');
is this correct?
I keep getting the following error:
[IBM][CLI Driver] SL1032N No start database manager command was issued. SQLSTATE=57019
I tried starting the database, and I still get the above error.
...
[IBM iSeries running AS400]
I created the following stored procedure:
=======
CREATE PROCEDURE TBLNAME.proc_test (IN p_custnum VARCHAR(8),
...
I'm using DB2 version 7.1 running on United Linux 2.4.19, and I'm experiencing a lot of table locks instead of row locks. I'm using DB2 cli in C++ to access the database. Is there any configur...
I'm new to db2. I have the free version of it and what I'm trying to do is create a table that has auto incrementing row in it for the primary key.
Also do any one have any good sites for ...
Hi
I have a db2 table having timestamp as column and when data gets inserted to this table, I see the time as GMT and not EST, is there way to change that?
Hi all,
I have a need to copy z/OS data and load into DB2 UDB on Linux and Windows Servers. What are the options that I have to accomplish this requirement. Please be kind enough to describe ...
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...
I have a table and i need to have DATE and AMOUNT in it. (my manager wants it)
I changed the field to CHAR(8) and first tried to insert the date like this:
cast(SDLPDT as char(8)) AS LastP...
I am using ODBC driver to connect as/400 with sql server 2005. How to get the data from as/400 into SQL server 2005?
Hi Guys
I have this query which diplays all the values correctly in db2 command center. But when I run this query from my java code it is giving me the following data for one of the column...
My DB2 db have codepage 1208 and codeset UTF-8. Could I change for codepage 850 and codeset ISO8859-1?
