EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37020: VLDB property 'CREATE and INSERT Support' in MicroStrategy SQL Generation Engine 10.x


Community Admin

• Strategy


VLDB property 'CREATE and INSERT Support' in MicroStrategy SQL Generation Engine 10.x

Strategy SQL Generation engine 10.x includes a VLDB property, 'CREATE and INSERT Support,' under the Tables folder, at the database instance level. 
 
There are two options for this property:

  1. CREATE and INSERT statements are supported
  2. CREATE and INSERT statements are not supported.
ka04W000000OhMEQA0_0EM440000002DgI.png

 
The First option, 'CREATE and INSERT are supported,' will enable temporary table creation and insert support.
 
The second option, 'CREATE and INSERT are not supported,' will disable temporary table creation and insert support.
 
This can only be set for secondary database instances, because primary database instances require the use of temporary tables.
 


Comment

0 comments

Details

Knowledge Article

Published:

May 24, 2017

Last Updated:

May 24, 2017