OLTP ROLLUP fucntion error in Z/OS DB2 Version 10



IBM's flagship relational database management system

OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby SALIR » Sat Aug 11, 2012 1:05 am

I am attempting to use the ROLLUP function in SPUFI. I am running on Z/OS DB2 Version 10 . I get a return code of -440 while executing the query.
SALIR
 
Posts: 4
Joined: Sat Aug 11, 2012 12:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

 

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby dick scherrer » Sat Aug 11, 2012 1:46 am

Hello and welcome to the forum,

I am attempting to use the ROLLUP function in SPUFI.
Please post the info from the manual where you found this.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby SALIR » Sat Aug 11, 2012 1:51 am

I am not referring any manual. I want to use the OLTP features like ROLLUP, CUBE etc in DB2. Is this function available in DB2 or not?
SALIR
 
Posts: 4
Joined: Sat Aug 11, 2012 12:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby Robert Sample » Sat Aug 11, 2012 2:15 am

If you are not willing to find and read manuals, this is NOT the forum for you. Most of the responders on this forum will provide you a hint and (maybe) a link to the manual. Perhaps you should go find another forum more suited to your lack of literacy?

And, by the way, one hint for you: the manual will tell you that DB2 does not support CUBE. Just one of the many things you could learn if you DID read the manuals.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby SALIR » Sat Aug 11, 2012 2:25 am

First of all thanks for your condescending response.

For your kind information I have read manuals and they do not explicitly mention whether the specific functions I was interested in is available or not. However there are server based versions of DB2 that do support it. A simple yes/no answer would have sufficed, rather than being curt.

Please do not waste your time responding to this thread.

Thanks.
SALIR
 
Posts: 4
Joined: Sat Aug 11, 2012 12:55 am
Has thanked: 0 time
Been thanked: 0 time

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby dick scherrer » Sat Aug 11, 2012 9:50 am

Hello,

By asking you to post where you found this in a manual, my intention was to confirm that you "knew" it existed. When i looked in the z/OS v10 manuals as well as online, i found nothing (which means it probably does not exist).

If you had mentioned in your original post that you had not been able to find it in the manuals but that you understood it was available on other platforms, you would have gotten a "is not available on z/OS" reply from me.

The best way to get replies you can use on this forum (as well as the several others i support) is to provide sufficient detail so that someone can help you. Most of us helpers will not read the manuals for people with questions. If someone is "stuck" by something in a manual we will help clarify.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby GuyC » Mon Aug 13, 2012 5:43 pm

OLTP and OLAP are quite opposites, the functions you are referencing are actually OLAP functions and not OLTP.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: OLTP ROLLUP fucntion error in Z/OS DB2 Version 10

Postby SALIR » Mon Aug 13, 2012 8:31 pm

Thanks. That was a slip up. Should have proof read read my question.

Appreciate the help from all.
SALIR
 
Posts: 4
Joined: Sat Aug 11, 2012 12:55 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post