Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] appending a line at the begining of the file
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] appending a line at the begining of the file
 Login/Join
 
Member
posted
Hello,

i have two files Say FileA and FileB.

i want to read the data from FileA and append it at the begining of the FileB. FileB already contains 10 records for eg... now after append FileB should have 11 records but the record which got appended from FileA should be the first record in fileB.

i tried it with FileDef (append as well as using the putddrec(....) function but that didnt help.

any help in this regard is highly appriciated..

Satish

This message has been edited. Last edited by: <Kathryn Henning>,


Data Migrator 7.7
service manager 6.0, 6.1, 6.5 and 8
 
Posts: 15 | Location: Ottawa, Canada | Registered: June 07, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
You want ot prepend, so how about appending fileb to filea, delete fileb, rename filea to fileb.
 
Posts: 2967 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
If you have Masters for both files and they have the same columns and formats, use the MORE command to merge the data of the two files:

TABLE FILE FILEA
PRINT *
ON TABLE HOLD AS FILEAB

MORE
FILE FILEB
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] appending a line at the begining of the file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.