Re: How do i select few fields in this file

Do you know how to do Query? Query allows a disk file for output. You may
select the fields you want, sort by fields, and even create result fields to
appear in your output file. 
 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Friday, October 31, 2003 5:41:09 AM
To: Midrange Systems Technical Discussion
Subject: How do i select few fields in this file
 
Hi all,
 
My cl program is as follows :
 
PGM
 
YCTAC200C REQSFILE(REQS) POSFILE(POSF1)
OUTFILE(JAC200)
 
ENDPGM
 
JAC200 file (with 12 fields) like as follows
 
FIRM OFF ACC ACCT CLS SUB SLSMN EQT EQTY IM EQTY EXCH
------ ----- ------ ------- ----- ----- ------ ----- ------ ---- ----
--------
 
Is there anyway I can copy this file(JAC200) into another file JAC2001 with
only 4 fields?....does copy file command allows me to pick up only 4 fields
from JAC200 to JAC201..I ve to include this copy file command to create
JAC201 with 4 fields only after the creation of the file JAC200 ..can some
one help me with ideas?
 
JAC201 should look like
 
FIRM OFF ACC IM
 
 
 
Thanks in advance for ur help,
 
Murali.