Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBI-DB2 database question

Status
Not open for further replies.

moof15

Programmer
Aug 22, 2002
23
0
0
US
I would like to know if it is possible after you connect to the database using DBI then you can call a sql file with create tables in the file?

Thanks,
Moof15
 
Moof,

Not directly no, but you could read the file in and pass the SQL in that file to DB2.

If you have multiple SQL statements in the file, you could split it into single statements by searching for ; characters. Mike
________________________________________________________________

"Experience is the comb that Nature gives us, after we are bald."

Is that a haiku?
I never could get the hang
of writing those things.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top