DB2 V9 fiery出炉! — Express

August 8th, 2008 admin Posted in IBM DB2 1 Comment »

  DB2 V9 fiery出炉 

  "Now, Web is that they (structured and unstructured data) together and we need a common tool to handle these two types of data. This is what we now have to face the challenges ahead." 
  — Don Chanmblin,


DB2 in the affairs of ID

August 8th, 2008 admin Posted in IBM DB2 11 Comments »

  DB2 in the affairs of ID Author: Yiming time :2005-08-12 17:39 Source: Internet Zebian: Xiaoyu Abstract: DB2 in the affairs of ID from the DB2 log records in search of the only unit identifier 

  Level: Intermediate 

  Knut Stolze …


DB2 common problem fool

August 7th, 2008 admin Posted in IBM DB2 1 Comment »

  DB2 common fool 1000 issue of Q (5) 

  Members of the application of DB2 may encounter some seemingly simple question, especially the rookie, I would like to sum up the simple, issued to everyone that we can hope for help, we also welcome to explore, Common development…


DB2 Driver type

August 7th, 2008 admin Posted in IBM DB2 2 Comments »

  General description of 

  IBM's database product line to provide different versions of the data access API can be said to be many, including the early drive on the CLI, the most recent of pure Java driver and CLI and the combination of Java. For a specific…


DB2 V9 commonly used SQL finishing

August 7th, 2008 admin Posted in IBM DB2 No Comments »

  Affirms that: if reproduced, please reference! 

/***************************************

  DB2 V9 commonly used SQL finishing – Part 1 

  Finishing: Peng Jianjun 

  Last…


oracle and a number of similarities and differences between db2

August 7th, 2008 admin Posted in IBM DB2 1 Comment »

  1, Table space for indexes of different 

Oralce:

  Create TABLE T1 …………. IN DATA_TA 

  Create Index …….. ON T1 …… IN INDX_TS 

DB2:

  Create TABLE T1 …….. IN DATA_TS INDEX IN…


DB2 е ַ֮ Æ

August 5th, 2008 admin Posted in IBM DB2 No Comments »

  DB2 е ַ֮ Æ 

  ߩ sCCBZZP 

  ڬ FÄDB2 дҿ ܽ һЩ åeÕ `, åeÕ` ԭ nj | DB2Ä 
  Ʋ ̫ ˽ Ä, ڴ Һ ε ؿ ½ Y һ Â, šg…


DB2, date, time comparison of alternative methods

August 5th, 2008 admin Posted in IBM DB2 No Comments »

  1, 2004 for registered customers 
  SELECT CUSTOMERCODE FROM ST_BOOK WHERE SUBSTR (CAST (BOOKDATE AS CHAR (30)), 1,4) ='2004 ' 
  2, registered customers for 2004-12 
  SELECT CUSTOMERCODE FROM ST_BOOK WHERE SUBSTR (CAST (BOOKDATE AS CHAR (30)),…


DB2 incremental online backup and recovery

August 5th, 2008 admin Posted in IBM DB2 No Comments »

  Why should we carry out on-line incremental backups » 

  Online backup means that the time to allow other types of connections, rather than Tingdiao database 

  Incremental means that do not need to back up every time a large database. …


DB2 commonly used SQL statement

August 3rd, 2008 admin Posted in IBM DB2 No Comments »

  1, the implementation of portfolio statements 

  BEGIN ATOMIC 
  Expression of a semicolon spaces / 2 semicolon Enter expression spaces / Enter 
END

  2, should be limited access to (these should be withdrawn PUBLIC SELECT access…