Equivalent of Oracle "@" in db2

[fareeda]

What is the equivalent of "@" (oracle) in db2?

I could use -f option but the basic requirement is to be able to call
file Y from file X.
In Oracle I can have file X as:
---
command 1;
command 2;
@file Y;
disconnect;
---

Can this be done on db2 also?
Regards
Fareeda

[Sathyaram]

If you are in within a db2 script then it is not possible ..

ie
db2 -tvf X

where X is

select * from syscat.triggers
Y

is not possible,
but with X as

db2 "select * from syscat.triggers"
Y

will work ...

http://www-106.ibm.com/developerwork...07fierros.html
will be a good read

Cheers
Sathyaram
www.db2click.com
fa*****@pspl.co.in (fareeda) wrote in message news:<c6**************************@posting.google. com>...

What is the equivalent of "@" (oracle) in db2?

I could use -f option but the basic requirement is to be able to call
file Y from file X.
In Oracle I can have file X as:
---
command 1;
command 2;
@file Y;
disconnect;
---

Can this be done on db2 also?
Regards
Fareeda

[Database Guy]

You can of course use whatever substitutions your operating system
allows, e.g. Korn shell on UNIX:

#!/bin/ksh
EMPNO="00010"
db2 -t <<EOF
SELECT * FROM employee
WHERE empno = '$EMPNO' AND
fired_flag = 'Y';
EOF
if test $? -eq 1; then echo "employee $EMPNO was fired"; fi
[etc]
DG

[Knut Stolze]

fareeda <fa*****@pspl.co.in> wrote:

What is the equivalent of "@" (oracle) in db2?

I could use -f option but the basic requirement is to be able to call
file Y from file X.
In Oracle I can have file X as:
---
command 1;
command 2;
@file Y;
disconnect;
---

Can this be done on db2 also?

In a different way, yes:
------------------------------
SQL statement 1;
SQL statement 2;
! external command;
connect reset;
------------------------------
The "external command" can be a simple "db2 -td -f anotherFile", giving you
the feature you need.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena