Migration from Oracle

[Steve Rainbird]

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 <tablewhere 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

[morch]

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

On Feb 28, 8:45 am, "Steve Rainbird"
<[e-mail]:

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 <tablewhere 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

[jan.ibm]

Yes, DB2 supports identity columns.

On Feb 28, 11:51 am, "morch" <[e-mail]:

http://publib.boulder.ibm.com/infoce...nced/searchVie...

On Feb 28, 8:45 am, "Steve Rainbird"<[e-mail]:

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 <tablewhere 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

[DA Morgan]

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 <tablewhere 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
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Serge Rielau]

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 <tablewhere 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