Re: Port Oracel to Sybase

Well, one idea is to remove as much of the SQL as possible from the main body of your code. I tend to try and remove it completely by making sure all my Pro*C code actually calls stored procedures as much as possible, so the SQL is in the database. This is an idea you might want to follow.

Short of that, try and drag your code that contains SQL into a separate series of modules, so you can at least scope the changes down to a smaller more maintainable area.

Steve Phelan.

M. Thomas Groszko wrote in message <6esikn$n5o$1_at_news5.ispnews.com>...
>I need to port an Oracle ProC application to use Sybase Embedded C. My hope
>is that I will be able to #ifdef to select the correct SQL and thus use the
>same code base for both.
>
>Is there a list of SQL dialect differences Oracle/Sybase somewhere?
>
>Do any of you have suggestions of "to do" or "not to do" based on a similar
>effort.
>
>
Received on Fri Mar 20 1998 - 00:00:00 CST