Id location is in place - and has Ids in the first index, like ^myclassD(1),^myclassD(2), etc.

But nothing is set in ^myclassD

Other parameters I have:

Property id As %Library.BigInt [ SqlColumnNumber = 14 ];

Parameter ALLOWIDENTITYINSERT = 1;

Index MYCLASSPKEY1 On id [ IdKey, PrimaryKey, SqlName = MYCLASSPKEY1, Unique ];

And I import IDs from the csv file.

so my 

set newid=$I(newid)

part uses $Increment

Yes, $I is the short of $Increment.

But from which global?

$Seq is a faster option of $Increment

Works like a charm, impressed.

Thank you, @Tani Frankel! Will take a look 

Wow. Thank you, AI

Thanks @Robert Cemper !

I this case Query was a slightly better alternative to me vs Embedded SQL (more readable SQL). So… 

But knowing once again that everything is possible is always good, especially a few days before New Year! :)

Thanks for the clarification, @Ashok Kumar T !

What can I say - it's not obvious (that it is only for SELECT), and it's a pity as the "Query" functionality that works great for SELECT can also be leveraged with INSERT, DELETE and UPDATE.

Sounds like a good candidate for the Ideas portal :)

Thanks for the PR with even more examples!

The new version has been released! 

thank you @Ashok Kumar T @David Hockenbroch both!

Included your code into the new embedded python template release - here.

Thank you, @Ashok Kumar T ! Works like a charm!

This is in my case:

Very cool, @David Hockenbroch ! This is what I'm getting in my case:

Found one option!

ClassMethod DivideByZeroPython() [ Language = python ]

{

import sample

import iris

try:

print("divide by zero=" + str(sample.dividezero(1)))

except ZeroDivisionError as e:

errobj=iris.cls("%Exception.General")._New(str(e),42)

a=errobj.Log()

print("Caught exception: " + str(e))

}

This stores the error in Apps Log, but no stack (of course):

Any ideas how I can store at least the class and line of code in parameters? I can provide the name and location to %Exception.General class that will be stored in the App Log.

Thank you, Mike! will give it a try!

Thanks, @John Murray ! Do you have any examples connecting both locally and remote?

I'd appreciate any example of a ready-made .code-workspace file, thank you in advance!

Interesting! Do you want to share an example of .code-workspace files and how to switch between servers?