DB2
in [SQL]
|
SQL0818N after V7 -> V8 migration. Hello, Linux DB2 V7 FP13 kernel 2.4. Parts of our application login run on C++ procedures that are working fine. I have taken an offline backup and restored it to a Linux V8 kernel 2.6 FP 14 server. The RESTORE finished without any problem. Now when I try to call the same procedure it returns SQL0818N (Time... 24 Mar 2006 11:01
DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031 Hi, we are using db2 v8.2 on windows. Have a error while run the application, DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH20A 0X5359534C564C3031 normally i saw the error for package SYSLH203 , but never know what is for SYSLH20A, can someone tell me what could it be? tks ... 21 Mar 2006 13:09
SQL1031N error help Hi, I'm working on DB2 UDB 8.1 for AIX 5.3. I tried to do either db2 drop database mydb or connect to mydb command after I restored mydb from an online backup image using redirected restore. I got the following error: SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=580... 10 Mar 2006 10:15
Convert DECIMAL to DATE I have a table with some audit date and time columns. Problem is the developer who stored the data left them as DECIMAL type instead of DATE and TIME. Is there a way I can convert the DECIMAL type to DATE or TIME? The column data is in the date form YYYYMMDD (i.e. 20060308 = March 8 2006). I want to get the data... 9 Mar 2006 15:32
How to do...well...anything...in DB2 SQL i've been thrown into a pit with DB2 and have to start writing things such as tables, indexes, stored procedures, triggers, etc. The online reference is only so helpful. The two pdf manuals are only so helpful. Googling is only so helpful. So let's start with some simple SQL constructs, that i know so very wel... 7 Apr 2006 19:57
SQL0901N Error. Hi , I received this error message while executing an application SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "column number out of range".) SQLSTATE=58004 From the error message in error help ..I can't find any thing mean... 27 Feb 2006 06:57
Simple Insert using Case statement Hi, I have a table with 2 columns ** CREATE TABLE test (emp_num DECIMAL(7) NOT NULL,emp_name CHAR(10) NOT NULL) and i have inserted a number of records. ** Now, I want to insert a new record (3232,'Raindeer') based on the condition that the emp_num 3232 doesnt exist. SELECT * , CASE ... 17 Feb 2006 02:51
Failover problems 2 servers with solaris,veritas cluster and DB2 UDB ESE v8.1 with fixp10. ON the primary db2 server did I create 2 db2 instances and the admin instance. It is possible to start both db2 instances and the db2 admin server on the primary server but ...failover works only for the 2 db2 instances and not for the admin s... 25 Jan 2006 19:01
DB2 Connection String Problem while DB2 connection OPEN while opening a new DB2 connection using ODBC connection i get the following error message ERROR [08004] [IBM][CLI Driver] SQL30061N The database alias or database name \"DATABASENAME \" was not found at the remote node. SQLSTATE=08004\r\n\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver'... 19 Jan 2006 00:20
Concatenation Is it not valid to use concatenation in a WHERE ... LIKE clause? SELECT iam0.g_itemId FROM g2_ItemAttributesMap AS iam0, g2_ItemAttributesMap AS iam1 WHERE iam1.g_parentSequence LIKE iam0.g_parentSequence || iam0.g_itemId || '/%' SQL0440N No authorized routine named "||" of type "FUNCTION... 11 Nov 2005 23:25 |