Design question...

[vrs1008]

Hi,

Can anyone suggest me a good option to design 270-271 system???

Requirement :
1. 271 data should have all the original information of 270 data.
2. Only Tracenumber and the sender id(270) & receiver id (271) is the key to link the two transaction.

I try to load the entire 270 in to database & reuse it but not too sure how much information to put & how to design tables for the same....


Regards,
Vibhav1008

 

[BocaBurger]

Do you need to store the info for long periods?

You can map a 270 to a 271. You can also take the original file and use the PACKAGE function to turn it to a text blob and stick it in your DB as a CLOB. Have a time stamp field and also send any unique info from the 270 to other columns to make retrieval easy.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[vrs1008]

Thanks for the reply Boca,

In our case:

DSTX will pass 270 to FACETS and then FACETS will return multiple 271 for the single 270. So if 270 contains 3 Inquiry then FACETS will return 3 271 (1 for each inquiry).

Since we are running in a batch, 271 may come after some time. so yes, we need to store information for some time.

Regards,
Vibhav1008

 

[vrs1008]

and only common information between those transaction is Trace number for each inquiry & sender id in 270 will be equal to receiver id in 271.

Regards,
Vibhav1008

 

[BocaBurger]

OK, so store the trace # & sender ID also. When the 271s come back, get the infohe DB.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[vrs1008]

Thanks for the reply Boca,

In our case:

DSTX will pass 270 to FACETS and then FACETS will return multiple 271 for the single 270. So if 270 contains 3 Inquiry then FACETS will return 3 271 (1 for each inquiry).

Since we are running in a batch, 271 may come after some time. so yes, we need to store information for some time.

Regards,
Vibhav1008


Regards,
Vibhav1008