Browse Prior Art Database

Descriptions of conditions statement for Interface File Record value transform

IP.com Disclosure Number: IPCOM000016080D
Original Publication Date: 2002-Jul-31
Included in the Prior Art Database: 2003-Jun-21
Document File: 1 page(s) / 50K

Publishing Venue

IBM

Abstract

Disclosed is a Solution to express the conditions of value transformation of Interface file simply and easily by using statement and relative mapping file. The inventions explain notations and how to write conditions statement and mapping file. 1) numbers of conditions statement means each data item position of record

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 93% of the total text.

Page 1 of 1

Descriptions of conditions statement for Interface File Record value transform

Disclosed is a Solution to express the conditions of value transformation of Interface file simply and easily

by using statement and relative mapping file.

The inventions explain notations and how to write conditions statement and mapping file.
1) numbers of conditions statement means each data item position of record
2) prefix 'r' of conditions statement means that condition values influence
on only each row of mapping file.
prefix 'c' means that condition values influence on all rows of mapping
file.
3) mapping file format is csv style , and items without last are as same item
as conditions statement in order.

Last item means values after transformed.

Sample Foramt of Interface File number type name transformation conditions

1char key 2char name 3char id
4 char item_name 5char date
6 char location ( r1 and r2 ) or c3 7 char price
*) conditions statement is '( r1 and r2) or c3'.

It means that 6th item, name is 'location' ,is to be transformed,

if the values of 1st item, name is 'key' , and 2nd item, name is 'name' are same as mapping file

or the values of 3rd item, name is 'id' , is same as mapping file.

Sample of mapping file

A0001, B001B, 0001, DD001 A0002, B002B, 0002, DD002 A0003, B003B, , DD003 A0004, B004B, , DD004 A0005, B005B, , DD005 A0006, B006B, , DD006
*) conditions statement is '( r1 and r2) or c3'. Prefix of 1st and 2nd items is 'r' ,so 1st and 2nd items must have value. Prefix o...