DB2
in [SQL]
|
COUNT(*) Not accurate? I am running DB2 V9.5 FP 4 on AIX. I just found a strange case where my SELECT COUNT(*) was giving me different totals on a table. I was checking the count on this parent table and the two child tables. The two child tables were accurately showing 130k records as all times, however, the parent table kept fluxuat... 9 Apr 2010 08:52
Recursive SQL PL ? I was wondering, whether it is possible to create recursive SQL PL functions in DB2. A simple example: CREATE OR REPLACE FUNCTION fibo ( k integer ) RETURNS integer BEGIN IF k < 2 THEN return 1; ELSE return fibo(k-1) + fibo(k-2); END IF; END ! ends up with rather unexpec... 6 Apr 2010 16:26
strange query behaviour Hi, I am experiencing problems running a query on a warehouse-server. DB2 8.1 FP 12 on AIX 64 bit (Upgrade to 9x cannot be done in the near future). Situation: One complex query with 2 different arguments: 1. where year='2008' (or 2006, 2007..) - runs fine everywhere 2. where year='2009' - runs loca... 2 Apr 2010 07:05
Location Intelligence demo Quick demo on the power of Location Intelligence to visualise your data http://www.youtube.com/watch?v=uhD1NtNdj8E ... 30 Mar 2010 08:17
New Auth Agents on V9.1 FP1 on UNIX Does anyone have any information, about the 32 new connections to the database ? I'm just starting to "play" with DB2 V9.7 FP1 on UNIX, and if I activate the database, but don't connect and do a db2 list db directory, I get no connections. But when I do a db2 list application show detail, I see 40+ connection... 5 Apr 2010 20:34
DB2 Stored Procedure - Passing Parameter Issues Hi All, db2 stored procedure - passing parameters issue static sql within the procedure where char_account_no in ( :ws-acct-list ) if pass 123457 it returns the correct result for the single account if pass '1234567' it returns nothing if pass '1234567','2345678' it returns nothing. Anyone have... 4 Apr 2010 20:23
ADM0500E The DB2 Service does not have the necessary authority to complete the command Hi all. I'm running DB2 Express C 9.71 on an XP sp2 box, and I get the following error in the event log: Event ID 4. "ADM0500E The DB2 Service does not have the necessary authority to complete the command" Any hints? Thanks in advance. Bye Franco -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ http://www.... 23 Mar 2010 05:36
How to verify data move from big endian to little endian architecture? On 3/22/10 11:40 AM, Jason K wrote: We are in the process of migrating data from db2 9.5 from Solaris (SPARC) to Linux (x64). A big to little endian conversion has to take place because of the architectural differences between to two platforms. What steps can I run to verify that the data in the source a... 23 Mar 2010 02:20
341594 Information portals for computer and Web technology 23 I fell in love with the net and all the compuiter teahcnology in the very early years and have loved it ever since, I have an IT Degree and Communications degree and will be working on my doctorate for the next five years, in bwetween I design websites, databases, Multimedia Produxction or anything that wil make me a p... 22 Mar 2010 22:59
How to verify data move from big endian to little endian architecture? We are in the process of migrating data from db2 9.5 from Solaris (SPARC) to Linux (x64). A big to little endian conversion has to take place because of the architectural differences between to two platforms. What steps can I run to verify that the data in the source and target databases are the same. Yes, I know w... 23 Mar 2010 12:26 |