Hello everyone!

FINALLY!! The technical article contest in Spanish begins on Monday  🎉🎉

On that same day, we will publish the rules and prizes of the contest. We can tell you in advance that you will love them. Of course, we will announce that there will be a gift for everyone who participates, as well as different bonuses, topics, and tips that will help you with your articles.

The contest dates: May 12th to June 8th.

Are you ready? Maybe this weekend you’ll get your first burst of inspiration! 🤩

See you soon!! ✍

Hello Community,

I executed the below query in the %ZLANGC00.mac routine. It returns results when using dynamic SQL, but not with embedded SQL(returns 0). 

 &SQL(SELECT count(*) INTO :Cnt FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'")
 Write "SQL Table count : "_Cnt,!
 Set tResultSet = ##class(%SQL.Statement).%ExecDirect(,"SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'")
 Do tResultSet.%Display()

Thanks!