[Matthew Seacat]

We use PERL scripts on our AIX server to send and retrieve files from SFTP servers.  If you are interested in this I can send them to you.  It works really well for us and we just setup cron jobs to run them as often as we need to.

[Matthew Seacat]

Thanks Jim, I couldn’t find that the HXX is a standard HL7 segment.  I am going to try to turn this into a Z segment to see if it will resolve my issues.

[Matthew Seacat]

With the help of Jim I was able to get this working.

[Matthew Seacat]

We are using perl to stop and start threads.  Here is what we are doing.

$siteName = “your_site_name”;

eval `/qvdx/cis5.8/integrator/sbin/hcisetenv -root perl /qvdx/cis5.8/integrator $siteName`;

#print `showroot`;

#print $ENV{HCIROOT};

#print $ENV{HCISITE};

#print `showroot`;

#This will stop the thread

`hcicmd -p p8 -c “your_thread_name pstop”`;

#This will start the thread

`hcicmd -p p8 -c “your_thread_name pstart”`;

[Matthew Seacat]

in my odbc.ini file I have the driver pointed to Driver=/qvdx/cis6.0/integrator/lib/Connect7.0/lib/CVsqls26.so

[Matthew Seacat]

David, Thanks for the sample code but running into an error when I try to run it and didn’t know if you had run across the same issue or not.  The error message is saying it can’t find the driver when it hits the piece of code that does the SQLConnect.  Any ideas how to fix this?

cannnot find Driver keyword entry for data source XXX[xlt :xlat:ERR /0:itsengine_xlate:–/–/—- –:–:–]     while executing

[xlt :xlat:ERR /0:itsengine_xlate:–/–/—- –:–:–] “odbc SQLConnect $hdbc $dbserver SQL_NTS $dbuser SQL_NTS $dbpwd SQL_NTS”

[Author]

Replies