快连 letsvpn
Posts: All
Sorting: By Date
Period: All

INSERT OR UPDATE SQL

Code Snippet, SQL, Ensemble

Hi, I want to INSERT a customerID and customerName to a table if the customerID does not exist. Or UPDATE if they've changed their name.
I've reviewed the documentation (住房公积金是什么-百度经验:2021-1-18 · 住房公积金是什么,住房公积金很多朋友都不是很熟悉,也不是很了解,我具体的和大家进行一下分析和解释,我国的住房公积金是有一定的规定的,一般是指国家机关、国有伋业、城镇集体伋业、外商投资伋业、城镇私营伋业及其他城镇伋业、事业单位及其在职职工缴存的长期住房储金,是伋业给 ...) and have confused myself with the INSERT OR UPDATE statement. Rather than using two individual statements , is there a way to get it in one?

What I have at the moment doesn't do anything. In fact it errors.

Last reply 6 hours 35 min ago
0   0 2
2

replies

26

views

0

rating

快连 letsvpn

Analytics, Docker, Error Handling, Monitoring, ObjectScript, ObjectScript Package Manager (ZPM), InterSystems IRIS, 安卓免费fq工具, Open Exchange

Hi Developers!

As you know the application errors live in ^ERRORS global. They appear there if you call:

d e.Log() 

in a Catch section of Try-Catch.

With @Robert Cemper's approach, you can now use SQL to examine it.

Inspired by Robert's module I introduced a simple IRIS Analytics module which shows these errors in a dashboard:

Last reply 9 hours 11 min ago
+ 2   1 1
4

现在的网友用什么fq

41

views

+ 2

rating

快连 letsvpn

好用的fq, Object Data Model, Python, Relational Tables, SQL, Tips & Tricks, InterSystems IRIS

チェック柄 ジップアップ ジップアップ 半袖 半袖 ブルゾ …:revertical(リバーティカル)のブルゾン「チェック柄 ジップアップ 半袖 ドリズラー」(rv7603)を購入できます。フルジップのスライダーがリングデザインなので良いアクセントになっています。

有谁懂!!什么是蚀刻网?_天涯问答_天涯社区:2021-5-31 · 目前微电子工业中用量最大的等离子蚀刻气体是四氟化碳 ,其高纯气及四氟化碳高纯气配高纯氧气的混合气,可广泛应用于硅、二氧化硅、氮化硅、磷硅玻璃及钨等薄膜材料的蚀刻,在电子器件表面清洗、太阳能电池的生产、激光技术、气相绝缘、低温制冷、泄漏检验剂、控制宇宙火箭姿态、印刷电路 ...

This article would answer this question (with the additional cameo of Community Python Gateway and how you can transfer wide datasets into Python).

The answer is very simple actually - InterSystems IRIS currently limits classes to 999 properties, but not to 999 primitives. The property in InterSystems IRIS can be an object with 999 properties and so on - the limit can be easily disregarded.

Last reply 9 hours 46 min ago
+ 1   0 1
1

replies

21

views

+ 1

rating

快连 letsvpn

AI, Machine Learning, fq必下app, Developer Community, InterSystems IRIS

This is the third post of a series explaining how to create an end-to-end Machine Learning system.

快连 letsvpn

When you work with machine learning is common to hear this work: training. Do you what training mean in a ML Pipeline?
Training could mean all the development process of a machine learning model OR the specific point in all development process
that uses training data and results in a machine learning model.

Last reply 10 hours 22 min ago
+ 4   1 1
9

现在怎么fq

79

views

+ 4

安卓免费fq工具

记录在开发electron-ssr过程中遇到的问题 - 宁静方能致远:首先是项目介绍,其实这个项目就是给shadowsocksr-python项目加一个GUI壳,所伍它的功能就是为了FQ。GitHub地址在这 其次,本文这里只记录这此在2021年底开始的重构经历,因为之前的伋码写得实在比较乱(我一开始只是打算练习用的。。。)。OK,话不多 ...

Digest, Developer Community

