DB2 for z/OS kullananlar icin...

Cuneyt Goksu

DB2 for z/OS kullananlar icin...


Merhaba,

DB2 for z/OS V10 veya sonraki sürümlerde yapılması için iki enhancement
isteği açtım IBM'e...


Bu isteklerin daha hızlı gerçekleştirilmesi, daha çok kullanıcı
tarafından talep edilmesiyle koşut. Lütfen, IBM Müşteri temsilciniz
aracılığı ile bu enhancement isteklerini desteklediğinizi DB2 for z/OS
Development'a iletin. Böylece, yapılması hızlanabilir.


----------------
MR0330103951 : Title - IXF format as input for LOAD Utility
Description: IXF is an international standard for moving data with table
structure between relational databases such as Oracle and DB2 for LUW.
Having a feature for LOAD Utility for DB2 for z/OS accepting IXF format
will make easier for Oracle to Db2 for z/OS migration in the future.


MR0706106036 : Title : MERGE Statement Syntax enhancement.

Description: MERGE statement on DB2 for z does not accept Select
Statement as an input but MERGE on DB2 for LUW accepts queries as input.
This difference brings different SQL coding for the same program that
access both DB2 for z/OS and DB2 for LUW

Such as;
MERGE INTO T1 A USING(SELECT C1,C2 FROM T2) B
ON (A.C1 = B.C1) WHEN NOT MATCHED THEN
INSERT (C1,C2) VALUES (B.C1,B.C2)

does not work for DB2 for z/OS

Suggested Solution: SubQuery syntax in MERGE statement for DB2 for z/OS
will not only simplify the UPSERT of data thru dynamic SQL but also make
consistent SQL Coding for developers.

----------

Iyi calismalar, Best Regards, Saludos, Lijepi pozdrav
------------------------------------------------------------------------
Cuneyt Goksu
DB2 Specialist, IBM Information Champion, IBM Gold Consultant
IDUG 2010 Europe, Conference Chairperson
DB2 for z/OS and LUW V9 Certified
+90 555 2092562
+90 532 2540342
< http://www.linkedin.com/in/cuneytgoksu >
http://www.linkedin.com/in/cuneytgoksu
------------------------------------------------------------------------
Think Enterprise, Think Z


---------------------------------------------------------------------------
Turkiye DB2 Kullanici grubu listesine hosgeldiniz.

Listeye mesaj atmak icin, <[login to unmask email]>, adminlere ulasmak icin, <[login to unmask email]> adreslerini kullanabilirsiniz.

www.idug.org
www.db2turkish.org
----------------------------------------------------------------------------