Re: System Name on View

[Brent Goben <goben.brent@xxxxxxxxx>]

Thanks, Greg. That worked!

On Fri, Oct 18, 2019 at 1:47 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> 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