Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Idea-A-Thon
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search
Language
EN|
ESPTJPCNFREN
New post
  • Profile page
  • Posts (8)
  • Replies (386)
  • Mentions (22)
  • InterSystems certifications
  • Global Masters badges (28)
  • Followers (5)
  • Following (0)
AllAccepted answers
    go to post
Marc Mundt · May 5, 2022

Can you clarify a bit?

Do you want to use curl to make an HTTP request to a web service running in Ensemble? Or do you want Ensemble to launch curl to make an HTTP request to an external web service?

0 0 https://community.intersystems.com/post/http-post-request?page=4#comment-189376
    go to post
Marc Mundt · Apr 29, 2022

You can put something similar to Jeffrey's logic directly in the Value of the Set action. Instead of using $E ($EXTRACT) you would use DTL's built-in SubString function:

..SubString("123456789",1,3)_"-"_..SubString("123456789",4,5)_"-"_..SubString("123456789",6,9)
0 0 https://community.intersystems.com/post/appending-or-inserting-characters-dashes-ssn?page=4#comment-189036
    go to post
Marc Mundt · Apr 26, 2022

Since this is a new design you should use persistent classes (SQL tables/objects) instead of writing directly to globals. A Data Transformation can use any persistent class as it's target, so this is also easier than storing directly in globals.

https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI...

0 0 https://community.intersystems.com/post/how-save-data-transformation-target-data-globals?page=4#comment-188731
    go to post
Marc Mundt · Apr 26, 2022

Is there already a defined structure for these globals/do these globals already exist? Or will you design something new?

0 0 https://community.intersystems.com/post/how-save-data-transformation-target-data-globals?page=4#comment-188721
    go to post
Marc Mundt · Apr 26, 2022

Can you explain more about your use case? What is the purpose of copying these fields directly into globals? Is there another application that will read the values from the globals?

0 0 https://community.intersystems.com/post/how-save-data-transformation-target-data-globals?page=4#comment-188706
    go to post
Marc Mundt · Apr 25, 2022

All persistent classes will save their data in globals automatically. It will save using the standard structures of the IRIS SQL layer.

If you have an existing global structure that you need to maintain you'll need to map your classes to your global structure. See this series of articles on how to do that.

1 0 https://community.intersystems.com/post/how-save-data-transformation-target-data-globals?page=4#comment-188581
    go to post
Marc Mundt · Apr 25, 2022

Have a look at this previous thread.

And there's a built-in capability in IRIS to see ports in use by different components.

1 0 https://community.intersystems.com/post/settings-ensconfigitem-returns-boxes-place-property-values?page=4#comment-188541
    go to post
Marc Mundt · Apr 22, 2022

I messed up the syntax:

&sql(select LIST(MessageName), LIST(Identifier) INTO :tMsgNmList, :tIdentList from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings)
0 0 https://community.intersystems.com/post/using-host-variables-embedded-sql-isnt-working-me?page=4#comment-188451
    go to post
Marc Mundt · Apr 22, 2022

How about this? Do the values returned in tMsgNmList and tIdentList match the values you're searching for?

&sql(select LIST(MessageName) INTO :tMsgNmList, LIST(Identifier) INTO :tIdentList from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings)

write SQLCODE, ":", tMsgNmList,":",tIdentList,!
0 0 https://community.intersystems.com/post/using-host-variables-embedded-sql-isnt-working-me?page=4#comment-188431
    go to post
Marc Mundt · Apr 21, 2022

If you try this what does it return?

&sql(select count(*) INTO :tCount from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings Where  MessageName = :tMessageName and Identifier = :tIdentifier)

write SQLCODE, ":", tCount,!
1 0 https://community.intersystems.com/post/using-host-variables-embedded-sql-isnt-working-me?page=4#comment-188361
  • first
  • ‹ previous
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • …
  • next ›
  • last
Marc Mundt
@Marc.Mundt
Sales Engineer at InterSystems Corporation
Open Exchange profile

User statistics

Posts
8
Replies
386
Likes
167
Applications
1
Badges
28
Followers
5
People reached
14.7K
Accepted answers
175

Social networks

InterSystems resources

  • Download InterSystems IRIS
  • Try InterSystems IRIS online
  • Become a partner
  • InterSystems IRIS on AWS
  • InterSystems IRIS on Azure
  • InterSystems IRIS on GCP
  • IRIS Community Edition on Docker
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
© 2023 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up