1 / 14

DAFUI Interface: Simplifying Flat File Data Manipulation

DAFUI enables changing flat file formats effortlessly without coding, reducing time-to-market and development costs significantly. Streamline data manipulation and simplify data routing with DAFUI.

sereno
Download Presentation

DAFUI Interface: Simplifying Flat File Data Manipulation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DAFUI Data And Function Union Interface

  2. DAFUI • Change flat file formats with no coding • Eliminates or minimizes programming tasks • Shorter time to market with less development time, reduced coding, and fewer testing cycles • Reduces resources, time to completion, and costs

  3. DAFUI CHARACTERISTICS • Character based data routing / manipulation is not limited to fields • Fields can be redefined dynamically with no programming structure changes • Buffer overruns are virtually impossible • Create DB-like views of flat data through a graphical interface

  4. Why it is easy • Input to output mapping done using pictures • Data is associated with editing and processing functions pictorially • Better accuracy can be assured by using actual data records to map interfaces • Portable to 99% of hardware and software platforms • No databases need to be set up or managed

  5. Why it is easy • No special operating system or special environment required • Easy and fast learning curve – interfaces can be specified in your favorite editor and saved as a generic text file (no need to learn a new environment )

  6. Output Data Structure Desired Input Data Source | | | | | | | | | Paul Saunier 25306088456408261969000157500003337100Westfield,NJ, 07076TEXT • Westfield,NJ, 0Saunier Paul000157500002530608845641969082633371003337100

  7. Output Data Destination Structure Input Data Source Structure | | | | | | | | | | • Paul Saunier 25306088456408261969000157500003337100Westfield,NJ, 07076TEXT Westfield,NJ, 0 • 0826 • 1969 • 3337100 • Paul • 00015750000 • Saunier • 253060884564 • Westfield,NJ, 0Saunier Paul00015750000253060884564196908263337100

  8. Current Art – Text Based Data Definintion Define Output: ( abbreviated ) outAddressPic X(15). outLastNamePic X(14). outFirstNamePic X(18). outAmountPic X(11). outAcctNumberPic X(12). outDateYYYYPic X(4). outDateMMPic X(2). outDateDDPic X(2). outPhnNumPic X(7). Define Input: ( abbreviated ) inFirstName Pic X(10). inLastName Pic X(12). inAcctNumber Pic X(12). inDateMM Pic X(2). inDateDD Pic X(2). inDateYYYY Pic X(4). inAmount Pic X(11). inPhnNumPic X(7). inAddress Pic X(24). • Move inFirstName of input to output of outFirstName • Move inLastName of input to output of outLastName • Move inAcctNumber of input to output of outAcctNumber • Move inDateMM of input to output of outAcctNumber • Move inDateDD of input to output of outDateDD • Move inDateYYYY of input to output of outDateYYYY • Move inAmount of input to output of outAmount • Move inPhnNum of input to output of outPhnNum • Blah • Blah • Blah etc

  9. Current Art – Script Based Function Directives • Write the program to move fields from the input to the output. Ex: Move inFirstNameto outFirstName. (for each field) • Compile the program, Bind, link, etc. • Move the object to testing area • Test it – format correct? , if not, go back and start over. • Really ! ?

  10. DAFUI Interface Specification Input record or message spec: ffffffffffllllllllllllaaaaaaaaaaaaDDMMYYYY$$$$$$$$$$$xxxxxxxAAAAAAAAAAAAAAAAAAApppp • AAAAAAAAAAAAAAAllllllllllllllffffffffffffffffff$$$$$$$$$$$aaaaaaaaaaaaYYYYDDMMxxxxxxx Output record or message spec:

  11. Example Interface Specification Input record or message spec: ffffffffffllllllllllllaaaaaaaaaaaaDDMMYYYY$$$$$$$$$$$xxxxxxxAAAAAAAAAAAAAAAAAAApppp | | | | | | | | | • Paul Saunier 25306088456408261969000157500003337100Westfield,NJ, 07076TEXT Westfield,NJ, 0 • 0826 • 1969 • 3337100 • Paul • 00015750000 • Saunier • 253060884564 • AAAAAAAAAAAAAAAllllllllllllffffffffff$$$$$$$$$$$aaaaaaaaaaaaYYYYDDMMxxxxxxx • Westfield,NJ, 0Saunier Paul00015750000253060884564196908263337100 Output record or message spec:

  12. Done ! • Easily adjustable. No re-coding, no compiling: faster, cheaper, less risk, short time to market

  13. What else can be accomplished? • You just observed the most simple function available in DAFUI technology. It can do much more. • Multiple output files can be specified, each in its’ own format. • Multiple input files can be joined using a common key field.

  14. Example Interface Specification Input record or message spec: ffffffffffllllllllllllaaaaaaaaaaaaDDMMYYYY$$$$$$$$$$$xxxxxxxAAAAAAAAAAAAAAAAAAApppp | | | | | | | | | • Paul Saunier 25306088456408261969000157500003337100Westfield,NJ, 07076TEXT Westfield,NJ, 0 • 0826 • 1969 • 3337100 • Paul • 00015750000 • Saunier • 253060884564 Westfield,NJ, 0 • 0826 • 1969 • 3337100 • Paul • 00015750000 • Saunier • 253060884564 • AAAAAAAAAAAAAAAllllllllllllffffffffff$$$$$$$$$$$aaaaaaaaaaaaYYYYDDMMxxxxxxx • Westfield,NJ, 0Saunier Paul00015750000253060884564196908263337100 • llllllllllllffffffffff$$$$$$$$$$$AAAAAAAAAAAADDMM • Saunier Paul00015750000Westfield,NJ0826 Multiple output record or message spec:

More Related