Sponsored Content
Full Discussion: any one help
Top Forums UNIX for Advanced & Expert Users any one help Post 302136493 by Ehab on Tuesday 18th of September 2007 05:20:50 AM
Old 09-18-2007
any one help

how can i run sql patch from unix shell like this:

sql "to log in sql"
update table1 set flag=1 where stat=1;
commit;
exit "to exit from sql"

I want to run it on the crontab but on this way it didnt work
 
cvm-pgsql(8)						      System Manager's Manual						      cvm-pgsql(8)

NAME
cvm-pgsql - PgSQL module SYNOPSIS
cvm-pgsql CREDENTIALS
Pass phrase DESCRIPTION
This module queries a PgSQL database for the account name, compares the stored pass phrase with the given one using crypt(3). CONFIGURATION VARIABLES
The server hostname, port, database, username, password, and additional options can be controlled by setting $PGHOST, $PGPORT, $PGDATABASE, $PGUSER, $PGPASSWORD, and $PGOPTIONS respectively, which are parsed by the PgSQL client library. CVM_MYSQL_POSTQ (optional) The SQL query to execute after the credentials have been validated, see cvm-sql(7). CVM_PGSQL_PWCMP (optional) The password comparison module to use. CVM_PGSQL_QUERY (optional) The SQL query to issue to retrieve the row containing the account information from the database. SEE ALSO
cvm-sql(7), cvm-mysql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test- client(8) http://untroubled.org/pwcmp/pwcmp.html http://untroubled.org/cvm/cvm.html cvm-pgsql(8)
All times are GMT -4. The time now is 05:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy