Re: SQL DDL Create Table Names

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Short answer: That was the way the application, which I inherited, was 
written.


Longer answer: Since I took over the programming chores, I have 
externalized "most" of the tables using DDS (though the original 
programs are still II, new ones in IV).  The original developer (bless 
his pea-picking heart) set up the data entry files (which use the S/36 
?WS? variable as part of the name) have the same layout as the, say, 
order header/line files.  In addition, he created intermediate (such as 
weekly and monthly) storage areas that, also, have the same layout. 


Actually I do have multiple libraries for data, usually by company.  Or 
other, less sane, reasons.  It is, in short, the application, not the 
S/36 environment. 


Question: That applies to the original question, How?


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



rob@xxxxxxxxx wrote:
> I am trying to think of why I would need tables with exactly the same 
> layout, but different names.  It isn't because you are still running in 
> S/36 mode and, therefore, cannot use multiple libraries to stick your data 
> in, is it?
>
> Rob Berendt
>