|
In addition to the many other suggestions, why not do the SQL stuff in the data perspective of WDSC? Then, instead of doing the old cut-and-paste, you can right-click and select "Export to server". Don Whittaker --- Steve Richter <stephenrichter@xxxxxxxxx> wrote: > Where I am at we use SQL a lot. Model the queries > using STRSQL, then > cut and paste from the SQL editor to the CL editor. > The only advance > in the last 20 years is the windows cut and paste > feature! What about > a /bgn-sql and /end-sql block in CL. That would > make my sql code a > lot more readable. > > Then you assign column names in an SQL table that is > > 8 characters. > Use that table in an rpg program and the programmer > has to deal with > renaming the fields from the generated 8 character > name to the full > SQL column name. > > Hoping someone can prove me wrong on all of this. I > only have 1 week > experience programming SQL on the 400. :) > > -Steve __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
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.