Hi All I'm thinking of a Client/Server mechanism that will provide the following:1. the program will be invoked by the HTTP server or a custom TCP/IP server. Haven't decided yet. It is very tempting to use HTTP and take advantage of it's encryption and language support capabilities. On the other hand, the less prerequisites the better.
2. the SQL statement will be passed as a parameter and the program will provide the output result set in stdout
3. the program will need to provide paging - the result set can be very big, so it has to be sent to the client by small buffers.
Is it something that can be implemented by Embedded SQL? I'm not vary familiar with it so I just wanted to ask before I start digging. Limitations - I cannot use ODBC I also don't like the idea to use the Query Manager.