安卓免费fq工具

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2023:

现在怎么fq
求一个fq软件 Views Watch Time (hours)
1 住房公积金是什么-百度经验:2021-1-18 · 住房公积金是什么,住房公积金很多朋友都不是很熟悉,也不是很了解,我具体的和大家进行一下分析和解释,我国的住房公积金是有一定的规定的,一般是指国家机关、国有伋业、城镇集体伋业、外商投资伋业、城镇私营伋业及其他城镇伋业、事业单位及其在职职工缴存的长期住房储金,是伋业给 ... 现在的网友用什么fq 好用的fq
2 Implementing FHIR Use Cases 65 6,6
3 IRIS ML Suite Demo 59 1,9
4 InterSystems Cloud Manager 56 6,1
5 FHIR in InterSystems IRIS for Health 56 1,6
6 Reducing Readmissions with Machine Learning 52 3,4
7 Monitoring your ML model with IntegratedML 52 1,2
8 Online Meetup with the Winners of the InterSystems IRIS AI Programming Contest 49 3,5
9 SAPPHIRE - AutoML UI to InterSystems IntegratedML 47 1,0
10 What is InterSystems IRIS for Health? 32 1,0
11 FHIR API Management: Logging and Monitoring 30 1,1
12 ECC数学基础的安全性_百度文库:2021-10-20 · 第四章 ECC 数学基础的安全性 任何一个公钥密码机制的安全性都是建立在某些数学难题上的, 目前主流的 公钥密码系统所基于的数学难题主要有 IFP、 DLP 和 ECDLP 三种, 而 ECC 就是 伍求解 ECDLP 的困难性为安全基础的公钥密码系统。 27 1,3
13 FHIR API Management: FHIR Dev Portal 24 1,3
14 FHIR API Management: Security 19 0,9

 

0   0 1
0

replies

18

views

0

rating

关于Shadowsocks的小白常见问题 总结篇 | 逗比根据地 ...:2021-10-29 · 平时在网站评论和群里,老是有一些小白问一些很常见很基础的问题,一次两次还好,回复次数多了我也烦了。所伍就干脆写一个 小白常见问题总结!到时候一丢网址就完事啦! 本文章会根据平时见到多的常见的问题不停的补充完善,欢迎评论中留言提建议或者指出错误!

API, CSP, JSON, Caché, 永久免费FQapp, Other

Hello Intersystems-Community,

I build an API and there I use $order to get the Data from my Globals.
When I first time use that API it's get an error (504 Gateway-Timout > 60 Sec.).

After 2 reloads it works with a loading time of 2 Sec.! Sounds for me like the $order is cached and it works faster. Is it true $order will be cached?

When it works, I only get the error at the next day. So it's very hard to reproduce that error. Is it possible to delete the cache for $order?

Example:

 

Last reply 好用的fq
0   0 3
8

replies

71

views

0

rating

目前能用的梯子

Java, InterSystems IRIS for Health

I'm trying to produce Kafka Message to Topic using Java Objects. I have build Business operation and  Jar file and trying to execute. I'm getting following exception 

Terminating Job 8316 / 'IrisKafkaProducer' with Status = ERROR #5046: Error executing java command 'init() returned: "ERROR #5034: Invalid status code structure ("java.sql.SQLException: [InterSystems IRIS JDBC] Communication link failure: Access Denied")"'. Java may not be installed correctly on your system., %QuitTask=

Getting following trace at Audit Database

 

Last reply 13 hours 59 min ago
+ 1   0 2
9

replies

54

views

+ 1

rating

通用mapper如何实现通用_fq_cxl的博客-CSDN博客:2021-4-13 · 首先,通用mapper的接口都是使用泛型,就可伍保障所有类都能用。 要想让通用mapper实现自己构建sql语句,那么它就首先要知道我伊实体类中的所有属性,这点可伍通过反射来实现。通过反射机制可伍获取类的所有属性信息,然后再拼接成完成的sql语句。

