thank you Jeffery, Yes I am able to send them emails so that works. I'm going to do a bit of testing here and see. Will update when I find something.

yep, will do that and update if I find something or if I am able to progress

Thank you so much Eduard, this solved my issue.  Thank you for the advice, and the solution, really appreciate it

Hi Sean, thank you for replying to my request. Using the above code, I am getting just RORMS, I am not getting the last character.

$e(name,3,*-0) worked.

Thank you so much. I am grateful

Hi Robert, thank you so much for the answer. But I am dont have a ENS.Director class in my list of options. Can you advice what I would need to do in this case? I tried creating both in GUI and in studio and both dont have the option

sorry if I sound silly. I am just learning

Did you mean I can create a class [Class test.BS.CheckValues Extends ENS.Director]?

Regards,

Eric

Thank You so much Robert, Chris and Steve for giving me a direction. Steve, thank you for so clearly explaining it to me. I appreciate the time taken to explain every bit of it.

It helped me a lot.

Regards,

Eric

Thank you so much Jacques. That was really helpful. I was able to build my solution

Hi Vladmir, thank you so much. I just saw your answer.

Hi Sean, 

Thank You so much. I will give the above a try. By the way, if I want the global to display like below, what can I do?

Also, can you advice what does "<>W" do?

^People("Customers", "Acc.divison", "1234.567")

^People("Customers", "Acc.divison", "1235.987")

^People("Customers", "Acc.divison", "3214.879")

Hi Juilan, 

The space was the first thing I checked, and it seems to be ok. I logged into the mirror portal, and can see the the status says "waiting". Is there anything that I can do in this case?

Thank you so much for responding to my query, I appreciate it

Thank You Erik, thats what I've done..

Hi John, thank you for responding to my query. I have added a brief structure of my code in the question now. Would appreciate some help on this

The above error is what I get from the prepare statement. It works perfect in our test environment but on deploying to the LIVE server it gives this error. It is the same code copied over. Baffles me.

Hi Jeff, thank you for responding to my query. Yes, I found that when I output to string the '.' doesnt appear. so am trying to do it in a different way. Do you by any chance have a sample code to build new message segments?

I was able to split the messages, but now trying to find out how to create additional OBX segments.  I tried InsertSegmentAt, NewSegment, but all of them are giving me errors.

Thank you once again

I did the following so far:

1. Split the OBX: 5 into a list of values

I want to now insert each of them into new OBX segments: Highlighted where I have an issue.

Hi Jeff, thank you so much for guiding me on this. I tried to do it the DTL way, but getting an error. Can you advice what I am missing? Tried adding the segments but still getting the same error.

Unfortunately, the vendors want it that way that the notes are in separate OBX segments. they are charging us a bomb if they need to make changes so trying to modify it

Below is the error I am getting:

Thank You so much Jeff.. This has been so helpful. I appreciate your help in guiding me on this.

Hi Julian, thank you for pointing that out to me. Can you advice how I can remove that segment?

the message coming in is an ORU_R01 message, and contains an EVN segment, however in the schema 2.4 there is no EVN segment in the ORU message structure. so how can I remove the segment, is there a way to do that? Sorry for the hassle.  

I want to pass this message to the third party system having the EVN segment removed. Will keep trying but if you have any ideas would apprecaite.

Thank you

Hi Jeff, I tried that, but I am losing the rest of my message. I must be doing something wrong. Can you advice? Following is the error I am getting  once I remove segment and pass the messsage

Yes Jeff, I was looking at the cloned message that was sent across. I removed by index now, and it works. so looking good. Thank you so much for guiding me on this

You are spot on Jeff. Yes, I was thinking if I should update the schema.. but didnt do it. The message we are getting is an ORU_01 but has the EVN segment.  Thank You, now I know what caused my issue too.

Thank You Julius, I was able to connect to the mySQL DB using the SQL gateway Connection Class. I assumed that there would be a different class to connect.

Hi Guillaume, thank you so much for the screenshots and explaining it to me. I was able to establish the connection and no errors when my query runs but the data doesnt get updated in mySQL DB. Can you advice if my insert statement is correct?

set pQuery = "INSERT INTO TABLENAME(column1, column2, column3, column4, column5) "
 set pQuery = pQuery_"VALUES("_value1_","_value2_","_value3_","_value4_","_value5_")"
 set sc=conn.Prepare(hstmt,pQuery)

set sc=conn.Prepare(hstmt,pQuery)
   if $$$ISERR(sc) quit sc
   //Execute statement
   set sc=conn.Execute(hstmt)
   if $$$ISERR(sc) quit sc

Hi Julius, thank you for responding to my query. It seems like it is failing on "EXECUTE". 

The Error is : ERROR #6022: Gateway failed: Execute

Tried the set Param to bind the parameters and getting the same error. Any suggestions what could be causing this? The user has full access to the Database. It is a MYSQL DB, I have had no issues connecting to a SQL DB using the same steps.

ODBC Connection is successful. Driver I am using is MySQL ODBC 8.0 Unicode Driver

Any suggestions or advice on what I could check? I am able to ping the server as well

Regards,

Eric

Hi Eduard, thank you. I tried the set param binding as well but it seems that it could be an issue with my Gateway connection.

I tried linking the table and then testing my query and got the following error. The connections are all fine so dont know what is causing this

Any advice or suggestions?

Regards,

Eric

Thank you Eduard,

Same error running a SELECT statement as well.

Is there anything that you suggest before I consider having to make changes to the conf file?

Regards,

Eric

Hi Julius, Thank you

Yes, the driver installed is matching the cache architecture and using WINSQL I am able to successfully run the SELECT and INSERT query.

So its something in my code I guess? Will keep trying

Regards,

Eric