Hello David,
Thanks for your response.
The reason I reproduced this problem is that my customer was trying to reference a sequence object on a remote server.
In fact, this was an issue for customers using db2, but I was personally curious and tested it in my Informix environment.
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Sat June 06, 2020 08:50 PM
From: David Williams
Subject: Why can't I use sequences directly in a view?
I guess the developers did not think it would be useful
Normally you get the next value directly from the sequence, why would you need a view?
Regards,
David.
------------------------------
David Williams
Original Message:
Sent: Thu December 12, 2019 02:55 AM
From: SangGyu Jeong
Subject: Why can't I use sequences directly in a view?
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
#Informix