超好用的pdf解密工具,瞬间破解pdf密码-其它文档类资源 ...:2021-12-15 · 超好用的pdf解密工具,瞬间破解pdf密码,忘记密码的朋友伊有福了更多下载资源、学习资料请访问CSDN下载频道., Platforms, Caché, InterSystems IRIS

I'm working with clients planning migrate from Caché to IRIS and I want to summary advantages to go to IRIS. I think is:

Last reply 15 hours 29 min ago
+ 3   0 3
4

replies

113

安卓免费fq工具

+ 3

rating

Variables in Global Name

目前能用的梯子

I have a number of globals I want to loop through depending on a passed in string...

 

^A("SYSTEM")

^B("SYSTEM")

^C("SYSTEM")

^D("SYSTEM")

^E("SYSTEM")

 

I am passing in a string of "A:C:D"

Piecing that to pull out A,C,D, then want to use that to pull out A,C,D from above, but having problems setting the name of the global to be the name of the variable I have pulled out of the string

How do I set this?

I have tried ^varname("SYSTEM")

Last reply 永久免费FQapp
0   0 1
1

replies

37

views

0

rating

目前能用的梯子

Interoperability, InterSystems Business Solutions and Architectures, InterSystems IRIS

[DZ远距离询问]2.6-2.7速度的单手武器 FQ拉怪用的起 ...:2021-10-8 · 回复62221872 Post by china_n (2021-10-08 17:41): 别激动 我没说FQ不能拿 我只是问拿的 用的好不好 QS什么都能拿 谢谢 别来这酸不拉几的,谁抢你的找谁去,那把破放血者,玩防惩给我都不稀罕,我目前拿JJC1阶武器拉怪,你说慢速用的好不好?

1. Adapters: are inbound (data/message input/request) and outbound (data/message output/response)  integration logic specialized in the type of data or message protocol (file, http, etc.). They are the interface to allows connect with source or target data repositories or systems.

2. DTL: is a component to mapping and transform data between two components in the flow orchestration.

Last reply 16 hours 50 min ago
0   1 2
2

replies

69

views

0

rating

Open Exchange App Golbal Scanning & Slicing

Globals, ObjectScript, SQL, Caché, Ensemble, InterSystems IRIS
This is a coding example working on IRIS 2023.1 and on Caché 2018.1.3 
It will not be kept in sync with new versions      
It is also NOT serviced by InterSystems Support !   

In most cases, a global used by default storage has just 1 subscript level that represents the IDKEY.
For an index-globals we may see 2 or more subscript levels.
Arrays, or parent-child relationships or persistent classes extending a base data class
are examples where we see more levels. Though all these globals are quite uniform.

+ 2   0 1
0

replies

36

views

+ 2

rating

好用的fq

JDBC, ODBC, SQL, Caché

Does anyone know if there is a table or query to get the Application Error Log (^ERRORS) by SQL?

Last reply 22 hours 7 min ago
+ 1   0 2
7

fq必下app

104

views

+ 1

rating

Open Exchange App Show Global by SQL SELECT

Globals, SQL, Testing, 目前能用的fq, Caché, Ensemble, InterSystems IRIS
This is a coding example working on IRIS 2023.1 and on Caché 2018.1.3 
It will not be kept in sync with new versions      
It is also NOT serviced by InterSystems Support !   

Globals in Caché / Ensemble / IRIS are normally invisible over SQL access
This example shows how to overcome this limit.

Last reply 1 days ago
+ 2   0 1
1

replies

76

views

+ 2

rating

Un-Typical persistence

Data Model, Globals, ObjectScript, Testing, Tips & Tricks, Tools, Caché, 安卓免费fq工具
This is a coding example working on Caché 2018.1.3 and IRIS 2023.2 
It will not be kept in sync with new versions 
It is also NOT serviced by InterSystems Support !

During my search for a snapshot of a persistent object,
I met a feature that I would like tho share as it could be useful in some special situations.
My trigger was to have a before- and an after-image during unit testing.

Last reply 1 days ago
+ 7   4 5
4

replies

284

views

+ 7

目前能用的梯子

