In an effort to consolidate all perl parsing/transformation code for all database extractions we went with perl DBI on Linux. Initially, we figured, no problem.
Here are some things we found out:
- Default perl install on Fudora Core distribution of Linux had issues with SybPerl Resolution: Grab latest stable build from perl.org and re-compile without -ldb option
- Install the following Packages: DBI::Bundle, DBD:Sybase, freetds
- SYBASE environment variable must be set to install location (in our case /usr/local)
- Perl Bind variables via ? not supported. Still investigating if there is a good work around for this issue.
All in all, once perl was re-compiled we didn't really have any issues... knock on wood...