[Mark Perschbacher]

Oops, it might have helped if I cycle saved the thread and not the process.  Never mind 😳

[Mark Perschbacher]

Just my two cents, I just completed a pretty involved CASE with Lawson regarding transition from 5.6 to 5.8.5  I created the CASE as a level 3, and it took just shy of two hours for them to respond.  Since it was a test enviroment project, I thought their response time was okay, not great.

[Mark Perschbacher]

Keith, that did the trick, many thanks.

[Mark Perschbacher]

Bill, thanks for replying.  Well, I pasted that into the reg. expression window, but it didn’t find it.  I’ll play around with it some more.

[Mark Perschbacher]

Robert, thanks for your reply.  Yeah, I think the X11 window is the issue.  I’m running on a Windows 2003 server, and there isn’t an X server available.

[Mark Perschbacher]

I am about finished evaluating the upgrade of the same versions you are looking at.  The only big thing I have found is that with 5.7, the tcl gdbm function has been replaced by sqlite.  In the long run this is probably a good move, but I’m working with Lawson to develop a solution for a proc I have that is not working after the conversion to sqlite.

[Mark Perschbacher]

Gary, that is a really useful link thanks.  Man, I am getting close, here is the string I have in my proc

db “insert into Insurance (Last name, DOB, Gender, MRN) VALUES (‘$pt’, ‘$birth’, ‘$sex’, ‘$pid’)”

I’m getting ‘S1000 -1811 {[Microsoft][ODBC Microsoft Access Driver] Counld not find file ‘(unknown)’.}’

Guessing my command is not quite correct, any suggestions?  The variables are fields I’ve pulled out of an ORM in the beginning of the proc.

[Mark Perschbacher]

The package appears to have installed.  I went to Data Sources under Administrative settings to create a new DSN, but can’t see the tclodbc driver, which I assume should show up.

[Mark Perschbacher]

Gary, that appears to have worked, thanks a bunch!

[Mark Perschbacher]

thank you both for replying.  Gary, the setup script changes the tcl version to 8.1, must be the release of the package I downloaded.

Levy, I think you may have hit it.  I just Googled tclodbc, and downloaded the first one I found.  I’ll try and find the binary.

[Mark Perschbacher]

With Jim K’s help, I was able to get this to work.  I set up a field Interate, and on the source of the CONCAT action, I listed

1(0).1(0).0(0).OBR(0).#20(%f1).[0]

~1(0).0(0).0(0).DG1(0).#3(0).[0]

with a ^ Separator.  In the Dest.  I put

1(0).0(0).0(0).DG1(0).#3(0).[0]

What I get in DG1-3 is a reverse of OBR-20, but it should work.

[Mark Perschbacher]

Marcus, not sure if you can do it outside the thread.  I search through the SMAT data using the .msg files.

[Mark Perschbacher]

That certainly sounds like the issue, thanks Rob

[Mark Perschbacher]

Thanks Robert, Jim the whizz Koslowski helped me work through it.  I ended up using MATH ADD =1 $%s99 to $%s99 for both the group and segement iterate.  The trick was zero ing out %s99, and on the segement interate, useing the engine counter, %s1 on the source, and my counter %s99 on the desination.  Here is a screen shot

[Mark Perschbacher]

I concurr with David.  The source port usually jumps all over the map.  Filter on the IP address and port you are sending to.

[Author]

Replies