how to get datatype of columns of a table in perl script



Hi all

I am new to perl just (1 1/2 month experience.). I am developing perl script
which connects to oracle database and selects rows from a (x) table and then
inserts them into its corresponding table in db2. So, while inserting i need
to find what is the datatype of columns , since we need to use quotes for
varchar,date etc.....



Could anybody help me out to find an approach .



Thanks in advance





Regards

Vamsi

**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************


Relevant Pages

  • RE: /usr/bin/ls: 0403-027 The parameter list is too long
    ... You should always use native perl ... CAMPBELL, BRIAN D; ... Thanks and Regards ... the intended recipient/s and may contain material that is CONFIDENTIAL ...
    (perl.dbi.users)
  • Re: /usr/bin/ls: 0403-027 The parameter list is too long
    ... Thanks and Regards ... This email is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. ...
    (perl.dbi.users)
  • func() in DBD:DB2
    ... In this function I am calling dbms_output_enable, ... These are available in dbd:oracle package but not in dbd:db2. ... Thanks & Regards ... intended recipient/s and may contain material that is CONFIDENTIAL AND ...
    (perl.dbi.users)
  • Re: func() in DBD:DB2
    ... > it that we have to write our own customized function for these? ... > intended recipient/s and may contain material that is CONFIDENTIAL AND ... The func() method of a DBD module is to allow the driver writer to include ... Since DB2 doesn't have PL/SQL these aren't relevant. ...
    (perl.dbi.users)
  • help to install dbi
    ... > When am trying to install DBI system throughs the below error. ... > Thanks & Regards, ... intended recipient/s and may contain material that is CONFIDENTIAL AND ...
    (perl.dbi.users)