hello.
i am a java programmer who has alot of code that i wrote non-ansi based sql in. i was in the midst of attempting to write a converter that i could put in between my code and my database that would convert non-ansi SQL to ansi sql. i have been using freeware databases, because i dont make money off of my sites.... i basically code for friends and try to do some community service help with it.
is there a way to look at the code (since it appears alot of sybase functions are written in C and/or Java) that performs the REWRITE/ANSI conversion? that function covers nearly everything i could ever need (mainly converting outer joins... but my outer joins have (+) instead of * by the = sign, so i would have to modify a function)...
does anyone have any similiar functions/methods i could mimic or that i would find useful?
thanks in advance for your replies.
travis
i am a java programmer who has alot of code that i wrote non-ansi based sql in. i was in the midst of attempting to write a converter that i could put in between my code and my database that would convert non-ansi SQL to ansi sql. i have been using freeware databases, because i dont make money off of my sites.... i basically code for friends and try to do some community service help with it.
is there a way to look at the code (since it appears alot of sybase functions are written in C and/or Java) that performs the REWRITE/ANSI conversion? that function covers nearly everything i could ever need (mainly converting outer joins... but my outer joins have (+) instead of * by the = sign, so i would have to modify a function)...
does anyone have any similiar functions/methods i could mimic or that i would find useful?
thanks in advance for your replies.
travis