Hi, what’s the best way to check if your query return 0 records?

Greetings.

We have one vendor who requires us to send data using TCP

through an SSH port forwarding tunnel that is set up in advance.

UNIX scripts maintain this, and the Ensemble interface uses a TCP Adapter.

I was thinking that Ensemble could maintain the SSH tunnel,

which would improve our detecting of issues.

Has anyone done something like this?

I see that the class %Net.SSH.Session has a method ForwardPort,

but it doesn't stand up the tunnel by itself. Instead, it appears

Hi,

Can you provide a link to a valid license key zip file as the previous key expired December 31st, 2017.

Many thanks.

Hi,

I need to do a DELETE and then do some INSERT transactions on a linked table and don't want the DELETE and need to be able to ROLLBACK the DELETE if any of the INSERT transactions fail.
I have tried Object Script transaction processing (TSTART, TCOMMIT and TROLLBACK) and the SQL transaction processing (START TRANSACTION, COMMIT and ROLLBACK), but neither work.
Could I be doing something wrong in the way I am implementing these, or do does transaction processing simply not work for linked table?

Thanks for any advices, in advance.

Neil

Hi Friends,

I have created and exposed a web service for the given WSDL.

daily 500+ requests are processed via this SOAP service in live.

after 2 days live server got stopped with no web sessions available.

We removed this SOAP service, now live is working fine. We are investigating why web sessions got increased.

Could you please give me any clue, as to why web sessions got increased with the unknown user while processing requests through SOAP service?

Thanks,

Prashanth

I have a batch and would like to see the records in it on a terminal

First will use .%OpenId(Id) then will want to get the first record something around GetAT(1) with this I get the object reference but will actual need to see the data any help

How to download or send images to excel

I need to embed an image in excel when exporting a report, but I can not.

Can anyone help?

I am trying to write a generic process that will take any incoming message but would like to know where it came from so in my code I would like to do something like this

If (Document.Source="some serviceorProcess").

Just to be clear in the route you get these features is there a way of accessing them in code

I have an Enslib REST web service using an http host. How can it be converted to use https?

trying to open this view from Atelier Explorere somethimes give me "java.lang.NullPointerException", sometimes "the resource is not on teh build path of a Script project"...

it's not reasonable why you have this menu-item within atelier explorer but not within project explorer...

atelier version 1.2

The row expression defines what dimensions and measures appear on the rows of your pivot table as well as how they appear. Sets and CROSSJOINs are used.

3394731190001

I would like to know any experience working with OPC UA standard in industry sector or IoT. Currently there is no adaptor implemented in IS IRIS for it but it seems to be pushed as the main standard in industry. Did anyone had to implement their own libraries or adaptors to deal with it? Or do you advice to use any already implemented library in Java, Python,...? Any feedback would be appreciated.

I am quite new to Studio and I have been a Microsoft guy for a very long time and spoilt because of the short cuts provided and the flexibility of the IDE. Any tips and tricks for me to make my life easy while using the studio?

Hi all!
I need to call an API that has the following characteristics:

• Content-Type: application / x-www-form-urlencoded
• Authorization: (with a "Bearer" token)

In the body the information is given through the form data.

I can not find documentation on how to make this call and how to get the answer (JSON).

Could you help with an example?

Thank you