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 have 4 table in database db2, I Want to know cycle time in table progress dispo
With the no dispo is key.
A. Table dispo header1
DISHD00F {NO_DISPO, NO_MOV}
{A12345, 100}
...
I keep getting SQL 57011(log full) and 54001 (stmtheap full) errors. We are running multiple java apps that connect to the database. We are using DB2 Express-c 9.5. Let me know what other i...
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...
I am configuring a tool that, at a particular point, executes a SQL statement on a DB. It is that generic ... my SQL statement can be anything.
I need a SQL statement that will put the cur...
when i am trying to crate nick name (using federated system creating nickname from as400 (os/400) to iDB2/NT 8.2.1f advise its urgent
SQLSTATE: 22003
Explanation: The numeric value recei...
Hi,
Can anyone help me how to come out of 30 bytes column length limation in DB2
some one suggested me to use DB2 UDB V8.0, but not sure.
Thanks,
Hi,
Does Db2 9.1 on Z/ OS support functions with Recursive SQL?
I am not able to RETURN WITH Clause while creating a function but I was able to do so in DB2 on LUW.
I dont understand if...
Hi
I have in db2 (ver 8.2) executing script produces the following results from select statements
Result1 Type1 Result2 Type2 Result3 Type3
100 Atype 200 Btype Null ...
We are in the process of optimizing a lot of SQL queries running against a DB2 database. Another developer found a tool, I don't know what it was, and it suggests using COALESCE in a lot of p...
wht command should i give to turn it off
-c Auto-Commit ON
its db2 8.1.2 /nt
thanks
bobby
Hello all,
Background: I have a Vista-64-bit Laptop, a wireless/DSL setup for internet access, VMware with four guest OS. The solution that I am looking for is to be able to catalog
remote...
I have this sql statement which is not working, can u please explain why?
update table a set col1_timestamp=
(select max(b.col_timestamp) from a,b
where a.col1=b.col2
and
a.col1='A'
and...
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
"...
Hello,
I would like to format output of a simple query (i.e., a SELECT statement) in DB2.
By default, the CLP prints full width of all columns, even if most of the content is blank (whit...
I found strange things when using timestamp funtion in writing a query for db2 sql that had the following clause in the sql statement
AND timestamp('2009-06-01','00:00:00') <= startdatetim...
Hi,
I need to know whether it is possible to create a view in DB2 using SQL commands?
Basically in DB2 a field is defined as say char 10. However, if the value in the field is say 3 charac...
Hi,
I need to write a stored procedure for locating the non-ascii characters and replacing them with ascii characters. Could anyone help on this? We have DB2 V9.1 and AIX in our system.
Tha...
Hi :
I am trying to get the query to not timeout. The query returns a result set which is used to display data in the grid. I have been told to set the SQL_ATTR_LOGIN_TIMEOUT = 0 for the...
Hi everybody, I am a new one. I am doing a porject on network database. Just got stuck on the problem of double quote.
I want to insert the sentence:
<b>it is as good as "Wonderfulland"</b>...
Could you please let me know the equivalent of SET ROWCOUNT in DB2?
Hi,
How do i do string join in CONCAT statement i.e
CONCAT(query, STRNAME + 'test 123');
is this correct?
This is in continuation of other posts that I had for db2 executing dynamic query..
I have a situation where I get insert statement query as a column value in db2 and I am executing the inser...
hi,
which table is locked i can see anyt there ??
get snapshot for locks on pilot
Database Lock Snapshot
Database name = PILOT
Database path...
I am trying to connect to DB2 Database from a VBScript. The DB2 is installed on my windows 2000 machine that is where I am developing this VBScript. The following is the VBScript along with ...
