RE: identity/automatic increment with DDS

Walden,

But you can use the GUI builder to build the table and then the
"GENERATE SQL" to retrieve and save the "source"  for the table.

However, it's not the prettiest source you've ever seen.

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

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden 
> H. Leverich
> Sent: Tuesday, December 13, 2005 9:41 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: identity/automatic increment with DDS
> 
> >...from the pop-up menu by selecting New then Table.
> 
> I'd be hesitant to create tables through that interface -- most change
> control officers I know don't take kindly to requests that they "right
> click" something to promote a new object into production. <G> 
> Seriously,
> using the prompted/guided/wizard interfaces has a major 
> drawback of not
> directly giving you source code to add to your change control 
> process. 
> 
> Once you've create a table or 20, the CREATE TABLE statement isn't all
> that hard to type into SEU and then you can create the table 
> w/RUNSQLSTM
> and still have "source code" for your SQL-created tables.
> 
> -Walden
>