Conguratulations!! 🎊 Let's keep adding to the FAQ articles together!🤩

Our FAQ system uses iFind indices😆 https://faq.intersystems.co.jp

We used to use Mecab for morphological analysis of Japanese text.

Mecab is good, but it can be difficult to identify semantic entities in Japanese sentences like this:

"タスクマネージャー"(Task Manager) is divided "タスク"(Task) and "マネージャー"(Manager).

"アンインストール" (Uninstall) is divided "アン"(Un) and "インストール"(install).

iFind is excellent✨

One more from Japan！😆

Embedded Python,  
a strong choice within IRIS.  
ObjectScript too

Thank you very much @Dmitry Maslennikov !!! And 🎊✨congratulations ✨🎊

Hi @RKumar 

You can check using Coreinfo.exe.

https://learn.microsoft.com/en-us/sysinternals/downloads/coreinfo

The bottom of this topic has running example:👉https://jp.community.intersystems.com/node/568046

Thank you for publishing this wonderful article! This is probably the most pleasant thing that has happened to me in my intersystems 21 years🤩

Do you know [InterSystems FAQ rubric] article?

The article is occasionally published in the US community, and it is based on the FAQ Japanese article.
The FAQ Committee started in 2007 in the Japan office, and the four members ( @Hiroshi Sato @Megumi Kakechi  @Tomoko Furuzono ) discuss which content is frequently and useful each time and create the articles.
Please stay tuned for more FAQ articles in the future!
Let's keep doing together to make more beneficial and enjoyable community!!

FYI:

You also use List query in %SYS.Journal.Record.

set rs=##class(%ResultSet).%New("%SYS.Journal.Record:List")
set jrn=##class(%SYS.Journal.System).GetLastFileName()  // or input file pull pathdo rs.Execute(jrn)
write rs.Next()
write rs.Get("Address"),"-",rs.Get("TimeStamp"),"-",rs.Get("ProcessID"),"-",rs.Get("TypeName"),"-",rs.Get("InTransaction"),"-",rs.Get("GlobalNode"),"-",rs.Get("DatabaseName"),!
do rs.Close()

Note: it doesn't work with %SQL.Statement

Although in Japanese, this article is related to it : https://jp.community.intersystems.com/node/492721

I'm intrepid Newsmaker (above image is Japanese community's recap image)

Thanks @Anastasia Dyubaylo ! The recap is good tool to motivate 2023 🔥

ImportDDL() method in %SYSTEM.SQL.Schema class can run multiple queries.

Documentation is https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=GSQL_import#GSQL_import_cache

Step1: preparing import file like below:

You need to use "go" in end of each query.  (c:\temp\updatequeries.txt)

UPDATE Test2.Person Set Name='abc' where ID=1
go
UPDATE Test2.Person Set Name='efg' where ID=2
go
UPDATE Test2.Person Set Name='hij' where ID=3
go

Step2: running  ImportDDL() method like below:

USER>do $system.SQL.Schema.ImportDDL("c:\temp\updatequeries.txt","c:\temp\import.log","IRIS")
 
 
Importing SQL Statements from file: c:\temp\updatequeries.txt
 
 
Recording any errors to principal device and log file: c:\temp\import.log
 
 
  SQL statement to process (number 1):
     UPDATE Test2.Person Set Name='abc' where ID=1
      Preparing SQL statement...
      Executing SQL statement...
  DONE
 
  SQL statement to process (number 2):
     UPDATE Test2.Person Set Name='efg' where ID=2
      Preparing SQL statement...
      Executing SQL statement...
  DONE
 
  SQL statement to process (number 3):
     UPDATE Test2.Person Set Name='hij' where ID=3
      Preparing SQL statement...
      Executing SQL statement...
  DONE
 
Elapsed time: .01458 seconds
USER>

@Megumi Kakechi 
I can get correct result on 2022.1! 

