Re: SQL Equivalent of CRTLF

[Alan Campin <alan0307d@xxxxxxxxx>]

> > My current take on DDL versus DDS is that DDS is much, much easier and
faster to use.
Yes, SQL is much more powerful but SQL gives you so much more power and the
ability to do so much in so little. Are you using the wizards to create
your SQL objects. Will make life so much easier.

> > Is there a simple way to create a view of my table that contains all
columns "where" one of the columns is blank?
If you are using file I/O, why not just use a logical with a select/omit?

I just finished a project where I was creating a service program but it had
to use file I/O. No SQL so I just created field select logicals over my SQL
defined tables and brought in what I needed.

The database doesn't care if you put a logical over a SQL defined table or
a view over a DDS defined table but what works better is just use SQL and
just use a where clause to select the records you need or use a view.

If all you are doing is reading the file, you can create a view and read it
though file I/O.



On Fri, Oct 16, 2020 at 7:46 AM 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