trailer

[murali dhar <hydchap1@xxxxxxxxx>]

DEar all,
==================================================
HEADER  20040331  CONFIRM  DATA                       
                
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050972700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO 
J017050972700679AYTSUBISHI TR & BKG -PORTFOLIO 
J017050932700679AYTSUBISHI TR & BKG -PORTFOLIO 
x017050942700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
x017050982700679AYTSUBISHI TR & BKG -PORTFOLIO 
x017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
TRAILER 000010
==============================================


The above is YSTMFILE which is flat file...
I need to pick up records from this file which should
contain 01705096

I have a written a query on this file ystmfile to
generate a flat file YSTMFILEO.(In query I have
written substring on the only field of this flat file
from 2 to 8 in selection of records.)

Since YSTMFILE is having correct date 20040331  I can
extract HEADER from YSTMFILE 
and then add to my final file YSTM(in addition to
YSTMFILEO )

My problem is Iam not able to generate TRAILER records
for this, if any one  has already done this kind of
stuff , please share with me I sincerely thank for
your help.If any one has written any easier
solutions/program  to the above problem, please share
with me. 

My final file YSTM  should look some thing like below
:
*********************************************
HEADER  20040331  CONFIRM  DATA       
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO 
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO 
x017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
J017050962700679AYTSUBISHI TR & BKG -PORTFOLIO  
TRAILER    00005     
************************************************
                                  

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/