Difference between DB2 for LUW and DB2 for z/Series

mailar

Hi ,
Can some one help me find out the differences between DB2 for LUW and
DB2 for z/Series .
Also, can someone tel me what considerations do I need to make if I
wish to write some SQL UDFs which will be used on all of these
platforms(LUW and z/Series OS)

Thanks in advance
mailar

Nov 12 '05 #1

Subscribe Post Reply

2207

Serge Rielau

ma****@gmail.com wrote:

Hi ,
Can some one help me find out the differences between DB2 for LUW and
DB2 for z/Series .
Also, can someone tel me what considerations do I need to make if I
wish to write some SQL UDFs which will be used on all of these
platforms(LUW and z/Series OS)

Thanks in advance
mailar

ISBN 0-13-147700-5, "DB2 SQL PL", Prentice Hall
Chapter 9 covers SQL UDf. The book covers DB2 zOS as well.

Last I checked (V7) DB2 for zOS supported only the RETURN statement in
SQL UDF. That essentially means that you can use a SQL UDF as a
parameterized view.

Also take a look at the cross platform SQL Reference manual:
http://www-106.ibm.com/developerwork...206sqlref.html

Cheers
Serge

Nov 12 '05 #2

Similar topics

Find the series problem

by: Sriram Krishnan [at] gmx [dot] net | last post by:

Given an arbitrary number series, how do I identify the series and find the Nth number... for e.g 1,3,5,7 is an AP and the next number will be 9 1,8,27,64 is the series of cubes and the next will...

.NET Framework

How to eliminate the bitmap difference in big endian and little endian?

by: Eric J.Hu | last post by:

Hi, Such as I have following bitmap structure and assigned value: struct bm { char high2bits:2; char mid4bits:4; char low2bits:2; }; bm.high2bits = 3;

C / C++

Difference between .NET Remoting and Aysnchronus sockets

by: Macca | last post by:

Hi, I am writing a C# server app that listens for clients over a TCP/IP link. The clients are embedded devices with their software written in C. The clients establish connections and then...

C# / C Sharp

reproducible random number series

by: geoffp | last post by:

I need to generate reproducible random number series. I've done the obvious - use mt_srand with the same seed. This supposedly will create the same series every time. Is this true? Its not...

PHP

Difference between if if and if if else

by: Logan Lee | last post by:

Hi. What is the difference between if {} if {} if {} if else {} ?

C / C++

Difference between automatic and Auto-resize tablespace

by: Justin | last post by:

What is the difference between automatic and DMS Auto-resize tablespace?

DB2 Database

1004 Unable to set the Values property of the Series class

by: keirnus | last post by:

Hello, I've been coding in Access VBA to create an Excel Graph and it was good. Until I got this error: Please check the code below: Private Sub TestGraph3()

Microsoft Access / VBA

string difference and similarity

by: Jeff | last post by:

I've got a series of data like this: Long Sleeve White P/C Sm 32/33 Long Sleeve White P/C Med 32/33 .... What I'd like to do is extract the differences and the similarity. In this case: ...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA