Re: Table Definitions DDS or SQL?

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.