By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

Migration from Oracle

P: n/a
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

Feb 28 '07 #1
Share this Question
Share on Google+
4 Replies


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

On Feb 28, 8:45 am, "Steve Rainbird"
<news.nos...@rainbird.me.nospam.ukwrote:
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

Feb 28 '07 #2

P: n/a
Yes, DB2 supports identity columns.

On Feb 28, 11:51 am, "morch" <f...@mairhtin.comwrote:
http://publib.boulder.ibm.com/infoce...nced/searchVie...

On Feb 28, 8:45 am, "Steve Rainbird"<news.nos...@rainbird.me.nospam.ukwrote:
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

Feb 28 '07 #3

P: n/a
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
Mar 1 '07 #4

P: n/a
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
Mar 1 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.