Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

GENERATE_UNIQUE performance function

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
AlbertoR

New User


Joined: 28 Sep 2007
Posts: 4
Location: Bilbao

PostPosted: Thu Oct 25, 2007 3:58 pm    Post subject: GENERATE_UNIQUE performance function
Reply with quote

Hi,

I'm thinking about using GENERATE_UNIQUE function to identify and I would like to know if the would be a lack of performance if there are many executions of the function at the same time. It would be a big queue of the requests of the function?

Thank you,

Alberto
Back to top
View user's profile Send private message

vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 276
Location: Bang,iflex

PostPosted: Thu Oct 25, 2007 4:59 pm    Post subject:
Reply with quote

Hi,



Please frame the question properly according to your query.




Regard's
Vasanth
Back to top
View user's profile Send private message
AlbertoR

New User


Joined: 28 Sep 2007
Posts: 4
Location: Bilbao

PostPosted: Thu Oct 25, 2007 7:41 pm    Post subject:
Reply with quote

Hi,

Sorry for my English icon_wink.gif.

I want to use GENERATE_UNIQUE function to identify the rows.

The question is if this function get many load of CPU, get down the performance and if how many executions at the same time of this function could be?

Thank you
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 276
Location: Bang,iflex

PostPosted: Fri Oct 26, 2007 9:50 am    Post subject:
Reply with quote

Hi Albert,



Pls find the below link, it may helps you a lot.



http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sample.doc/doc/cobol_mf/s-impexp-sqb.htm

Regard's
Vasanth........ icon_smile.gif
Back to top
View user's profile Send private message
AMITESH
Currently Banned

New User


Joined: 28 Feb 2008
Posts: 3
Location: kolkata

PostPosted: Thu Apr 17, 2008 3:48 pm    Post subject: How can i use GENERATE_UNIQUE function???????
Reply with quote

Hi,

Is this function is only for a particular version of DB2?

i am trying to use this function.but at run time it gives the following error message.......................

SQLCODE = -440, ERROR: NO FUNCTION BY THE NAME GENERATE_UNIQUE HAVING
COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Thu Apr 17, 2008 4:05 pm    Post subject:
Reply with quote

What's your DB2 version?
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Thu Apr 17, 2008 4:57 pm    Post subject:
Reply with quote

GENERATE_UNIQUE() SQL function from DB2 UDB Version 6.1

Although the function has no arguments, the empty parentheses must be specified when the function is invoked.
Back to top
View user's profile Send private message
AMITESH
Currently Banned

New User


Joined: 28 Feb 2008
Posts: 3
Location: kolkata

PostPosted: Fri Apr 18, 2008 11:02 am    Post subject: db2 version 7.2
Reply with quote

db2 version is 7.2

is it version specific???
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us