RE: Column stripping

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Y'all

Martin Rowe (I think) has a command line SQL statement processor at 
<http://www.dbg400.net/download/extras/excsql/excsql.zip> that breaks the 
long statement into the 55-character SETVAR values. There's an old one 
also, from Midrange Computing, that has a gotcha (maybe) when you have a 
string of blanks that crosses a 55-character boundary, but it's pretty 
simple. I have the source, if anyone wants, contact me privately. It 
basically uses Joel's technique, with a QM query that is like

   &A&B&C&D&E&F&G&H&I&J&K&L&M&N&O&P&Q&R&S&T&U&V&W&X&Y&Z

The MC version lets you save the statement to a source member, from which 
it will run it again.

You would need to know the field list - maybe you have a subfile select prompt?

hth

vern

At 10:11 AM 1/7/2003 -0800, you wrote:
> This does use SQL, but it's free SQL.  Create an query management query
> something like:
>
> select &fields from &filename
>
> If you run it from the command line interactively (STRQMQRY), you'll be
> prompted for a comma separated list of fields and a file name.  The list of
> fields in one substitution variable can only be 55 characters long, but
> (I've never tried this) it seems like you could have more than one
> substitution variable to contain fields and leave the ones you don't need
> blank.  It won't be pretty.
>
> All the usual cautions about running this sort of thing interactively apply.
> You can do it as a submitted job with output to a file, but you'll need to
> write a CL or a command and build some strings with proper quote syntax.
>
> > -----Original Message-----
> > From: Dhatha Thriyan [mailto:deardhath@hotmail.com]
> > Sent: Tuesday, January 07, 2003 9:13 AM
> > To: MIDRANGE-L@midrange.com
> > Subject: Column stripping
> >
> >
> > Hello All,
> >
> > Help Please.  I need to create a subset of a physical file
> > with some of the
> > columns stripped off the physical. I need to do this
> > dynamically without
> > using SQL . the OPNQRYF doesn't seem to be helpful in this respect.
> >
> > When I use Query/400, the column selection is static.
> > Everytime if you want
> > to change the column, you have to go into query and deselect
> > those selected
> > columns and select the new one. How do I do this dynamically
> > (on the command
> > line) ?
> >
> > ANy help would be really appreciated.
> >
> > Thanks in advance,
> > D