Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling scripts from withing scripts

Status
Not open for further replies.
nvaidya

nvaidya

Programmer
Feb 22, 2001
1
US

Hello,

I am new to DB2, and in process of porting our SQL scripts to run in DB2. In Oracle, I can do the following

File: scr2.sql
select * from tab2;

File scr1.sql
select * from tab1;
@scr2.sql

How can I call scr2.sql from scr1.sql in DB2 ? Please pardon if this is a dumb question, but I have tried to search around quite a bit. Thanks.

- Nihar
 
Status
Not open for further replies.

Similar threads

evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
390
evr72
evr72
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
312
pratimsingha
pratimsingha
Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
338
Thomas B
Thomas B
Khaleel2408
  • Locked
  • Question
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client
Replies
0
Views
359
Khaleel2408
Khaleel2408
AMRICE
  • Locked
  • Question
Need Advise from Anyone Converting AS400 Macro to HAScript and HAScript Compatibility with Excel VBA
Replies
0
Views
688
AMRICE
AMRICE

Part and Inventory Search

Sponsor

Back
Top