Posts by water huang on InterSystems Developer Community

Question

water huang · Nov 30

property of %Library.DateTime export to xml

I create a class, property OPDT as %Library.DateTime,the class extends %XML.Adaptor，after run " d obj.XMLExportToString(.xml)" OPDT`s value is 2023-11-28T13:57:26,but what i need is 2023-11-28 13:57:26,so is there any solution?

#XML #Ensemble

0 7

0 116

Question

water huang · Apr 23

i meet a problem when use %SQLGatewayConnection

i use %SQLGatewayConnection to insert data to mysql from xml，when if the value`s ascii of any field in the sql equal to 57659 ，

#ODBC #SQL #Ensemble

0 1

0 113

Question

water huang · Apr 6

how to quickly move data to oracle

hi,I meet a problem,i want to move huge data from ensemble to oracle.it`s about 3years business data.i have tried some case！

1. EnsLib.SQL.OutboundAdapter

i parse the data one by one,and translate it into inser or update sql statement then write to Oracle，it·s most slowly，and take more disk space。

2.save the data to a new table，and then use dbeaver transport data to oracle。

3.user linktable. save object as insert，but，i can·t user %openid method.

#Data Import and Export #Caché #Ensemble #InterSystems IRIS

0 1

0 231

Article

water huang · Mar 19 9m read

Tutorial from Real Practice in China Hosipital Infomatics Construction: How to autobackup your code/ auto excute code when you are not allowed to use Git?

1.Background

1.1 I met a few project that their interface servers were crashed. Cutoms wanted resume server as fast as we can. their servers are running at lan,and they can't use git,there are some namesapce in the server running different service,and usualy there is only one server.

1.2 In the message,it has property in type of characterstream,as you know,the message search page doesn't support filtering with property of characterstream,so it's so hard to find the messge you want.

#Compiler #Tools #Tutorial #XML #Caché #Ensemble #InterSystems IRIS

10 11

2 516

Question

water huang · Jan 23, 2021

how to parse a xml with xmlns and xsi:type attribute

<?xml version="1.0" encoding="UTF-8"?>
<ClinicalDocument xmlns="urn:hl7-org:v3" xmlns:mif="urn:hl7-org:v3/mif" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 ../sdschemas/SDA.xsd" classCode="DOCCLIN" moodCode="EVN">
 <observation>
  <value xsi:type="ST">xxxx</value>
 </observation>
</ClinicalDocument>

#XML #Ensemble

0 4

0 2.2K

Question

water huang · Nov 24, 2020

how to call a dll file's method use $zf function ?

i have looked for $zf function，it says $zf(-6) will work,but it doesn't work out actually,anybody can give me a dll file which will work with $zf,if you should show me the way making the dll that is best!thanks!

#.NET #Ensemble

0 7

0 347