DB2

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

Building Simple SQL Stored Procedure
I have just started working on DB2 which the syntax is a lot different. I am trying to create a SQL stored procedure for generating reports. I want to use temporary database which in this example it is trult not needed but due to past experience it is key to developing good reports for cliebt/server application. ... 20 Mar 2006 14:14

load from cursor
Hi, We have a process ( a stored proc) that exports data ( about 10 million records) from a huge table,t1 and loads it into another huge table t2. The export runs for 3 hours everyday because of a very complex sql... My question is can we load from the table directly instead of exporting the data and loading... 13 Mar 2006 13:25

Concatenating rows ?
I've got a table full of search terms, one search term per row. ID CATEGORYID SEARCH_TERM 1 1 cat 2 1 mat 3 2 sat .... I need to get the search terms concatenated - is there an easy way to achieve this? If I knew how many search terms there were, I could join the table to itself: SELECT a.sea... 15 Mar 2006 10:10

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

Generating SQL Scripts from SPUFI
Hi - I would be grateful for advice regarding the following. Via SPUFI, I am using an SQL member to generate further SQL Statements. Unfortunately, the generating output SQL statements are longer than 80 bytes in length. SPUFU will only accept statements that are <= 80 bytes. Therefore, do you know of an a... 9 Mar 2006 11:21

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

DB2/COBOL Stored Procedure Parameter list
I'm new to stored procedures, however, the passing of parameters using a group item in the calling cobol program seems incorrect to me. Would this work? Calling COBOL pgm is calling a stored procedure using a group 01 level and the receiving COBOL procedure has 01 levels for each parameter. Environment is z/OS... 6 Mar 2006 22:52