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

Hi ,

Thanks for replying.

My problem is, the perl script successfully gets rows from oracle database
but I have to insert it into similar table in db2 i.e( x in oracle -> x in
db2) . For this I need to know the datatypes of columns (varchar, char,date
,timestamp) as these need quotes for insertion.

Hope you got my problem

Thanks & Regards
Vamsi

-----Original Message-----
From: Thutika, Srinivas (ODC - Satyam) [mailto:SThutika@xxxxxxxxxxxxxxxxx]
Sent: Thursday, April 14, 2005 7:48 PM
To: Vamsi_Doddapaneni
Subject: RE: how to get datatype of columns of a table in perl script

Hi ,


I have worked in perl ..for database...

I can help u in getting the values from databse..

But I have to explore for getting the type of data...


Regares,
Srinivas.

-----Original Message-----
From: Vamsi_Doddapaneni [mailto:Vamsi_Doddapaneni@xxxxxxxxxx]
Sent: Thursday, April 14, 2005 7:39 PM
To: dbi-users@xxxxxxxx
Subject: how to get datatype of columns of a table in perl script
Importance: High


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.
**************************************************************************
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute it. Click here for important additional terms relating to
this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------
**************************************************************************
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: Réf. : RE: connect to oracle database as sysdba form windows
    ... connect to oracle database as sysdba form windows ... it and all copies from your system and notify the sender immediately by return e-mail. ... The sender does not accept liability for any errors or omissions which arise as a result. ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • RE: how to get datatype of columns of a table in perl script
    ... given a valid connect to Oracle: ... the perl script successfully gets rows from oracle database ... PRIVATE COMPANY INFORMATION. ... If you are not an intended recipient of this e-mail, ...
    (perl.dbi.users)
  • RE: connect to oracle database as sysdba form windows
    ... connect to oracle database as sysdba form windows ... This electronic message transmission is a PRIVATE communication which contains ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: Calling functions using variable (I mean symbolic refs)
    ... >I have a Perl script with lot of functions. ... >Confidentiality Notice ... >and destroy all copies of this message and any attachments. ... you are not the intended recipient, please notify the sender at Wipro or Mailadmin@wipro.com immediately ...
    (perl.beginners)
  • RE: Performance Tuning of batch insert and batch update using JDBC API.
    ... how exactly are you doing the DB2 9 ... Is it truly an insert or is it a "load" operation that is "not ... intended recipient, you are hereby notified that any reproduction, ... If you have received this communication in error, ...
    (comp.databases.informix)