go to post Robert Cemper · Apr 13, 2018 In order to use a table in an external DB you need to LINK this table to your Caché instance.There's a Wizard in Mgmt Portal System > SQL > Wizards > Link TableIt connects to your external table using SQLgateway and creates a proxy class in your namespacethat presents the table with all SQLnames ...( underscores, ...) as if it was a local table but with a special external storageThen you use this proxy class as you would do with a local one.Table 'WINSURGE_RESULT_FACT' should then be visible and accessible. It might be somewhat slower than Globals
go to post Robert Cemper · Apr 13, 2018 Hacker's advice:Create a SOAP client with Studio - Assist.Send your request anywhere and hijack it with TCPtrace or WireShark or similar.Now you have the string that you intend to modify and to send.Anyhow, I'm somewhat surprised about the subject.
go to post Robert Cemper · Apr 13, 2018 Mike,please create a new question as the solution is not related to the previous one.Thx.
go to post Robert Cemper · Apr 11, 2018 Evgeny,The type of mirror depends on how it should be used:for Disaster Recovery, it is important to get as much real-time date across as possible.it is irrelevant to have indices, cubes or similar in your (very) remote data center. so I'd recommend asynchronous Mirror / Shadow to feed it.What else you require can be generated from existing data. for High Availability, everything to continue / restart should be available permanentlyso my recommendation is Synchronous Mirror but in parallel, there is the recommendation to separate Production data from DeepSee cubesless for cube maintenance but fo queries. And that's really important! As a consequence, you would need a secondary mirror to provide high availability + performance alsofor your DeepSee cubes. Which is not a waste of effort as it allows load balancing across DeepSee. In any case, it is a tricky exercise to build, verify and manage such a configuration.
go to post Robert Cemper · Apr 11, 2018 Typically a Message in Ensemble is inheriting from Ens.Requeste.g. Class EnsLib.Testing.Request Extends Ens.RequestI have no Healthshare at hands to identify your correct messagejust to confirm Enslib.HL7.Message does NOT extend Ens.Request as it is a Persistent object on it's own.
go to post Robert Cemper · Apr 11, 2018 Your message might be locked by some other process at that time. Try to raise your Lock level to have exclusive access to your persistent object %GetLock(id) which you need during %Save() If it fails you should find out who else is locking it.
go to post Robert Cemper · Apr 9, 2018 That's mine: ClassMethod main(s As %Integer = 10){ f r=1:1:s w ! f c=1:1:s w $s(c=1!(r=1)!(r=s)!(c=s)!(c=r)!(s-r+1=c):"#",1:" ")}
go to post Robert Cemper · Apr 9, 2018 Check if Output Frame is open.IF it resists to appear.goto fullscreen modeclick to View / Output (ALT+2)If still invisible:move the mouse pointer slowly up from the down border to catch the top border of the output framepull it up to make is visible.
go to post Robert Cemper · Apr 9, 2018 select target namespace (e.g. SAMPLES)Find in files Find What: (e.g. person)file type (e.g. *.cls )uncheck all boxesforget all filterseventually check Search in System Items(Match case is a source of surprises )(Match whole word only is fair chance to see nothing)FIND and be patient to see the full result
go to post Robert Cemper · Apr 7, 2018 In Caché classes the general rule is to remove underscores for internal use.For Properties you have the parameter SqlFieldName to keep the original name and also use it for SQL access. (e.g. INSERT) Property AccessionDate As %Date [ SqlFieldName = ACCESSION_DATE ];
go to post Robert Cemper · Apr 7, 2018 " I found a utility in CACHE " which one ?most likely you might pass column names as string parameters "ACCESSION_DATE"
go to post Robert Cemper · Apr 6, 2018 Scott,if you use this just once a day there is no added value to keep the connection up.It's rather the risk that some piece in between terminates it and triggers an error on your side.With any value other -1 you disconnect or get disconnected but it's no error but expected behaviorhttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=ETCP_settings_outbound#ETCP_C220762
go to post Robert Cemper · Apr 5, 2018 Sorry to be late. I was busy today:Thanks to @Eduard LebedyukI did it in a traditional one-liner: 79 77 char. + 4 char extra to read the size.I'll wrap it into a method later to see how much waste of space this generates. 5 min. later:OK. Method consumes 3 char. extra {} to enclose it + blank at the start =>>> 82 80 ~3.9% overheads=1...4 looks odd but it improves.f j=1:1:15 zw j d ##class(DC.size).main(j) j=1#j=2####j=3#########j=4################j=5####### ### # ### #######j=6######## ### ## ## ## ### ########j=7######### ### # # ## # ## # # ### #########j=8########## ### # # ## ## ## ## ## # # ### ##########
go to post Robert Cemper · Apr 4, 2018 With Tool you just see already available tools.For new goto HELP.
go to post Robert Cemper · Mar 31, 2018 Evgeny,My SAMPLES has no listing 'Custom Listing' in HoleFoodsBut this works:SAMPLES>d $SYSTEM.DeepSee.Shell()DeepSee Command Line Shell----------------------------------------------------Enter q to quit, ? for help. >>DRILLTHROUGH SELECT FROM [HoleFoods] %LISTING [Customer Info] # ID Store Loc Country Product Customer Latitude Longitude 1: 1 Tokyo Japan Free-rang 2: 2 Shanghai China Lifesaver 3: 3 Sao Paolo Brasil Onion rin 4: 4 Paris France Ziti (box 5: 5 Santiago Chile Donuts (d 6: 6 Brasilia Brasil Ziti (box 7: 7 Madrid Spain Donuts (d 8: 8 Chicago USA Tortellin 46168 39.716036 -86.39506 9: 9 Frankfurt Germany Swiss Che 10: 10 Tokyo Japan Onion rinsimilar: >>DRILLTHROUGH SELECT FROM [Patients] %LISTING [Custom SQL listing] # PatientID FavoriteColor 1: SUBJ_100301 Green 2: SUBJ_100302 Orange 3: SUBJ_100303 Yellow 4: SUBJ_100305 Orange 5: SUBJ_100306 Purple 6: SUBJ_100307 Orange 7: SUBJ_100308 Blue
go to post Robert Cemper · Mar 31, 2018 There is no default %PCL.int as mnemonics for PCL printing in Caché.So according to the linkhttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GIOD_intro#GIOD_intro_definemnemomicyou have to write it yourself.But before this interesting exercise find a document on the control codes for your "low-end HP laser printer and a Brother laser"Your description is just to vague to google for it. you depend on the type an level of PCL.I tried and got 2.46 million hits on bold printing for Brother Laser.This one looked useful but I didn't read all 531 pages and I don't know your printer version.https://www.brother.com.au/pdf/support/controlcodes/PCL_Tech_Manual.pdfThis looked most useful:5.2.11. Selecting the stroke weightEsc(s#B (27)(40)(115)#(66) <1Bh><28h><73h>#<42h> This command designates the stroke weight of the primary font.Esc)s#B (27)(41)(115)#(66) <1Bh><29h><73h>#<42h> This command designates the stroke weight of the secondary font # is an integer between –7 and 7. A value of 0 signifies a medium stroke weight, negative numbers signifythin or light stroke weights and positive numbers signify bold stroke weights. If you select a light or bold stroke weight the command will only have an effect if the font is available in one of the three font locations.that means you should try first if your printer is covered:set bold1on=$c(27,40,115)_7_$c(66)set bold2on=$c(27,41,115)_7_$c(66)set bold1off=$c(27,40,115)_0_$c(66)set bold2off=$c(27,41,115)_0_$c(66);; let's test itopen prt use prt write # write !,"test1 " , bold1on, "text with bold1on ", bold1off, "text with bold1off",! write !,"test2 " , bold2on, "text with bold2on ", bold2off, "text with bold12off",!write # close prtfrom the description, it is not clear if 7 and 0 are characters or if this are binaries.you may need to replace it with $c(7) and $c(0). once you know the codes you may decide how to make use of it.
go to post Robert Cemper · Mar 21, 2018 ok• property Identifier as %String [ Calculated,Transient,ReadOnly ];http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?PAGE=CLASS&LIBRARY=ENSLIB&CLASSNAME=EnsLib.HL7.Message#PROPERTY_IdentifierUnique document identification string found at MSH:10 / MessageControlId in document contentYou can't set it. It gets calculated and is ReadOnly.Following http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?PAGE=CLASS&LIBRARY=ENSLIB&CLASSNAME=EnsLib.HL7.Messageyou should probably start with set Set HL7Msg=##class(EnsLib.HL7.Message).%New() and start to compose the message accordingly.
