John, you don't mention it explicitly, but it seems likely that your Cache is running on Windows, and you have enabled the %Service_Telnet service so that your users connect to Cache from a telnet client (which could be Cache Terminal).

In that case, [@Robert.Cemper]'s answer to this post should help you. And if it does, please credit him by setting the checkmark / tick / hook alongside it.

[@Soufiane Amroun], please re-tag your post. Remove the "Developer Community FAQ" tag, which should only be used for FAQ-like postings about how the Developer Community platform operates. Then by adding a tag (or several) that better indicates what your question is about you might get an answer from the Community sooner.

Thanks.

John Murray (one of the volunteer DC Moderators)

Assuming you're using Studio, look at the View menu where there's an option called "View Other Code". This will open the generated INT if it is available. If it isn't, look on your Build menu and pick "Compile With Options". In the dialog that appears, set the checkbox named "Keep generated source code". Then click OK. After compilation finishes, try "View Other Code" (there's also usually a toolbar button for this).

I must admit I was unfamiliar with the xxxFunc() syntax Eduard's code used. So I decided to track it down in the documentation:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

That comes from the 2012.2 release notes and reads as follows:

Func() Method Added To Query Classes
A new query member method is available for use, Func. Func() accepts actual values corresponding to the formal parameters defined by the query. It returns an instance of %SQL.StatementResult. When the Func method executes successfully that instance of %SQL.StatementResult is a result set.


If an application has a class with a method whose name is the same as a query name concatenated with "Func", then a member method name collision will be reported at compile-time. Refer to the %Library.Query class for more information.

Setups are managed in the Security subsection of the System Administration section of Portal.

Key documentation is at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Parts specifically relevant to SQL access to data include: