Re: Rowids in Informix Databases
Vijay,
"rowid" is a column in each table, it's just a silent column (see
below). But you should not rely on it since it may not be unique. You
should create your own unique field. Hope this helps.
Brice
$ onstat -
Informix Dynamic Server Version 9.40.UC1 -- On-Line -- Up 8 days
18:59:04 --
30720 Kbytes
$ echo "select * from customer where customer_num = 101"|dbaccessstores_demo
Database selected.
customer_num 101
fname Ludwig
lname Pauli
company All Sports Supplies
address1 213 Erstwild Court
address2
city Sunnyvale
state CA
zipcode 94086
phone 408-789-8075
1 row(s) retrieved.
Database closed.
$ echo "select rowid,* from customer where customer_num =101"|dbaccess stores_d
emo
Database selected.
rowid 257
customer_num 101
fname Ludwig
lname Pauli
company All Sports Supplies
address1 213 Erstwild Court
address2
city Sunnyvale
state CA
zipcode 94086
phone 408-789-8075
1 row(s) retrieved.
Database closed.
$
"Vijay Kumar" <rudrappa@india.hp.com> wrote in message news:<ckgust$kl1$1@news.xmission.com>...
> Hi All,
>
> We have created a database in informix 9.40 on HP Itanium machine.
> The tables doesn't have rowid column. Is there way to create the database
> such that all the tables have rowid column? Please let me know regarding
> this. Thanks in advance.
>
> Regards,
> Vijay Kumar
>
> sending to informix-list