Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Coding, syntax & commands
>Do you push into your tables as each segment is read, or do you get all the segments first?
>
>UPDATE: And how do you handle multiple messages in one file? Each MSH is the beginning of a new message and you loop accordingly?
>
SNIP...
Depends on your business requirements. In our LOB, we must import the entire file in one database transaction. We might have as many as 2000 transactions (messages) in a single file.
What happens if you have a run-time error during parsing? How easy is it to recover? Can the client resend a partial file? These some of the things to consider.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only