RE: Column stripping

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