Re: Sybase DB Library vs Client Library API

[Ravi V]

have converted some of my perl scripts to use CTlib blk instead of DBlib bcp ... but i am facing problem with memory usage(increased)... Is there any document on CTlib memory usage? ..thanks for help in advance

[mpeppler]

There should be no significant memory usage differences.

Do you have some actual code, with volumes and memory usage statistics?

Michael

[Ravi V]

thanks for reply Michael
Its seems to be implementation issue..

yet i have came across other problem now ...
for "select getdate()"
DBlib returns:-
11/28/2012 3:28:38.446 AM
CTlib returns:- CTlib does special handling for DATETIME
11/28/2012 3:28 AM
it would be great if there is some solution on perl side as this have been used on many procedures and changing all the procedure will be problem.

Thanks

[mpeppler]

You should be able to use the cs_dt_info() call to define the date formatting. See the manual at http://search.cpan.org/~mewp/sybperl-2.19/CTlib/CTlib.pm

Michael

[Ravi V]

thanks Michael for this:- http://www.peppler.org/archive/sybperl-l/1999/9/4985.html