Frequently Used Commands
The following are some of the commands that are frequently used on any Websphere Commerce project. As and I when I find a new command that is likely to be used on a regular basis, I will update this page. Click on the relevant pages to see more commands under each section.
1. DB2(Additional Commands)
Connecting to a Database.
If you constantly work with database sql, this is perhaps the most used command.
Command: connect to {DBName} user {userId} using {password}
Example: connect to WCS user wcsadmin using password.
2. Oracle(Additional Commands)
Connecting to a Database.
I use two versions of this command when connect to a database using a shell prompt or a dos prompt:
Command: sqlplus {userId}@{tnsName}
Example: sqlplus wcsadmin@ora92
When you run this command, you will be asked to enter a password to continue.
Alternative you can enter the password as part of the command as follows:
Command: sqlplus {userId}/{password}@{tnsname}
Example: sqlplus wcsadmin/password@ora92