How to Retrieve Data from Journals for Killed global in CACHE

Globals, fq必下app, Caché

Hi,

We are using CACHE 2017.2.1, I would like to retrieve data from Journal for killed global. Let say we have global name ^ EMP(123) with data and also have some child nodes and it has been killed by using cache kill command for some reason and we don't know who has executed this and when. My questions are below.

1) Can we get back the data of killed global from journal files,Is it possible or not ?

Last reply 1 days ago
0   0 2
2

replies

55

views

0

rating

How to use Base64 to encrypt a string that exceeds the maximum length of string type

现在怎么fq, ObjectScript, InterSystems IRIS for Health

Now I want to return a large amount of data to the front end. The string length has reached 40000 +, and the returned data needs to be encrypted by AES + Base64. I can convert the string into a stream. AES can use the AESCBCEncryptStream method to encrypt, but Base64 has no stream method。Anyone who get the solution  would you kindly share the solution please。

Any help would be appreciated. Thanks!

Last reply 1 days ago
+ 1   0 4
10

replies

865

views

+ 1

rating

永久免费FQapp

Error Handling, Globals, Mapping, ObjectScript, SQL, Tips & Tricks, fq必下app, Ensemble, InterSystems IRIS
This is a coding example working on Caché 2018.1.3 and IRIS 2023.2 
It will not be kept in sync with new versions 
It is also NOT serviced by InterSystems Support !

Standard error logs in IRIS / Caché / Ensemble are written global ^ERRORS.
As this piece dates back some decades back to previous millennium its structure
is far from the typical SQL storage structures.

Last reply 2 days ago
+ 6   1 3
15

replies

171

views

+ 6

rating

isc vs community for ObjectScript package names

ObjectScript, ObjectScript Package Manager (ZPM), Tools, InterSystems IRIS

Hi Devs!

A few months ago I raised a discussion on the naming convention for ZPM modules.

用goagent上youtube,不能airplay - 威锋 - 千万果粉大本营:2021-8-23 · 手机番羽弓虽上youtube,能正常播放,但是airplay的时候,手机正常走进度,可是电视一直是小圈圈在那转。请问各位,是因为我番羽弓虽的原因吗?有没有办法解决呢?设备:iphone 4s 5.1 .....

But if you contribute to community, we suggested to have "community." package for all such libraries.

But the name is too long.

Last reply 2 days ago
+ 1   1 4
19

replies

166

views

+ 1

rating

InterSystems Open Exchange July 2023 Digest

Digest, Open Exchange

Hey Developers!

Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in July 2023.

General stats:
299 published applications
435 downloads in July
653 developers joined

+ 2   0 1
0

replies

39

views

+ 2

rating

InterSystems Developer Community July 2023 Digest

Digest, Developer Community
Hi Community! Here is a digest of the Developer Community postings in July 2023.
Most viewed
List of Command Line Utilities ?
by Robert Cemper
389

タイヤはフジ 送料無料 5.5J サマータイヤ BLEST ブレス …:【送料無料】 175/65R14 14インチ DUNLOP ダンロップ EC202L サマータイヤ ホイール4本セット。タイヤはフジ 送料無料 BLEST ブレスト ユーロマジック タイプS-07 5.5J 5.50-14 DUNLOP EC202L 175/65R14 14インチ サマータイヤ ホイール4本セット
by Robert Cemper
永久免费FQapp 334

Applause to the winners of the InterSystems IRIS AI Programming Contest!
by Anastasia Dyubaylo
258

目前还在用Google chrome浏览器的朋友,可否进来一叙 ...:2021-12-9 · 那看来我之前实在是太幸运了,不FQ还能使用谷歌搜素,甚至使用谷歌学术搜索外文文献。不过这个从能用到不能用的落差,导致心里也挺堵的。。。 一颗青甜瓜 发表于 2021-12-8 16:07 哇塞,这个方法简直不能再棒。下载lantern运行后,感觉我与世界接轨了。
by Stefan Wittmann
248

Un-Typical persistence
by fq必下app
236

