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 Ideas Contest
    • 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 by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • Profile page
  • Posts (5)
  • Replies (6)
  • Mentions (0)
  • Official certification & Credly badges (0)
  • Global Masters badges (0)
  • Following (0)
  • Followers (0)
AllAccepted answers
    go to post
Alicia Watkins · Dec 15, 2021

hi..thanks for the code reference.  One more question, what if the query is long.  Can it still be set to a variable then called within the routine.    I can try to test that too.  I just wondered if you had executed a long query within a routine.

Thanks

0 0 https://community.intersystems.com/post/sql-method-use-mumps-routine#comment-175846
    go to post
Alicia Watkins · Dec 1, 2021

Hi,

Thanks so much for the help.  I am able to access the Task Manager.  Question, can an SQL query be set up via the Task manager wizard so that it will execute?

Thanks

0 0 https://community.intersystems.com/post/set-sql-query-management-portal-iris-data-platform#comment-174461
    go to post
Alicia Watkins · Nov 30, 2021

Hi There,

What I meant by filter is similar to the filters in Excel where a sort can be specified as an example.   In my routines, I take a delimited file and then can manipulate the logic based on the request.  The file can be created in Excel format.  Is this what you mean that you take files for use in Excel?

thanks

0 0 https://community.intersystems.com/post/filter-mumps-routine-excel-spreadsheet-file#comment-174281
    go to post
Alicia Watkins · Nov 15, 2021

hi...a mumps routine is basically object script that has been around for years and predates Cache/Ensemble etc.  IDX routines are from the Vendor  (Athena).  Do you have example of .int code where the SQL method is getting called.  Once the method is executed, where can the view be referenced?

Thnks

0 0 https://community.intersystems.com/post/sql-method-use-mumps-routine#comment-172816
    go to post
Alicia Watkins · Nov 1, 2021

hi...thank you for this comment....I remember the Task manager in Ensemble, but since we upgraded to IRIS, the System Operation selection is grayed out.  I submitted a case to the Vendor to see if I can get access.

Thanks again!

0 0 https://community.intersystems.com/post/set-sql-query-management-portal-iris-data-platform#comment-171271
    go to post
Alicia Watkins · Sep 17, 2021

Hi Vic,

Thanks for the quick response.  I have reached out to Athena for an answer on the version to upload and they have not responded yet to me.  I figured I would ask on the forum to see if anyone knew what version to download.

-Alicia

0 0 https://community.intersystems.com/post/cach%C3%A9-iris-upgrade-athena-idx#comment-167306
Alicia Watkins
@Alicia.Watkins
Follow
Open Exchange profile

User statistics

Posts
5
Replies
6
Likes
0
Applications
0
Badges
0
Followers
0
People reached
1.9K
Accepted answers
2
  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 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

Log in or sign up

Log in or create a new account to continue

Log inSign up