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] Processing a file with multiple recordtypes
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Processing a file with multiple recordtypes
 Login/Join
 
Gold member
posted
Hello

I have a file with three recordtypes. Each recordtype has a different layout. The file is fixed-lenght 100.
The three records can be distinguished by the recordtype. That is the first position, alafanumeric:
recordtype 0 is the heading record, containing a date and sequencenumber of the file
recordtype 1 is the data record, containing all the attributes
recordtype 9 is the trailer record, containing a field that tells how many records were in the file

We are still using three separate masterfiles, but is it possible to describe this in one masterfile?

Can I then embed this in a dataflow in Datamigrator, whereby my source is the file and the target is a table?
So I can map file attributes of the datarecords (recordtype 1) to the attributes of the target table?

We try to do everything in the Graphical User Interface.

We have DMC release 81M gen 833

Thnx
Ron

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 94 | Registered: August 29, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The answer is yes. Start with this:
https://webfocusinfocenter.inf...e/db_heritage107.htm


WebFOCUS 8204, Unix, Windows
 
Posts: 1419 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Ok, and I suppose that in mine example we are talking about : "◾The records have no meaningful positional relationship"?

I will read the url you referred to and see if I can build a dataflow reading a file and writing to a table. Thnx a lot. Come back to you if I encounter any issues Smiler


WebFOCUS AppStudio 8.2.02M
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 94 | Registered: August 29, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Processing a file with multiple recordtypes

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