Re: [EXTERNAL] RE: SQL Equivalent of CRTLF

[Dexter Thompson <dexter.thompson@xxxxxxxxx>]

I may not understand what you said.  I do not use the ACS wizards.  I think
the coding is straightforward.  The RCDFMT allows RPG to have a format name
and you do not have to do a RENAME in the F spec.  This will include all
fields.

CREATE INDEX MyIndex
  ON MyTable ( Fld1, Fld2, Fld3, Fld4 )
  Where Fld5 = ' '
  RCDFMT MyRecdFormat      ;

On Fri, Oct 16, 2020 at 1:38 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> OK... that's what I tried with the "Manage Schemas" in ACS.  But my index
> (LF) only had the two key fields available.
>
> I see from your article:   "RCDFMT myFile ADD ALL COLUMNS"
>
> Is that why?  I've never seen that before.  But I think I found the
> options in ACS.
>
> Now my issue is that I don't have the time to learn and experiment with
> DDL (which is often the case).  I have to get this done and move on.
>
> I can see why moving away from DDS has taken so long.
>
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> Birgitta Hauser
> Sent: Friday, October 16, 2020 1:09 PM
> To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: SQL Equivalent of CRTLF
>
> If you want a keyed access with native I/O you need to create an index!
> BTW SQL Indexes can not be specified in an SQL Statement, but they can be
> used in composition with native I/O like any keyed DDS described logical
> file.
> You may read the following article:
> SQL indexes and native I/O - no contradiction
>
> https://developer.ibm.com/technologies/systems/articles/i-sql-indexs-and-nat
> ive-io/
> <https://developer.ibm.com/technologies/systems/articles/i-sql-indexs-and-native-io/>
>
> ... and SQL is much more powerful and much easier than DDS
> ... and DDS is stabilized and outdated
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> "Train people well enough so they can leave, treat them well enough so they
> don't want to." (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg
> Wilburn
> Sent: Freitag, 16. Oktober 2020 16:47
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: SQL Equivalent of CRTLF
>
> 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
>
> --
> 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
> --
> 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