Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT 
Author Message
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT
We have moved our DB2-Database from OS/2 to MVS. Now we have experienced a
few problems in using SQL.
For example: Using a column in the ORDER BY - clause without using the same
column in the SELECT-clause is not possible under DB2-MVS V5.1 (but it works
under DB2-OS/2 V2.1 and also under DB2-MVS V6).

My question: is there anywhere a document which lists the differences
between SQL under OS/2 or NT and MVS?



Tue, 31 Dec 2002 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT

No - there used to be one.. it was - abused.

Cheers
Serge



Tue, 31 Dec 2002 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT
Let's see more features on the db/2 side and better availability / better able to
deal with high contentions on the MF side.  Each side is about 2 releases back
for the features introduced in the other.
Like the pc side has AST which has yet to show up on the MF size and the PC side
just got incremental copys -- a feature that's been on the MF side really a long
time ago.  Both sides have UDT and SPB -- a completly new features from say 2 ro
3 years ago.
Quote:

> No - there used to be one.. it was - abused.

> Cheers
> Serge



Wed, 01 Jan 2003 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT
There is more focus in v7 on doing things the same we, specifically:
- stored procedure builder
- external savepoint
- identity columns
- declared temporary tables
Quote:

> Let's see more features on the db/2 side and better availability / better able to
> deal with high contentions on the MF side.  Each side is about 2 releases back
> for the features introduced in the other.
> Like the pc side has AST which has yet to show up on the MF size and the PC side
> just got incremental copys -- a feature that's been on the MF side really a long
> time ago.  Both sides have UDT and SPB -- a completly new features from say 2 ro
> 3 years ago.


> > No - there used to be one.. it was - abused.

> > Cheers
> > Serge



Wed, 01 Jan 2003 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT

Here are the SQL Reference manuals for each platform.

    I would recommend to download the neccessary documents and comparision
yourself.

DB2 OS/390
http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNSQ0G2/CCONTE...
LF=DSNSH0G3

DB2 UDB - Windows NT - Windows 9X - Windows 2000 - Linux - RISC/6000
ftp://ftp.boulder.ibm.com/ps/products/db2/info/vr6/pdf/letter/db2s0e6...

VM/VSE
ftp://ftp.boulder.ibm.com/ps/products/db2/info/vr6/vmvse/sqlref.pdf

AS/400
http://publib.boulder.ibm.com/pubs/html/as400/v4r5/ic2924/info/db2/rb....
pdf

    Typically functions vary from platform to platform.

    Apparently no one at IBM has the time or figures that it is important to
standardize DB2 (or at least has much as possible). A good example is the
difference of the string functions that vary from platform to platform.

    Come on guys (at IBM)  I find it hard to believe that different there is
different TRIM functions for platforms ;-).

    Personally, I find the most frustrating difference is VM/VSE lack of
support for the FOR HOLD option (which does not reset the cursor to exist
after a COMMIT / ROLLBACK). I would loved to be wrong, but each release of
VM/VSE version, I looked at the 'new features' and never did I see the FOR
HOLD option was available.

    As for the your ORDER BY problem, I tend to avoid performing sort on the
columns that are not part ofthe result set.

    When I encounter such a case, I simply append the sort columns to the
result set and do not access them in your program, this will work for all
database products. The only problem, occurs when the extra sort columns data
adds significantly to size of the data returned.

    Database vendors that support this feature, the database engine perform
a sort only on rows that in the result set. What typically occurs, is that
the database engine appends the extra sort columns to the result set then
sorts the rows, then removes the extra sort columns from the resultset.

    By the way sorting the data before building the result set would be
silly, since sorting an entire table is typically more expensive than
sorting the result set.


Quote:
> We have moved our DB2-Database from OS/2 to MVS. Now we have experienced a
> few problems in using SQL.
> For example: Using a column in the ORDER BY - clause without using the
same
> column in the SELECT-clause is not possible under DB2-MVS V5.1 (but it
works
> under DB2-OS/2 V2.1 and also under DB2-MVS V6).

> My question: is there anywhere a document which lists the differences
> between SQL under OS/2 or NT and MVS?



Sat, 04 Jan 2003 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT
Serge,

What do you mean by it was abused?

Quote:

> No - there used to be one.. it was - abused.

> Cheers
> Serge



Sun, 05 Jan 2003 03:00:00 GMT
 Differences between SQL on DB2-MVS and DB2-OS/2 or DB2-NT
IBM is so open about these things.   We published this book to help
programmers writing applications for DB2 on MVS, Unix and NT, and our
competitors used it as a marketing weapon to show how IBM had a
different code base on MVS.

Fortunately, our competitors have all acquired multiple code bases, so
they're in the same boat now.

Quote:

> Serge,

> What do you mean by it was abused?


> > No - there used to be one.. it was - abused.

> > Cheers
> > Serge



Sun, 05 Jan 2003 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

2. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

3. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

4. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

5. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

6. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

7. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

8. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

9. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

10. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

11. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS

12. 18727-MS-Jackson-DB2-COBOL-C++-MVS-ORACLE-Programmers(6) MVS COBOL DB2 CICS


 
Powered by phpBB® Forum Software