|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 27th, 2005, 05:40 AM
|
|||
|
|||
DB2 Script File?
Hi Everyone
Can sombody kindly tell me how to execute a SQL Script file in DB2? I'm using DB2 Express Edition (Ver 8.2) on Windows 2000 Server. I want to create Tables, set constraints, create functions, stored procedures, triggers, etc. What should be the extension of the file. Thanks
|
|
#2
July 28th, 2005, 12:56 AM
|
||||
|
||||
|
From a db2 command line use
Code:
db2 -t -f <name of file> Extensions don't matter, just the format of the file. The -t signifies a semicolon (by default) is the terminator of a command.
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > DB2 Script File? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
