Db2 command line run script
Asked By
80 points
N/A
Posted on - 01/31/2013
I am on a UNIX workstation, how can I execute a db2 command line run script from windows command prompt? Some commands don't work if executed directly on cmd prompt.
I am on a UNIX workstation, how can I execute a db2 command line run script from windows command prompt? Some commands don't work if executed directly on cmd prompt.
1. Enter "db2" on the command line or could be directly run by using DB2 scripts containing DB2 commands preceded by "db2"
DB2 provides scripts for creating and running SQL statements.
If your CLP script is, ran. db2. And your database name is "sample" then,
To run the script on windows, run these commands.
db2 connect to sample
db2 -vf ran. db2 -t
Â
Hello,
I hope this is useful.