Hi everyone, i cant understand what is wrong in my query:

ALTER TABLE MyNamespace.MyTable ALTER COLUMN CurrentColumnName RENAME NewColumnName

I just want to rename column name using sql.

I could not find any life example using this syntax.

SQLCODE for this query is -25:

-25 Input encountered after end of query

Quote from documentation:

0 12
0 515

Hi all,

I am trying to use a %Status property on some of my Response classes. If the execution of a service goes wrong, I set the %Status property on Response with the value $$$ERROR($$$GeneralError, "pre-defined error message").

When I check the visual trace for this message and look for the %Status (property "status_code" on the image), it is displayed like this:

If I select to display the Body of the Response, I get the 'readable' form of %Status:

0 1
0 270
Question
· Sep 14, 2017
Conflict Resolution Wizard

Hi

When trying to sync a class to the server where the server class has been updated by another user, I, as expected, get the Conflict Resolution Wizard.

I can then use the wizard to copy code from the server side to my local copy using the arrows also as expected.

But when I have integrated the remote code into what I think is my local copy how do I save it so that it gets integrated into my local copy and synchronised to the server.

0 9
0 508

Does anyone have experience using SCCM or any other enterprise application management tool to deploy updates to a thick client (internally developed standalone app) across the enterprise? I have a client that is attempting to get this working for their customer and running into some trouble. If you have any knowledge or experience you can share it would be greatly appreciated.

I have read some MS Technet pages that appear to indicate this is possible

0 2
0 445

Hi Team,

Can you please help me to develop EDI X12 to XML and XML to EDI X12 conversion in IRIS 2021.1 for EDI 204, also known as Motor Carrier Load Tender?

Also, suggest flow for how to achieve this kind of functionality in InterSystems IRIS. If you are able to provide some Videos/Documents on the EDI X12 interface for 204 then it would be very helpful for me.

Thanks,

Harshdeep Acharya

0 1
0 331

Hi

Reading through the installation guide I found a fairly stern warning in the robustness checklist not to use the inbuilt apache web server.

>Use a robust web server. Do not use the limited Apache server installed with
>Ensemble. It is provided as a convenience for use on development systems and
> is not a fully capable web server.

We only have a few users, the Interface team (3), an integration consultant(1) and an interface monitoring/development vendor.

0 2
0 370
Question
· Apr 4, 2022
FTPS TLS session resumption

We are attempting to update some old FTP interfaces to use FTPS and having an issue with an outbound operation to a FileZilla server.

The connection to the the server works, however it fails to transfer files with the error "TLS session of data connection not resumed."

It appears that "TLS session resumption" is no longer optional in FileZilla Server, and I cannot find any details in the IRIS documentation about it.

Does IRIS support TLS session resumption, or know how to set up FTPS to a recent install of FileZilla Server?

0 3
0 734
Set httprequest=##class(%Net.HttpRequest).%New()
	Set httprequest.Server="www.intersystems.com"
	Do httprequest.Get("/")
	Do httprequest.HttpResponse.OutputToDevice()
	Do httprequest.Get("/cache/")
	Do httprequest.HttpResponse.OutputToDevice()

The above is the code which i found in this link http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

0 5
0 3.2K

Hi,

I'm very new to InterSystems Health Connect so may be doing something silly...

I'm trying to link to an Oracle DB view using the Link Table Wizard in the Management Portal. The wizard finds the view, but when I select it and click the 'next' button I get an error on the 'Select Columns' screen: 'ERROR #5534: Columns error' (and no columns show in the wizard). I've tried on several views and tables in the same DB but keep hitting the same error.

0 1
0 257
Question
· Apr 27, 2022
Maximum allowed System Tasks

Hi guys,

We have created a utility to allow users to create a System task for a list of items the same way it’s done via SMP (attached below), the problem is that there may items and those systems tasks will grow a maybe exceed a couple of thousands so :

0 1
0 189

Hi Guys,

How do I add another tablepane or gridview to make my tablepane look like expandable and collapses back as in the below pic?

so basically I would like to add a child tablepane or gridview for each row that populate the related details for it.

0 1
0 160

Hi Team

I have enabled Data Quality manager on InterSystems healthshare Patient Index and the SSN field holds south african Identity numbers on our system.

I would like to modify the rule to validate according to South African ID number and not SSN. Data quality manager classifies this South African Identity numbers as Invalid because the rule is based on SSN.

Please see the current and default SSN rule below and advise how I can go about accomplishing this task, if anyone has that rule please share how it's done.

0 3
0 197