View all most viewed posts »

0   0 1
0

replies

22

views

0

rating

<ZSOAP>zInvokeClient+208^%SOAP.WebClient.1

ObjectScript, SOAP, Caché

Hello for everyone.

 

Last reply 3 days ago
0   0 3
1

replies

68

views

0

rating

speedtest 能跑满,但是 youtube 就不行是为啥? - V2EX:2021-5-18 · 宽带症候群 - @shayang888 - 家里 100m 的电信宽带,speedtest 单线程测试能跑满,但是看个 youtube 4k 60fps 或者 4k 30fps 直播 速度只有 5 ~ 8w,完全跑不满这是为啥

Developer Community

维基百科的可用Hosts文件-月光博客:2021-12-21 · 对于很多来中国用户来说,网络百科全书是学习知识的一个重要途径,目前全球公认的质量较高的网络百科全书是维基百科,不过目前因为种种原因,中国大陆无法直接访问中文维基百科,这里就介绍一个简单的方法,通过修改Hosts文件来访问中文维基百科网站。

Better Developer support/services
Feature InterSystems Microsoft 安卓免费fq工具 IBM Redhat
住房公积金是什么-百度经验:2021-1-18 · 住房公积金是什么,住房公积金很多朋友都不是很熟悉,也不是很了解,我具体的和大家进行一下分析和解释,我国的住房公积金是有一定的规定的,一般是指国家机关、国有伋业、城镇集体伋业、外商投资伋业、城镇私营伋业及其他城镇伋业、事业单位及其在职职工缴存的长期住房储金,是伋业给 ... 1 1 1 1 1
Discord or twitch developer channel 1 1 0 0 0
Linkedin, Twitter, Facebook developer channel 1 1 1 1 1
fq必下app 1 1 1 1 1
Certification program 1 1 1 1 1
Developer Open IDE Tools 1 1 1 0 1
Newsletter 1 1 1 1 1
Free e-learning courses 1 0 0 0 0
Online product documentation 1 1 1 1 1
Free product community edition 1 1 1 0 1
Free product instance in the public cloud 1 1 1 1 0
Free Hands-on e-books 0 0 0 1 1
Developer Community Open source solutions portal 1 1 0 0 0
Gamified developer community portal 1 0 0 0 0
Frequent hackthon competitions 1 0 0 1 0
Redeem prizes from developer participation efforts 1 0 0 0 0
Global Developer event 1 1 1 1 1
Public recognition by developer level 1 0 1 0 0
Meetup groups 1 1 1 1 1
Open source initiatives 1 1 1 1 1
Total: 19 14 13 12 12

Last reply 3 days ago
+ 3   1 1
2

replies

69

views

+ 3

永久免费FQapp

好用的fq

SQL, Caché

cache 2017.2 windows 10

Is there any way to change the sql Shell interface to output a <TAB> between the fields instead of outputting one or more spaces between columns

 

I needed to run an sql ( that took a while to run) and then  cut and paste the generated output into excel, trouble was the paste into excel was not very good for columns when there's spaces used between the columns

 

kev

Last reply 3 days ago
0   0 1
3

replies

37

views

0

rating

求一个fq软件

API, FHIR, HL7, Interoperability, Monitoring, REST API, Security, Video, InterSystems IRIS for Health

Hey Developers,

Check out the latest video on FHIR API Management:

⏯ FHIR API Management: Basic Configuration

 

⏯ FHIR API Management: FHIR Dev Portal

⏯ FHIR API Management: Logging and Monitoring

 

⏯ 现在的网友用什么fq

+ 1   0 1
0

replies

45

views

+ 1

rating

"IRIS can not become quiescent" error

Business Process (BPL), Interoperability, Testing, InterSystems IRIS

Did anyone run into this error when stopping a Production from Ens.Director?

Ens.Director::StopProduction => ERROR <Ens>ErrProductionNotQuiescent: IRIS can not become quiescent

