- This topic has 0 replies, 1 voice, and was last updated 16 years, 3 months ago by
.
-
Topic
-
I have a system that will be dumping a VRL record from an SQL database. It will contain several Fields of interest to this issue.
The Vendor, which I need to batch on and a series of claims 1 – ?? on.
For simplicity I will give an abbreviated definition and example of what goes in and what goes out.
This seems like it would be a perfect fit for HRL but the documentation really is lacking on how to use HRL. I have no doubt that TCL could be used to do this. But it just seems that HRL was designed with this in mind.
So I really would like to make it do the work.
Inbound Record.
VENDOR1,Claim1,……
VENDOR1,Claim2,……
VENDOR1,Claim3,……
VENDOR2,Claim4….
VENDOR2,Claim5….
VENDOR3,Claimx,……
VENDOR3,Claimy,……
VENDOR3,Claimz,……
The first two bytes indicate what the record type is.
There are more then this but these are the key segments.
Outbound Record.
A0VENDOR1
B0Claim1
B0Claim2
B0Claim3
A0VENDOR2
B0Claim4
B0Claim5
A0VENDOR3
B0Claimx
B0Claimy
B0Claimz
- The forum ‘Cloverleaf’ is closed to new topics and replies.
