User bio
I've been Software Engineer and Java Developer for 20 years with 15 years working for the HealthCare sector.
Madrid
Member since Jun 13, 2022
Posts:
Replies:
The only way to insert info into a different database is to configure a sql gateway connection by JDBC and execute the SQL with the insert.
Just the first line?
set str=##class(%Stream.FileCharacter).%New()
do str.LinkToFile("c:\myfolder\file.csv")
set $listbuild(VALUE1,VALUE2,VALUE3)=$listfromstring(str.ReadLine())
Open Exchange applications:
Certifications & Credly badges:
![InterSystems HL7® Interface Specialist](https://images.credly.com/images/d235c8cf-2d11-49b8-86f5-a6a3e3481bcc/image.png)
![HealthShare Patient Index Training](https://images.credly.com/images/9226050c-cd94-4c22-9c6b-27bf2d8efcd3/image.png)
![Using InterSystems Embedded Analytics Training](https://images.credly.com/images/88fea4ad-ee7c-463d-9350-f44a763ae435/image.png)
![InterSystems Developer Community Expert](https://images.credly.com/images/0451c765-1220-41c0-b22f-7c777dbe17dc/image.png)
![InterSystems Developer Community Moderator](https://images.credly.com/images/288a3661-72e9-4275-a943-063ae9e7910f/image.png)
![Learning Path: Building a Server-Side Application with InterSystems](https://images.credly.com/images/f52ac135-4c16-48e0-b96b-5aafa2ddb3e4/image.png)
![Learning Path: Getting Started with InterSystems ObjectScript](https://images.credly.com/images/756127ae-aa5a-495d-a710-eb91506e34ef/image.png)
Global Masters badges:
![Blogger Badge](https://community.intersystems.com/sites/default/files/badges/blogger_badge_0.png)
![Reporter Badge](https://community.intersystems.com/sites/default/files/badges/reporter_badge_0.png)
![Influencer Badge](https://community.intersystems.com/sites/default/files/badges/influencer_badge.png)
![Curious Member](https://community.intersystems.com/sites/default/files/badges/curious_member_badge.png)
![Insightful Author](https://community.intersystems.com/sites/default/files/badges/297760167-e550c050-8b02-41e7-a41a-e482b4bad66f.png)
![Global Master of the Month](https://community.intersystems.com/sites/default/files/badges/gm_of_the_month_copy.png)
![DC Author](https://community.intersystems.com/sites/default/files/badges/dc_author_0.png)
Followers:
Following:
Have you tried asking to ChatGPT?