In a Linux script, is it possible to execute multiple commands in the same process?

Question

I have a script that contains:

db2 connect to user01
db2 describe indexes for table table_desc

What I figure is happening is the process that executes the first line is different from the process that runs the second line. This means that the process that executes the first line gets the connection while the second process that runs the second line has no connection at all. This is verified because I get an error at the second line saying that there exists no database connection.

Is it possible to have the same process run both commands? Or at least a way to "join" the first process to the second?

This may help: how to run db2 sql command from a command line? — chrisaycock
– chrisaycock, Commented Jun 19, 2013 at 14:45
The solution in that link doesn't really apply to what I was doing but it definitely put me on the right path. — joshualan
– joshualan, Commented Jun 19, 2013 at 17:32

Ansgar Wiechers · Accepted Answer · 2013-06-19 15:28:04Z

7

If you want both instructions to run in the same process you need to write them to a script:

$ cat foo.db2
connect to user01
describe indexes for table table_desc

and run that script in the db2 interpreter:

db2 -f foo.db2

A Here Document might work as well:

db2 <<EOF
connect to user01
describe indexes for table table_desc
EOF

I can't test that, though, since I currently don't have a DB2 on Linux at hand.

answered Jun 19, 2013 at 15:28

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

joshualan Over a year ago

Both of these work great, thanks a lot! This was exactly what I was looking for.

Collectives™ on Stack Overflow

In a Linux script, is it possible to execute multiple commands in the same process?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related