Home: Perl Programming Help: DBI:
Perl DBI: store the ddl of a column in a variable



db_fan
New User

May 9, 2015, 3:12 PM


Views: 14604
Perl DBI: store the ddl of a column in a variable

Hi,
In Perl DBI, can I store the ddl of a column in a variable? My objective, is to use the definition of the column to create a temp table in another database.

Mike


Zhris
Enthusiast

May 9, 2015, 3:31 PM


Views: 14601
Re: [db_fan] Perl DBI: store the ddl of a column in a variable

Hi,

DBI has a column_info method, as well as similar methods for fetching other schema level data. Of course you can also select this information from the ddl's internal views yourself, the relevant DBD module source should provide useful statements.

Chris


(This post was edited by Zhris on May 9, 2015, 3:42 PM)


db_fan
New User

May 9, 2015, 3:42 PM


Views: 14594
Re: [Zhris] Perl DBI: store the ddl of a column in a variable

Thank you Chris.
What if I have a number of columns? in Perl DBI, I need to create a temp table of those columns and generate a ddl of the temp table on Database A. Then, the DDL of the temp table will be loaded on database B.
Do you have any hints on how to do that?

Mike


Zhris
Enthusiast

May 9, 2015, 3:44 PM


Views: 14593
Re: [db_fan] Perl DBI: store the ddl of a column in a variable

What database driver are you using, MySQL?

Chris


db_fan
New User

May 9, 2015, 3:44 PM


Views: 14591
Re: [Zhris] Perl DBI: store the ddl of a column in a variable

Using DB2

Mike


Zhris
Enthusiast

May 9, 2015, 3:51 PM


Views: 14588
Re: [db_fan] Perl DBI: store the ddl of a column in a variable

I'm not familiar with DB2, have you looked into the syscat tables, specifically the syscat.columns table? It appears you can select all the information you require in one hit off this table.

Apologies, are you stuck on using Perl's DBI module, as oppose to how to get the information as per your original post?

Chris


(This post was edited by Zhris on May 9, 2015, 4:06 PM)