<div>
You're welcome!<br />
Check out this link for a manual on Qshell:<br />
<a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzahz/rzahz.pdf" rel="ugc nofollow">http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzahz/rzahz.pdf</a><br />
There is a section on path names that qshell uses to search for files.<br />
Barry<br />

</div>


You're welcome!
Check out this link for a manual on Qshell:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzahz/rzahz.pdf [http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzahz/rzahz.pdf]
There is a section on path names that qshell uses to search for files.
Barry


<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I'm trying to create a database in DB2 from within QShell using an sql script in a file. The command I'm using is:<br />
<br />
db2 -Svtf mysqcript.sql<br />
<br />
However, I get an error: UNABLE TO OPEN FILE: mysqcript.sql RC=3025<br />
<br />
I guess this means it can't find my file. <br />
<br />
Where in the IFS should I be storing the script file?<br />
<br />
Cheers.<br />

</div>
</div>


Hi there,

I'm trying to create a database in DB2 from within QShell using an sql script in a file. The command I'm using is:

db2 -Svtf mysqcript.sql

However, I get an error: UNABLE TO OPEN FILE: mysqcript.sql RC=3025

I guess this means it can't find my file. 

Where in the IFS should I be storing the script file?

Cheers.


Running an SQL script file in QSH

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.