#Contest

3 Followers · 425 Posts

Contest tag unites posts that are related to any coding competition taking place on InterSystems Developer Community.

Question Andreas Schneider · Dec 30, 2021

Hi all,
I try to build a little project for the dataset contest, you can find it here on github: Openflights dataset
My plan is to use just plain SQL. So I've made a few experiments with the new feature LOAD DATA.

Unfortunately all loads produce errors like:  
 Error: [SQLCODE: <-400>:<Fatal error occurred>]
[Error: <<UNDEFINED>zExecute+83^%sqlcq.OPENFLIGHTS.cls4.1 *%qparsets>]
[Location: <ServerLoop>]

The statements I use looks like this:

 

This happend with the preview release "IRIS Version 2021.2.0.617". While this error occurs, most rows are written to the database, but some rows are missing.

10
0 996
Question Oliver Wilms · Mar 26, 2020

Hello,

While working on my Iris contest application FileMailer, I got an error today trying to send email with code that used to work. I added debugging entries and I can see it happens in %Net.SMTP class "Send" method. I am not using any credentials or SSL. I see it opens |TCP|25 device. It issues a series of commands to SMTP server (I was testing with smtp.va.gov and port 25). "init" command gets 220 response.  It runs "Login" method. Response is 250. The next command is "MAIL FROM" and I see 250 in the response with sender ok. The next command is "RCPT TO".

1
0 1269
Question Eduard Lebedyuk · Jun 6, 2017

Hi, Community!

Last weekend we held the Final of InterSystems Contest on InterSystems Caché and DeepSee as a part of IT Planet Student Championship in Sochi. BTW, this year we had about 2 000 participants in InterSystems Contest.

One of the tasks for the finals was to solve the following  with Caché ObjectScript and use the minimum code. 

Problem description

Write a method that would return the string 9876543210, however cls code should not contain numbers 0-9.

The goal is to write the shortest method.

23
0 1249