diff options
| author | Pierre Schmitz <pierre@archlinux.de> | 2010-07-28 11:52:48 +0200 |
|---|---|---|
| committer | Pierre Schmitz <pierre@archlinux.de> | 2010-07-28 11:52:48 +0200 |
| commit | 222b01f5169f1c7e69762e0e8904c24f78f71882 (patch) | |
| tree | 8e932e12546bb991357ec48eb1638d1770be7a35 /maintenance/ibm_db2/README | |
| parent | 00ab76a6b686e98a914afc1975812d2b1aaa7016 (diff) | |
update to MediaWiki 1.16.0
Diffstat (limited to 'maintenance/ibm_db2/README')
| -rw-r--r-- | maintenance/ibm_db2/README | 40 |
1 files changed, 1 insertions, 39 deletions
diff --git a/maintenance/ibm_db2/README b/maintenance/ibm_db2/README index 4a2c0f60..3c3f381c 100644 --- a/maintenance/ibm_db2/README +++ b/maintenance/ibm_db2/README @@ -1,41 +1,3 @@ -== Syntax differences between other databases and IBM DB2 == -{| border cellspacing=0 cellpadding=4 -!MySQL!!IBM DB2 -|- - -|SELECT 1 FROM $table LIMIT 1 -|SELECT COUNT(*) FROM SYSIBM.SYSTABLES ST -WHERE ST.NAME = '$table' AND ST.CREATOR = '$schema' -|- -|MySQL code tries to read one row and interprets lack of error as proof of existence. -|DB2 code counts the number of TABLES of that name in the database. There ought to be 1 for it to exist. -|- -|BEGIN -|(implicit) -|- -|TEXT -|VARCHAR(255) or CLOB -|- -|TIMESTAMPTZ -|TIMESTAMP -|- -|BYTEA -|VARGRAPHIC(255) -|- -|DEFAULT nextval('some_kind_of_sequence'), -|GENERATED ALWAYS AS IDENTITY (START WITH 0, INCREMENT BY 1), -|- -|CIDR -|VARCHAR(255) -|- -|LIMIT 10 -|FETCH FIRST 10 ROWS ONLY -|- -|ROLLBACK TO -|ROLLBACK TO SAVEPOINT -|- -|RELEASE -|RELEASE SAVEPOINT -|} == See also == +*[http://www.mediawiki.org/wiki/Manual:IBM_DB2 Installation instructions] *[http://ca.php.net/manual/en/function.db2-connect.php PHP Manual for DB2 functions]
\ No newline at end of file |