Hi Daniel!
Another option is to have several SQL commands in a file, e.g. script.sql and run it one by one with:
do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql")
- Log in to post comments
Hi Daniel!
Another option is to have several SQL commands in a file, e.g. script.sql and run it one by one with:
do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql")
Suppose you have your sql script in script.sql
You can call the following command:
do $System.SQL.DDLImport("IRIS",$Username,"/path/script.sql")
It will execute all the lines one-by-one.
Hi Sabit!
Looks interesting!
But I see only jar files in the repo. Could you please submit java source files too?
Fantastic application, Yuri!
For those who is on Mac you also need to change mvnw to executable:
chmod +x mvnw
Hi guys!
I just want to share with you a few details, that we have this whole week for voting and to let you fix bugs and improve the app, to describe (in articles) and show(in videos) how your application works and why is it cool! And so you do!
And if you see sometimes that the number of your votes decreased that means that somebody from votes changed his mind in favor of another participant. Probably because your colleague just has posted an exciting article or submitted the video!
To all participants!
Thank you very much for your outstanding contributions! The only thing I regret that I can vote only once!
Hi Renato!
This is really cool!
Could you add the list of available globals in the UI? Just to have the option to get a graph of any other then ^computer global!
On the JSON import: is it possible to import from text.file?
And export global to a text file with JSON?
Nice work, Oleh!
I tested on my laptop - it indeed imports 1,500 collections from Mongo to IRIS in a few seconds! Neat!
I'm curious if the app which works on Mongo can refer to this data in IRIS?
Cool!
Do you mean the import of any JSON file to a Global?
How can I try it?
Welcome to the team, @Henrique Dias !
Yes. We first introduced this one cause it exactly how Atelier API exports ObjectScript artifacts by default, but IMHO the simplified one is much better.
And that's why we have it in the ZPM basic template.
Also, is it there any place with full doc about module.xml? Articles are full of really useful info but having to navigate through all of them is a bit confusing.
Sure. Here is the ZPM documentation
Hi Salva!
Thanks, but not anymore. Check the article.
Another topic for this Native API contest could be "Import-export" util of global to JSON.
E.g. import JSON file and have a global inside IRIS, and having an arbitrary global inside IRIS export it to the JSON file.
The related topic Docker Desktop + WSL 2 Integration Deep Dive will be today in 30 min on Dockercon 2020
Felicidades @David Reche , @Kurro Lopez, @Nancy Martínez, @Esther Sanchez!
Spanish Community is growing and I think I need to study Spanish already now )
Mentioning @Lexi Hayden
Thanks to everyone who joined the webinar today!
We bring our apologies for several letters sent with the event link - we had some issues with the mail system today, we are working to fix this and hope this will not happen again!
I hope you liked the webinar and looking forward to seeing you at the next one!
Hi Renato!
Thanks for participating in the contest!
You can submit a new question here on Developers Community, or ask in Discord, or report on the problem to support@intersystems.com
Actually the ObjectScript Package Manager became the answer to this question.
Thanks, @Benjamin De Boe ! It doesn't explain though (at least for me) why hosted variables can't be used for table and column names.
Participate in the contest as a team!
Possible? - Yes!
We don't have "forming teams" UI at the moment, but you are welcome to form a team by yourself, .e.g. using use Direct Messages on the Developer Community or chatting in Discord channel, make the project and submit it under anyone name from a team!
Julius, what does 'radix' stand for?
Wow.
Thank you @Vitaliy Serdtsev , @Robert Cemper, @Steven Hobbs - that helps a lot!
Julius! Thank you very much for such a story, very touching. And for the prompt opinion.
And thank you for sharing your fantastically rich experience with Dev community where we all benefit a lot from your knowledge and direct feedback!
And I remember the meat-chopper too :)
I'm on Mac.
And I'm on Git and commit to GitHub.
And I like Docker.
VSCode works on Mac, has Git out-of-the-box and I can install Docker and ObjectScript plugin.
With VSCode and Docker have 0 (zero) time to set up the environment to develop for InterSystems IRIS with ObjectScript or any other language.
My vote is for VSCode.
Glad that this has been solved!
Nice! Thank you, Vitaly!