× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. October 2006

RE: Table Definitions DDS or SQL?

I use member type SQL all the time.

                          Work with Members Using PDM
S1059ZLM 
 

File  . . . . . .   QSQLSRC

  Library . . . .     CWLIBR               Position to  . . . . .

 

Type options, press Enter.

 2=Edit         3=Copy  4=Delete 5=Display       6=Print     7=Rename

 8=Display description  9=Save  13=Change text  14=Compile  15=Create
module...
 

Opt  Member      Type        Text

     CHKFG       SQL         Check for FG problems before close




Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, October 06, 2006 2:58 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Table Definitions DDS or SQL?

I forget.  It's not like I am using PDM or something to use a 
numbered 
option to "compile" them.  Sometimes I leave it blank.

Care to submit a DCR to give us a member type that will 
actually inspire 
the editors to care?  Would be nice to be able to verify them 
in WDSC. 
These are all used, but plain SQL isn't:
SQLC 
SQLCBL 
SQLCBLLE
SQLFTN 
SQLPLI 
SQLRPG 
SQLRPGLE



Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Mike <koldark@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
10/06/2006 02:47 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
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/Performa
nce_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.





-- 
Mike Wills
http://mikewills.name - Blog
http://theriverbendpodcast.com - Podcast
-- 
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.