RE: How get ROWNUM in DB2

Hey Singh,

Not questioning your skill, but I think Ed was just re-aquainting with you and maybe poking a little fun. He likes to do that on Fridays, AND SO DO I!!!!!!!! You seem to be under stress my friend! Lighten up! It's Fridayyyyyyyyyyyyyyy!!!!!!! Friday's always a great day!! Unless of course, your databases crash and your backups have failed. That might be a bummer in some cultures. But Friday would still be a great day to begin looking for another job!!! Hahahaha!!!!

Have a great weekend!

Nick

-------------- Original message --------------
From: "Singh Rahul " <db2udbdba-ezmlmshield-x39434754.[Email address protected]

> With db2move I am not sure if it can be used in same database as it is used to
> move data from one DB to Another DB.
> Import will work
> export to c:\123.ixf of ixf select * from db2admin.123
> IMPORT FROM c:\123.ixf of ixf CREATE INTO admindb2.123
>
> -----Original Message-----
> From: Edwards Ed [mailto:db2udbdba-ezmlmshield-x59829399.[Email address
> protected]
> Sent: Friday, March 30, 2007 4:21 PM
> To: LazyDBA Discussion
> Subject: RE: How get ROWNUM in DB2
>
> Well, well, well,
> It's Singh Rahul! Hehe. How have you been? Didn't you send an email
> not too long ago saying that if you did a db2move or export, you could
> change the name of the schema and import the data in to the new schema?
>
>
> Oh my! Phew! It's Fridayyyyyyyy! Partyyyyyyy! Hehe.
>
>
> Have a great Day and Weekend!
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service you
> received from our staff. The Department of Education values your feedback as a
> customer. Commissioner of Education Jeanine Blomberg is committed to
> continuously assessing and improving the level and quality of services provided
> to you.Simply use the link below. Thank you in advance for completing the
> survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: Singh Rahul
> [mailto:db2udbdba-ezmlmshield-x54511070.[Email address protected]
> Sent: Friday, March 30, 2007 6:21 AM
> To: LazyDBA Discussion
> Subject: RE: How get ROWNUM in DB2
>
> DB2 9 lets you do that now with one command. There is now a new stored
> procedure called ADMIN_COPY_SCHEMA that can duplicate *all* of the
> objects (tables, indexes, views, MQTs, functions, etc) from one schema
> to another (in the same or different tablespace) with or without the
> data.
>
>
> -----Original Message-----
> From: anandjairamkadagadakai
> [mailto:db2udbdba-ezmlmshield-x61839867.[Email address protected]
> Sent: Friday, March 30, 2007 3:38 PM
> To: LazyDBA Discussion
> Subject: RE: How get ROWNUM in DB2
>
> Its not possible...
>
> You need to drop the table and recreate in desired schema...
>
> Thanks & Regards
> Anand.J.K
>
>
>
> "anil" > 30 Mar 2007 14:23 Mail Size: 6940
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> RE: How get ROWNUM in DB2
>
>
>
>
> Our Ref
>
> Your Ref
>
>
>
>
> thanks
>
> can any body tell me how to change schema of a table in DB2 ,
> means
> moving a tables from one schema to others
>
> rgds,
> Anil
>
>
>
>
>
>
> |---------+--------------------------------------------------------->
> | | "Singh Rahul " |
> | | > | | azyDBA.com> |
> | | |
> | | 03/30/2007 10:51 AM |
> | | |
> |---------+--------------------------------------------------------->
>
> >-----------------------------------------------------------------------
> ------------------------|
> | |
> | To: "LazyDBA Discussion" <[Email address protected]
>
> |
> | cc: (bcc: anil.gupta/Polaris) |
> | Subject: RE: How get ROWNUM in DB2 |
>
> >-----------------------------------------------------------------------
> ------------------------|
>
>
>
>
> Try
> row_number() over(order by ...) in the select clause
>
> -----Original Message-----
> From: anil [mailto:db2udbdba-ezmlmshield-x75423619.[Email address
> protected]
> Sent: Friday, March 30, 2007 10:30 AM
> To: LazyDBA Discussion
> Subject: How get ROWNUM in DB2
>
>
> HI
>
> can any body tell me how to get ROWNUM equivalent in DB2
>
> Anil
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only. If by an addressing or
> transmission error this mail has been misdirected to you, you are
> requested
> to delete this mail immediately. You are also hereby notified that any
> use,
> any form of reproduction, dissemination, copying, disclosure,
> modification,
> distribution and/or publication of this e-mail message, contents or its
> attachment other than by its intended recipient/s is strictly
> prohibited.
>
> Visit us at http://www.polaris.co.in
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only. If by an addressing or
> transmission error this mail has been misdirected to you, you are
> requested to delete this mail immediately. You are also hereby notified
> that any use, any form of reproduction, dissemination, copying,
> disclosure, modification, distribution and/or publication of this e-mail
> message, contents or its attachment other than by its intended
> recipient/s
> is strictly prohibited.
>
> Visit us at http://www.polaris.co.in
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> -----------------------------------------
> ******************************************************************
> This message originated from the Internet. Its originator may or
> may not be who they claim to be and the information contained in
> the message and any attachments may or may not be accurate.
> ******************************************************************
>
>
>
>
> ************************************************************
> HSBC Software Development (India) Pvt Ltd
> HSBC Center Riverside,West Avenue ,
> 25 B Kalyani Nagar Pune 411 006 INDIA
>
> Telephone: +91 20 26683000
> Fax: +91 20 26681030
> ************************************************************
>
>
>
> -----------------------------------------
> *******************************************************************
> This e-mail is confidential. It may also be legally privileged.
> If you are not the addressee you may not copy, forward, disclose
> or use any part of it. If you have received this message in error,
> please delete it and all copies from your system and notify the
> sender immediately by return e-mail.
>
> Internet communications cannot be guaranteed to be timely,
> secure, error or virus-free. The sender does not accept liability
> for any errors or omissions.
> *******************************************************************
> "SAVE PAPER - THINK BEFORE YOU PRINT!"
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page