Re: SQL Equivalent of CRTLF

[Reeve <rfritchman@xxxxxxxxx>]

Greg, I highly recommend looking into the Index Advisor.  It will tell you
what indexes you have to create...and the IA will do it with a click.

I code against tables/PF’s and let the IA tell me what I have to create for
performance.  I still use LF’s a bit but not in any new code I’ve written
in years.

-Reeve

On Fri, Oct 16, 2020 at 07:46 Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
wrote:

> I've been using SQL I programs and to create views for quite some time.
> I'm trying to force myself away from DDS.
>
> So I created a new table with SQL... now I need to create a subset of that
> table by way of a logical file (I want to use RPG Native access in my
> program), which can also be updated.
>
> Is there a simple way to create a view of my table that contains all
> columns "where" one of the columns is blank?
>
> My current take on DDL versus DDS is that DDS is much, much easier and
> faster to use.
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com