#ObjectScript

InterSystems ObjectScript is a scripting language to operate with data using any data model of InterSystems Data Platform (Objects, Relational, Key-Value, Document, Globals) and to develop business logic for serverside applications on InterSystems Data Platform.

Documentation.

By views

AllTop

Question

Dmitrij Vladimirov · May 8

How to delete table column with its data with SQL command. I need the exact syntax of the command

I have a table in the development and want to erase data from certain columns. There is info in the docs but not for human

This piece of code does not work

ALTER TABLE table DROP COLUMN column %DELDATA

#ObjectScript #SQL #InterSystems IRIS

0 3

0 45

Question

Ashok Kumar T · May 8

Embedded SQL result issues inside %ZLANGC routine

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).

#ObjectScript #SQL #InterSystems IRIS #InterSystems IRIS for Health

0 4

0 35