Re: System Name on View

CREATE OR REPLACE VIEW V_ORDER_STATUS FOR SYSTEM NAME V_OPORDSTS

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Brent Goben
Sent: Friday, October 18, 2019 2:45 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: System Name on View

I'm trying to give a view a name other than XXXXX00001
My statement is as follows:

CREATE OR REPLACE VIEW view_name AS
(
SELECT t1.col1, t2.col2
FROM table1
INNER JOIN table2 ON t1.col1=t2.col1
)
RCDFMT NEWVIEW;

The view gets created. However, the System Name is always XXXXX00001

Thanks,
Brent
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com