DB2
in [SQL]
|
Does DB2 keep checksums for data? Hello, Does DB2 keep checksums of data, such as data page checksums, extent checksums, etc? - Or is it solely up to the file system or storage hardware to maintain such physical integrity structures? -- Troels ... 5 May 2010 14:52
Yellowfin Launches 5.0 Yellowfin is set to redefine what BI users and IT Departments will expect from Business Intelligence vendors Leading Business Intelligence software provider, Yellowfin, today announced it would be launching its milestone release on May 5th, 2010. Yellowfin 5.0 is set to redefine what BI users and IT Department... 4 May 2010 07:52
runstats on a table partitions Hello Experts, Is it possible to execute runstats only on a specific partition of a partitioned table in the database? Looking for an equivalent of oracle dbms_stats.gather_table_stats for a partition of partitioned table. Thanks, Puneet ... 3 May 2010 12:01
Yellowfin 5.0 Webinar Yellowfin Business Intelligence is offering customers,industry professionals, developers, OEMS and Vendors a chance to get a walk through of the new version 5.0 features, in time for the official launch. Join Glen Rabie, CEO of Yellowfin, as he presents this webinar and launches the milestone release, Yellowfin ... 29 Apr 2010 08:57
In DB2 UDF , Can I insert Temp table ??(Original Source MSSQL) Hi! I have the following build problem with UDF creating the following. The simplified text does the following: 1> MSSQL2005 UDF CREATE FUNCTION dbo.FUNC1 ( @CompanySeq INT, @FormatSeq INT ) RETURNS @retFindReports TABLE ( FSItemTypeSeq INT, FSItemSeq INT ) AS B... 2 May 2010 12:01
sql16012N Error Hi I have the following build problem with CODE executing the following. The simplified code does the following(SQL16012N) The Sample code is the following. CREATE OR REPLACE PROCEDURE xmlProc RESULT SETS 1 LANGUAGE SQL BEGIN declare Cust XML; set Cust = XMLCAST( '<ROOT> <DataBlock1> <WorkingTa... 28 Apr 2010 03:56
MSSQL(Temp Table and sp_executesql) to DB2(problem) Is possible EXECUTE IMMEDIATE 'ALTER TABLE GTE(global temp table)' If not support, Are there other ways to handle "alter table GTE" ... 28 Apr 2010 02:50
Ecko Man T-Shirt cheap wholesale Ecko Man T-Shirt cheap wholesale ED Hardy T-Shirt cheap wholesale Evisu Man T-Shirt cheap wholesale Gino Green Global Man T-Shirt cheap wholesale G-Star Man T-Shirt cheap wholesale Juicy Women T-Shirt cheap wholesale Lacoste T-Shirt cheap wholesale LEVIS Man T-Shirt cheap wholesale LRG Man T-Shirt cheap wholes... 27 Apr 2010 10:59
use a generated column in a where clause Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. If you know how, follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats. Code should be in Standard SQL... 26 Apr 2010 23:56
DB2 SQL16003N URSOR IDENTIFIED IN FETCH OR CLOSE STATEMENT IS NOT OPEN!! Hi I'm currently conversioning mssql to DB2(V9.7 Fix1) The MSSQL has sources(SP,Function,XML Parsing) In the SP(MSSQL) source, exists sp_xml_preparedocument function. And we convert to DB2 using XMLTABLE,XMLPARSE So in... I have the following build problem with CODE executing the following. The simplified code d... 26 Apr 2010 22:50 |