Sunday 2 February 2014

How to run the sql scripts on SHR

Login to SHR server with administrative privilages

go to Start -> Run then type dbisql.exe



Make sure the ODBC data source name is selected as SHRDB.

press connect. (if you are using the default DSN created during the installation no need to input the username and password)

Once it is connected to DB.


go to file menu -> run script  and browse and select the script.  This will run the script and provide the output to default location which is this case C:\HP-SHR\Sybase\IQ15_4\Bin64

In the above screenshot this items are marked in red color. Cut the output file from this location and send it to HP (Make sure this location clean and remove the output files from this location after the activity)


No comments:

Post a Comment