Re: Table Definitions DDS or SQL?

[Mike <koldark@xxxxxxxxx>]

Do you just define it as TXT? Just curious.

On 10/6/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> I keep the sql statements in a source pf.  I "compile" them with
> RUNSQLSTM.
>
> Where do you keep the ADDPFCST statements on your DDS files?  With SQL
> they can all be included in the CREATE TABLE.
>
> I don't think it keeps track of reference fields with SQL.  I guess that's
> what the system cross reference tables are for.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "Carel Teijgeler" <coteijgeler@xxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 10/06/2006 02:15 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> rpg400-l@xxxxxxxxxxxx
> cc
>
> Subject
> Re: Table Definitions DDS or SQL?
>
>
>
>
>
>
> I still create new files using DDS, but have created some files using SQL.
> I find SQL cumbersome to define or to alter tables, as I am used to a
> reference file with DDS (still at  V5R1). If SQL syntax could be a little
> simpler to do that, I might use it more often. (haven't read the article
> yet).
>
> Some other aspects:
> How do you manage those CREATE TABLE and ALTER statements? DDS is kept in
> a
> SRCPF. Do you also use SRCPFs to keep those SQL statements?
>
> Reference fields can only be retrieved with DSPF to an *OUTFILE, not with
> an API, AFAIK. This applies for DDS created files. Is this also true for
> SQL created files?
>
> Regards,
> Carel Teijgeler
>
> *********** REPLY SEPARATOR  ***********
>
> On 6-10-2006 at 7:38 HauserBirgitta wrote:
>
> >>> I'm trying to convince the rest of the IT programmers to do the same,
> but it's a hard slog.
> >
> >make your collegues and even your managers read the following article.
> I'm
> sure they will be convinced using SQL-defined tables will be the
> >better choice.
> >
> >Modernizing Database Access The Madness Behind the Methods
> >By Dan Cruikshank
>
> http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/Performance_DDS_SQL.pd
>
> f
> >
> >IMO there is only one disavantage of SQL-DDL compared with
> DDS-definition:
>
> >In SQL reference files are not supported.
> >Sure a SQL table can be created as:
> >Create Table ...
> >      as Select ... From ReferenceFile
> >
> >But the references are not stored in the system tables, i.e. in the
> system
> tables only the absolute definition (such as Char(20) or Dec(11, 2)) are
> >stored. So, if you have to change a field/column definition, it is not
> enough to do a simple change reference file and actualizing the tables
> >with a simple CHGPF. You have to change the field/columns definitions
> manually in every table, where those fields are defined, by using the SQL
> >command ALTER TABLE.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.