Shell script to get identity value from db2 insert
- From: Justin <kfwolf@xxxxxxxxxxx>
- Date: Tue, 19 Jun 2012 06:25:24 -0700 (PDT)
So the goal is to call an insert statement and then call "identity_val_local" to get the returned identity, but I am getting a syntax error with the following...
db2 "insert into customer (name .... ) values ('Jetson', .....)
newcustomer=`values identity_val_local()`
Also tried the statement without "values"
.
- Follow-Ups:
- Re: Shell script to get identity value from db2 insert
- From: Ben Bacarisse
- Re: Shell script to get identity value from db2 insert
- From: Bill Marcum
- Re: Shell script to get identity value from db2 insert
- Prev by Date: Re: bash or operator
- Next by Date: Re: Shell script to get identity value from db2 insert
- Previous by thread: bash or operator
- Next by thread: Re: Shell script to get identity value from db2 insert
- Index(es):