Queries on Universal Server - Part II

28/FEB Hi Few more question on Universal Server Expecting your reply With Regards GANESH Image / Sound : How to Insert the Image / Sound in to the table. Should I create the = Image / Sound as a file=20 such as .BMP / GIF (for Image) & .AVI for (Sound) and Insert into the = table.=20 Universal Server Database Gateway : 1) Is the Universal Server Database Gateway based on the Informix = Enterprise Manager /=20 Informix CLI / Informix Enterprise Gateway for EDA-SQL. ? 2) What is the difference between Universal Server database gateway & = Informix Universal web connect ?=20 3) >> Universal server can connect to other data sources such as Oracle = or Sybase. Informix >> Universal server has a gateway kit called virtual table = interface that lets you build tables and=20 >> map them to oracle tables. So the application developer looks at = an environment where all the >> data seems to be in the universal server but infact the gateway = server will go & grab the oracle >> data ; bring it back ; integrate it into the results of the = query. So Informix Universal server is a >> very simple environment to build in and to keep all the original = data. Informix Universal server >> gateway kit is also implemented as a datablade module. Question :=20 MS-SQL Server distributed transaction coordinator uses ODBC to = connect to multiple databases & also provides distributed transaction processing functionality.=20 a) To connect to data sources such as Oracle / Sybase whether the = Informix Universal server gateway uses ODBC or the native drivers ? =20 b) Can Informix Universal server database gateway handle = distributed transaction processing ? Informix Universal server development tool kit : >> Informix Universal server development tool kit available now provides = a debugger and a class=20 >> library for data access tools and C language function support. Question : What is Informix Universal Server Development toolkit ? Informix Jworks : Could Informix Jworks convert a 4GL Code / ESQL code to a Jworks screen = ? Any Language : >> The main choice for developers is whether to write functions in SPL = or C or C++ or JAVA. Unlike >>SPL functions, functions written in these = third generation languages are compiled and loaded into >>shared object = file or dynamic link library. The functions and name of the shared = object are declared >>to the server. When the function is invoked the = shared object is linked into the server and runs >>there. Questions : Writting the function in Java / C / C++ is not much of a = problem. Having written the functiuon how to declare these functions to the = server ? Datablade Module : >> Datablade module include client code which access the database via = the datablade API >> library and exports a user interface; so that users can query / = display / modify the=20 >> new data types. Question : From which language or which tools can this API be called ? Query optimizer : >> A special fast path interface enables an application to call a = function directly by function ID. >> avoiding the SQL parser and optimizer. This provides a very fast = method of invoking the=20 >> function on the server. Question : What happens in case the function has makes a SQL request ?=20 >> Application accessing Informix Universal server database using ESQL / = C, Informix CLI, >> C++ API, Java API, JDBC goes through extensible SQL parser, = extensible optimizer, >> parallel function manager, parallel access methods & parallel DSA = data manager. However >> Informix & 3rd party data blade modules such as time series , text , = image, OLAP, web, >> geospatial, audio, video etc access database directly.=20 Question : Does it mean that I don't get the advantage of DSA parallel = query optimizer etc ?