× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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/

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.