I had already checked the DBI Documentation as well as the DBD::ODBC docs. I think I realize the problem. The function I was using is defined in ODBC documentation. Which I just found online
here I'll try to do this via the functions you mentioned. Thanks.