I use iris 2022.1 container. (image lists :https://community.intersystems.com/node/511986)

USER>write $ZV
IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2022.1 (Build 164U) Tue Apr 5 2022 01:30:47 EDT

USER>do $system.Python.Shell()

Python 3.8.10 (default, Nov 26 2021, 20:14:08)
[GCC 9.3.0] on linux
Type quit() or Ctrl-D to exit this shell.
>>> sql="select name,value from %Library.Global_get('user','^ISJ',,2,2)"
>>> rset=iris.sql.exec(sql)
>>> dataframe=rset.dataframe()
>>> dataframe
      name                value
0  ^ISJ(1)  $lb("名前","年齢","住所")
1  ^ISJ(2)  $lb("佐藤","50","東京")
2  ^ISJ(3)  $lb("加藤","40","大阪")
3  ^ISJ(4)  $lb("伊藤","30","京都")

I mistook attached file in previous comment.

Please refer downloadandzip-mojo-dojo_3.zip this attached file for mojo+dojo.

My samples is using 2 JavaScript libraries.
 1)  JSZip(http://stuk.github.io/jszip)
 2)  FileSaver.js(https://github.com/eligrey/FileSaver.js/).
These library can downloads some files from one path at once and save as one Zip file.
Simple samples is below:::
 

<!DOCTYPE html><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><script src="http://code.jquery.com/jquery-1.9.1.min.js"></script><script type="text/javascript" src="http://stuk.github.io/jszip/dist/jszip.min.js" charset="utf-8"></script><script src="FileSaver.min.js" charset="utf-8"></script></head><body><form name=f1 method=post><h2>Download＋Zip Simple sample</h2>Please set urlList variable correct file path in startDL() before testing.<br><input type="button" name="b1" value="Download" onclick=startDL()></form><script type='text/javascript'>function startDL(){//　urlListにはダウンロード用ファイルを直接指定しています。// 【注意】日本語を含むファイル名はダウンロードできません。var urlList = ["./ImageTest/IMG_3587.JPG","./ImageTest/IMG_3598.JPG"]console.log(urlList);zip = new JSZip();deferreds = $.Deferred();var promise = deferreds;$.map(urlList,function(value,index) {console.log('urlList:index='+index+' = '+value);console.log('match() : '+value.match(".+/(.+?)([\?#;].*)?$")[1]);promise = promise.then( function() {var newPromise = new $.Deferred();var xhr= new XMLHttpRequest();xhr.open('GET',value,true);xhr.responseType='arraybuffer';xhr.addEventListener('load', function() {// zipにレスポンスデータ追加zip.file(value.match(".+/(.+?)([\?#;].*)?$")[1],xhr.response);newPromise.resolve();});xhr.send();return newPromise;});});promise.then( function() {zip.generateAsync({type:"blob"}).then( function(content){saveAs(content,'test.zip');});});deferreds.resolve();}</script></body></html>

I attached sample for mojo+dojo.downloadandzip-mojo-dojo_1.zip

My samples is using 2 JavaScript libraries.
 1)  JSZip(http://stuk.github.io/jszip)
 2) FileSaver.js(https://github.com/eligrey/FileSaver.js/).
These library can downloads some files from one path at once and save as one Zip file.
Simple samples is below:
 

<!DOCTYPE html>downloadandzip-mojo-dojo_0.zip
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
 <script type="text/javascript" src="http://stuk.github.io/jszip/dist/jszip.min.js" charset="utf-8"></script>
 <script src="FileSaver.min.js" charset="utf-8"></script>
</head>
<body>
<form name=f1 method=post>
<h2>Download＋Zip Simple sample</h2>
Please set urlList variable correct file path in startDL() before testing.
<br>
<input type="button" name="b1" value="Download" onclick=startDL()>
</form>
<script type='text/javascript'>
function startDL(){
//　urlListにはダウンロード用ファイルを直接指定しています。
// 【注意】日本語を含むファイル名はダウンロードできません。
var urlList = ["./ImageTest/IMG_3587.JPG","./ImageTest/IMG_3598.JPG"]
console.log(urlList);
zip = new JSZip();
deferreds = $.Deferred();
var promise = deferreds;
$.map(urlList,function(value,index) {
    console.log('urlList:index='+index+' = '+value);
    console.log('match() : '+value.match(".+/(.+?)([\?#;].*)?$")[1]);
promise = promise.then( function() {
var newPromise = new $.Deferred();
var xhr= new XMLHttpRequest();
  xhr.open('GET',value,true);
xhr.responseType='arraybuffer';
xhr.addEventListener('load', function() {
// zipにレスポンスデータ追加
zip.file(value.match(".+/(.+?)([\?#;].*)?$")[1],xhr.response);
newPromise.resolve();
});
xhr.send();
        return newPromise;
});
});
promise.then( function() {
zip.generateAsync({type:"blob"}).then( function(content){
saveAs(content,'test.zip');
});
});
deferreds.resolve();
}
</script>
</body>
</html>

I attached sample for mojo+dojo.