Download
1 / 4
40 likes | 58 Views
As you probably are aware, Sage Enterprise Management gives its very own select, refresh proclamations like SQL. For effectiveness, we can utilize SQL inquiries in Sage X3. Sage X3 gives exceptional capacity to execute SQL articulations/directions. The uncommon capacity is Execsql. It is utilized to dispatch a SQL to ask for that does not require the arrival of data, not at all like the guidance For… From… Sql that recovers the columns. This guidance is utilized, for instance, to dispatch a Sql to give order that is utilized to accord the rights to a table.
E N D
How to dispatch SQL Request in Sage Enterprise Management? As you probably are aware, Sage Enterprise Management gives its very own select, refresh proclamations like SQL. For effectiveness, we can utilize SQL inquiries in Sage X3. Sage X3 gives exceptional capacity to execute SQL articulations/directions. The uncommon capacity is Execsql. It is utilized to dispatch a SQL to ask for that does not require the arrival of data, not at all like the guidance For… From… Sql that recovers the columns. This guidance is utilized, for instance, to dispatch a Sql to give order that is utilized to accord the rights to a table. Sentence structure: Execsql From type_base Sql sql_exp
Where, type_base: Alphanumeric character portraying the database type. sql_exp: Character string or character string framework containing the SQL requesting. Example: YSQUERY(0)=" Update "+nomap+".YTEMP set YFLAG_0 = 2 where YITMREF_0 ='ABC' " YSQUERY(1)=" AND YSTOFCY_0='XYZ'" Execsql From type_base Sql YSQUERY(0) # in the creation and refresh process for the table structures. Nearby Char BASE(1)
Case [F:ADS]TYPDBA When 1 : BASE = "3" When 2 : BASE = "5" When 3 : BASE = "2" When 4 : BASE = "4" Endcase Here, we are refreshing table YTEMP with YFLAG field to 2. The parameter type_base is utilized to show the Sage Database type to be getting to: –"o","O","3″ to depict an Oracle database –"s","S","5″ to depict a SQL 7 database. The sql_exp parameter is utilized to show the sql ask. It is communicated by a character string or else a framework. When utilizing a framework, the demand articulation is comprised of the connection of character strings. This matrix is restricted to 255 components. Expectation this makes a difference! If you are facing any problem, then the best option for Resolution of this Problem is to Contact our Sage Certified Toll-Free Number +1(800) 986 6931. You may visit Onlinechat.support or Chat with our professional Sage Team. They will always provide you a better guidance for all types of Issues related to Sage Accounting Software.