It happens sporadically when an automated unit test from a class that extends %UnitTest.TestProduction runs a test on a Business Process. I already increased the parameter (已完美中文)让IPAD支持FLASH,目前最好的方法,浏览 ...:2021-9-21 · 铺垫:IPAD和其他平板比,绝大部分功能都是秒杀,先阶段买平板,第一选择都是IPAD,,不过,IPAD的FLASH是硬伤,虽现在HTML5大行其道,但是并不能完全替伋FLASH的作用,,试过FRASH.....

Last reply 现在的网友用什么fq
0   0 5
2

replies

38

views

0

fq必下app

12VPN:在中国低调又好用的科学上网工具 – BAFA说:2021-6-15 · 我其实是不想把那么好用的科学上网工具写出来的,主要是最近太多朋友一直和我抱怨,工作、学习受到了很大影响,哪里还有好用的FQ工具啊,这才把压箱底的好东西【12VPN】拿出来了。 不管怎样,请大家遵纪守法,严禁非法使用。

InterSystems Partner, 现在怎么fq

Time to Get Started: Implementation Partners in Health Learning Path

+ 2   0 1
0

replies

49

views

+ 2

rating

PCR伈的分类_百度文库:2021-9-14 · 二是在病毒病诊断方面的应用。目前, 用此方法对人类免疫缺陷病毒、 肝炎病毒、结核杆菌、巨细胞病毒、流感病毒A、流感病毒B等病原体的检 测。 FQ PCR 问世后的几年中,积累了大量有关病原体核酸量与感染性疾 病发生、发展和预后之间关系的资料, 这些研究资料不断丰富, 将形成感染 性疾病的临床 ...

Management Portal, InterSystems IRIS, InterSystems IRIS for Health

Setting up Management Portal Help Pages for Full WebServers

On each page of the System Management Portal, there is a “Help” button.  This takes users to an article in documentation that describes the page functionality and use. 

Caché provides local documentation for all of these articles. 

InterSystems IRIS does not provide local documentation.  Instead, the Help button will redirect users to the articles in the online documentation at docs.intersystems.com.

+ 4   0 1
0

replies

34

views

+ 4

好用的fq

HealthShare - importing xml after exporting as xml from Studio on a different server is double importing my .csp file(s)

Studio, Caché, HealthShare

Im exporting our xml project from a QA server that has NOT upgraded to a production server that has been upgraded to HealthShare.

We are importing the exported xml over to this production server that is on HealthShare.

正丁烯的开发与利用 - 豆丁网:2021-11-10 · 正丁烯及混合丁 烯作为燃料,目前,在美国及西欧占有很大的比例。美 国烷基化油的总生产量约占原油处理量的6.2%,催 化裂化c。绝大部分用于制造烷基化油。 目前,我国对正丁烯的化工利用,主要是脱氢制 丁二烯。

We are able to view our .csp pages after importing them as xml into Studio on the production server running on HealthShare

Last reply 4 days ago
0   0 3
2

现在怎么fq

53

views

0

rating

Cache Objectscript Developer opportunities!

安卓免费fq工具, Developer Community, Ensemble, Job Opportunity

TEKsystems has multiple opportunities for Intersystems Cache ObjectScript Developers  

Please send me an email at ashonk@teksystems.com if you are interested in hearing more!

正丁烯的开发与利用 - 豆丁网:2021-11-10 · 正丁烯及混合丁 烯作为燃料,目前,在美国及西欧占有很大的比例。美 国烷基化油的总生产量约占原油处理量的6.2%,催 化裂化c。绝大部分用于制造烷基化油。 目前,我国对正丁烯的化工利用,主要是脱氢制 丁二烯。
0   0 1
0

replies

150

views

0

rating

New Issues of Developments on Their Way

Performance, Release, Global Summit, 现在的网友用什么fq

 Hi Community:

Watch your inboxes for our latest issues of Developments and Developments Healthcare Edition.

 

 

 

 

 

 

 

 

 

 

 

0   0 1
0

replies

72

views

0

现在的网友用什么fq

  • 1
  • 2
  • 3
  • 4
  • 5
  • fq必下app