Hi,

I open a specific file into a studio by using this command : Cstudio.exe /Servername=HEALTHSHARE/Namespace=User /files=MyClass.CLS

I would like not open a new studio when i execute a second time the command with one other file.

I would like open the second file in the same studio that the first file (I have to keep 2 calls)

For exemple  :

--> Studio is closed:

1 st call : Cstudio.exe /Servername=HEALTHSHARE/Namespace=User /files=MyClass.CLS

--> Studio open with my MyClass.CLS file

Last reply 16 hours 16 min ago
0   0 3
51

views

0

rating

Hi All,

I need to build a search using a lot of filters, what's the best way to implement my sql requests.

1 sql request per property, or only one "big" sql request ?

what's the disadvantage of using lot of indexes ?    Thank you

KR,

Amine

 

 

 

 

Last reply 23 hours 8 sec ago
0   0 2
50

views

0

rating

Hello All,

I am able to transmit a small batch of billing files: B/W 5 and 20 without issue- 
Put stream 11@%IO.LibraryStream to /SFTP/unmhsmcsa/OUT/TEST_021920201426.tst  

But when the size of the batch increases to over 20 the operation hangs and I receive the error below:   The file is created in the SFTP server with 0 data.

0   0 2
0

replies

23

views

0

rating

Hi all,

i‘m traying to run a sql LIKE Query on an attribute datatype LONGVARCHAR.

I also try allready with the SUBSTRING(Attribute,1,...), when i run the query, the resultat is empty without errors.

The Query:

 

select text from table

where text like ‘%abc%‘

 

many thx for help

BR

Darko

0   0 2
39

views

0

rating

I'm using Cache SQL and want the ability to choose a specific index.

I've boiled the problem down to one table and simplified the query down to

SELECT *
FROM Registration.PatResp
WHERE SchedApptNum=8450022

 

SchedApptNum is indexed, but instead of using that column, "Show Plan" indicates that it's looping through the entire Registration.PatResp table on Id (the primary key for the table).

I've done a tune-table with no change.

0   0 4
75

views

0

rating

Created a record map to read a flat-file of lab results.

Have multiple lines that represent result components for a given order per pt MRN.

Grouping these records together based upon the order number in a custom service to create a single XML message.

Within the XML message, there are some fields that occur once and some that occur one or more times.

Within the record map, the fields/properties that occur once are configured as "As %String. The fields/properties that occur more than once are configured as "As List of %String. 

Last reply 3 days ago
0   0 2
23

views

0

rating