{"id":8776,"date":"2016-06-04T09:15:40","date_gmt":"2016-06-04T09:15:40","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=8776"},"modified":"2016-06-04T09:15:40","modified_gmt":"2016-06-04T09:15:40","slug":"find-the-database-type-to-execute-the-sql-query-from-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2016\/06\/04\/find-the-database-type-to-execute-the-sql-query-from-sage-x3\/","title":{"rendered":"Find the Database Type to execute the SQL Query from Sage X3"},"content":{"rendered":"

To implement the business logic we need to use SQL Query to fetch the required data from the Database. To execute the SQL Query from Sage X3<\/a><\/span><\/strong>\u00a0we need to know the database type. We can fetch the database type as below:<\/p>\n

\"Sage<\/a><\/p>\n

The \u201cTYPDBA\u201d column in \u201cADOSSIER\u201d table holds the value which will help to identify the Database type.<\/p>\n

The above logic will return which database type is used to store the data.<\/p>\n

\u201c3\u201d:<\/strong> This will return when the database type is \u201cOracle\u201d<\/strong><\/p>\n

\u201c5\u201d:<\/strong> This will return when the database type is \u201cSQL\u201d<\/strong><\/p>\n

And according to database type, the SQL query is executed and data is fetched from database.<\/p>\n

Hope this blog helps!<\/strong><\/p>\n

<\/h4>\n
About Us<\/strong><\/h6>\n

Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n

Greytrix<\/a>\u00a0have some unique solutions of\u00a0Sage X3\u2019s integration with Sage CRM<\/a>,\u00a0Salesforce.com<\/a>\u00a0and\u00a0Magento eCommerce<\/a>. It also offers best-in-class\u00a0Sage X3 customization and development services<\/a>\u00a0to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>\u00a0.We will be glad to assist you.<\/p>\n

Other Related Blogs:<\/em><\/strong><\/p>\n

—\u00a0Determines the quantity of available memory at a given time<\/a><\/p>\n

—\u00a0How to determine if a mask variable can be entered or is displayed..?<\/a><\/p>\n

—\u00a0Use of \u201cnomap\u201d variable in Sage X3<\/a><\/p>\n

—\u00a0How to know a Mask Variable is Initialized or not?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

To implement the business logic we need to use SQL Query to fetch the required data from the Database. To execute the SQL Query from Sage X3\u00a0we need to know the database type. We can fetch the database type as below: The \u201cTYPDBA\u201d column in \u201cADOSSIER\u201d table holds the value which will help to identify\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[501,502,1941,1943,1947],"class_list":["post-8776","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-database-type","tag-database-type-to-execute-the-sql-query","tag-sage-x3-technical","tag-sage-x3-technical-blog","tag-sage-x3-technical-issues"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=8776"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/8776\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=8776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=8776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=8776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}