Search Results

Showing results 1 to 2 of 2 Search took 0.00 seconds. Search: Posts Made By: sup

Forum: Shell Programming and Scripting 10-31-2013

Call Anonymous block from DB2

9,240

Posted By

Call Anonymous block from DB2

Hi,
I have a shell script and im trying to call a .sql file. The sql file has a simple Anonymous block.
The code is

shell script
db2 -tvf query.sql

the sql file contains
SET...

Forum: Shell Programming and Scripting 10-19-2013

Return db2 query value to shell script

9,668

Posted By

Return db2 query value to shell script

Hi,
Im new to DB2.
I need to connect to DB2 from shell script and return the query output back to shell script variable.
this is my code
#!/bin/ksh
db_name=db
db_user=usr
db_pwd=pwd

db2 ...

Showing results 1 to 2 of 2