What methods are there for migrating Oracle rowid based dml into DB2?

We have lots of code that uses the following method in Oracle

select rowid into lRowid from <table>;
..
..
..
..
update <table> where rowid = lRowid;

The database is being migrated to DB2.

I have read about a ROWID datatype is this usable?

In sqlserver I would use an identity column is this available in DB2.

I have googled this but the more I look the more I get confused.


TIA

--
Steve

http://publib.boulder.ibm.com/infoce...rchWord=+rowid

On Feb 28, 8:45 am, "Steve Rainbird"
<news.nos...@rainbird.me.nospam.uk> wrote:
> What methods are there for migrating Oracle rowid based dml into DB2?
>
> We have lots of code that uses the following method in Oracle
>
> select rowid into lRowid from <table>;
> .
> .
> .
> .
> update <table> where rowid = lRowid;
>
> The database is being migrated to DB2.
>
> I have read about a ROWID datatype is this usable?
>
> In sqlserver I would use an identity column is this available in DB2.
>
> I have googled this but the more I look the more I get confused.
>
> TIA
>
> --
> Steve

Yes, DB2 supports identity columns.



On Feb 28, 11:51 am, "morch" <f...@mairhtin.com> wrote:
> http://publib.boulder.ibm.com/infoce...nced/searchVie...
>
> On Feb 28, 8:45 am, "Steve Rainbird"<news.nos...@rainbird.me.nospam.uk> wrote:
> > What methods are there for migrating Oracle rowid based dml into DB2?
>
> > We have lots of code that uses the following method in Oracle
>
> > select rowid into lRowid from <table>;
> > .
> > .
> > .
> > .
> > update <table> where rowid = lRowid;
>
> > The database is being migrated to DB2.
>
> > I have read about a ROWID datatype is this usable?
>
> > In sqlserver I would use an identity column is this available in DB2.
>
> > I have googled this but the more I look the more I get confused.
>
> > TIA
>
> > --
> > Steve

Steve Rainbird wrote:
> What methods are there for migrating Oracle rowid based dml into DB2?
>
> We have lots of code that uses the following method in Oracle
>
> select rowid into lRowid from <table>;
> .
> .
> .
> .
> update <table> where rowid = lRowid;
>
> The database is being migrated to DB2.
>
> I have read about a ROWID datatype is this usable?
>
> In sqlserver I would use an identity column is this available in DB2.
>
> I have googled this but the more I look the more I get confused.
>
>
> TIA

To the best of my knowledge there is no facility in DB2 to do what
it appears you have been doing in Oracle. But then my advice to you
in Oracle would have been to not do it either as rowid's can change.

If you are moving to DB2 ... then move to DB2 and don't bring to it
your Oracle-specific practices: Especially the bad ones. <g>
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
> Steve Rainbird wrote:
>> What methods are there for migrating Oracle rowid based dml into DB2?
>>
>> We have lots of code that uses the following method in Oracle
>>
>> select rowid into lRowid from <table>;
>> .
>> .
>> .
>> .
>> update <table> where rowid = lRowid;
>>
>> The database is being migrated to DB2.
>>
>> I have read about a ROWID datatype is this usable?
>>
>> In sqlserver I would use an identity column is this available in DB2.
>>
>> I have googled this but the more I look the more I get confused.
>>
>>
>> TIA
>
> To the best of my knowledge there is no facility in DB2 to do what
> it appears you have been doing in Oracle. But then my advice to you
> in Oracle would have been to not do it either as rowid's can change.
>
> If you are moving to DB2 ... then move to DB2 and don't bring to it
> your Oracle-specific practices: Especially the bad ones. <g>
well spoken

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab