Automation of test for driver specific test in OE dataserver

In OE dataserver, we connect to MS sql server by using DSN of particular odbc driver. Some features are also supported with specific driver. If you want to run specific test only for a particular odbc driver then you can conditionalize the script as per your requirement.

If you want to conditionalize your test script for particular drive then you can query for driver details from schema holder  using below ABL-

for each _db:

display _Db-misc2[1].

         for e.g. p2sqls27.dll

It will return the driver dll name by using which you can know whether it is a SNAC, SQL or native driver.

Same way if you want to know the driver version you can use below ABL-

for each _db:

display _Db-misc2[2].

        for e.g.  0.7.15.0254 (B0248, U0172)

To get the odb_ctl.i number value for specfic driver use below ABL-

for each _db:

display _Db-misc2[4].

       for e.g. 11,13,14,20,23,33,36,39,

Localization testing by changing your system locale

Localization: It is the process of adapting internationalized software for a specific region or language by adding locale-specific components and translating text.

Things to take care during installation while testing openedge with non-english environment

OpenEdge by default allows user to install OpenEdge in 14 different languages. Here is the list below-

Czech(VZE)	Polish(POL)
Dutch(Dut)	Portuguese(POR)
English-American(AME)	Portuguese-Brazilian(BRZ)
English-International(Eng)	Spanish(SPA)
French(FRE)	Spanish-Latin American(SPL)
German(GER)	Swedish(SWE)
Italian(ITA)	Chinese-Simplified(SCH)

Apart from these 14 languages it also supports other supplement languages as well. Here is the list of 22 supplement languages below-

Arabic	Croatian
Chinese (traditional)	Danish
Hebrew	Finnish
Japanese	Greek
Korean	Hungarian
Persian	Icelandic
Serbian	Lithuanian
Thai	Norwegian
Turkish	Slovak
Slovenian	Spanish - Mexican
Romanian	Russian

How to test your internationalization configuration using ABL?

OpenEdge database support internationalization . It means you can build application for non-english language/region and perform required operations. While working with non-english languages, you need to  use appropriate language setting to perform the operation and do the character processing correctly.

You can use ABL query to test the setting from your client. Here is the ABL query below- 

MESSAGE   

"Database    = " DBCODEPAGE(1)      SKIP   

"Collation   = " DBCOLLATION(1)     SKIP   

"-cpinternal = " SESSION:CPINTERNAL SKIP   

"-cpstream   = " SESSION:CPSTREAM   SKIP   

"-cpcoll     = " SESSION:CPCOLL     SKIP   

VIEW-AS ALERT-BOX.