RE: Column stripping

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

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
> 
> 
> 
> _________________________________________________________________
> MSN 8: advanced junk mail protection and 2 months FREE*. 
> http://join.msn.com/?page=features/junkmail
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise
recorded by The Sharper Image corporate e-mail system and is subject to
archival, monitoring, review by and/or disclosure to Sharper Image security
and other management. This message is intended only for the use of the
addressee and may contain information that is privileged and confidential.
The contents of this message may contain personal views which are not the
views of The Sharper Image. If you are not the intended recipient,
dissemination of this communication is prohibited.