The first two systems I worked with using InterSystems technology were a PDP-11 running M11+ and a VAX 11/750 running M/VX. Too many years ago to count! 😊
Since then I've used most, if not all, InterSystems products up to IRIS and HealShare today.
I'm italian living in Switzerland and I work as Senior Consultant at GAIVOTA consultin SA, we provide professional services for InterSystems and other technologies.
Curiosity: apart from DC, I don't have ANY social account! 😁
Can you please provide some more details on "columns that are larger than the typical string length"?
How long (max) can be?
What's the data type for these columns in the external database?
What database are you connecting to? Using ODBC or JDBC?
InterSystems offers specific training course for Building and Managing HL7 integration periodically available in InterSystems offices, remote/online and on customer site.
To get detailed info and take advantage of what it's available in InterSystem Learning, click the Learning link on left top of this page.
There you can find plenty of material regarding HL7v2 and MUCH more.
An excellent starting point would be to start with what's freely available for self learning, with a quick search I found couple of Learning Path on HL7v2:
Building Basic HL7 V2 Integrations with InterSystems
Building Advanced HL7 V2 Integrations with InterSystems
In addition to these Learning Paths there are additional more specific resources for specific topics.
In the Developer Community there are many HL7v2 articles you can learn from and maybe browsing HL7v2 related questions and provided answers can help learning.
Last but not least, in Open Exchange (fourth link on top of this page) also contains many HL7v2 projects you can learn from.
Regarding certification, please check InterSystems Certification Program, link on top of this page.
Enjoy learning! 😊
Hi Scott,
I don't consider 255 as larger than the typical string length and I'm surprised of your issue and I don't fully understand your code, probably because it's not complete (set tSC = rs.Insert(pInput) make no sense to me).
Anyway, my suggestion is to find some more info that may give you some hint.
For example I'd add the following lines in your OnProcessInput() method:
Set colId=pInput.GetColumnID("ExternalName")
$$$LOGINFO("ColumnType is "_pInput.GetColumnType(colId))
$$$LOGINFO("ColumnSQLType is "_pInput.GetColumnSQLType(colId))
$$$LOGINFO("ColumnSize is "_pInput.GetColumnSize(colId))
Please test this using a query that extract a few records to avoid flooding your event log.
I'm curious to see what you get.