SQL Connect

Question

Question

Arockia Raj B · Jun 8, 2017

How to simply going to get the value of the system language from ^%z? Because I got a problem, U2 context isn't setup while connecting the SQL Connect.

Discussion (4)0

Log in or sign up to continue

Kyle Baxter · Jun 10, 2017

Arockia,

This sounds like something you might want to discuss with the WRC (which is what I do!). You will need to send over a sample table and some test data showing the problem and we'll be able to sort you out in no time.

Cheers!
Kyle

0 0

Kyle Baxter · Jun 8, 2017

I'm unsure, exactly, what you're trying to do here. You could write a Stored Procedure that returns the value of a global pretty easily. If you need to run code before connecting via ODBC you can use "init code" set up via the $SYSTEM.SQL.SetServerInitCode() API. I'm not sure exactly what you're looking for, though.

0 0

score 0 · Answer 1 · 2017-06-08T11:41:41-04:00

If there is no system function exposing this info you could create a a class using Cache SQL Storage to "Map" this global and expose the info to SQL.

I wrote some stuff explaining the basics here: The Art of Mapping Globals to Classes 1 of 3

brendan

score 0 · Answer 2 · 2017-06-10T02:08:17-04:00

The problem is Data from field "when" column is in english instead of system language. I pretty sure the solution, but I dont know how to implement this.