Hello,
I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Hi,
I want to get the value of the first field till space in a variable.
e.g x=323 /test/personel/logs/File1
I want to get the first field till space i.e 323 in another variable ,lets say y.
echo $x|cut -d' ' -f1 gives 323
but when I'm trying y=`echo $x|cut -d' ' -f1 its giving... (3 Replies)
Hi,
I am trying to execute this command
if ; then
but getting error .Some problem with reteriving the value of $exception_info.
Please help.Its urgent.
thanks (4 Replies)
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Hi Guys,
I have written a script that declares all the variables and its values in a conf file.
Now i use a variable whose value i need to change it in one of the sub-file that is used in the script.
In the startup file i want to print or check its value.
The value get changed and printed... (5 Replies)
Hi,
I am trying to fetch the different values in an xml file by searching with the same variable in AIX Server.
<name>SharedResources/Shared/JNDI/Username</name>
<value>admin</value> <name>SharedResources/Shared/JNDI/Username</name>
... (1 Reply)
Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file.
It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is... (4 Replies)
I am having a file called variable_info.ksh in that file I am having following global variable information like…
EMAIL_PATH=/var/mail
TMP_PATH=/home/tmp
And we are having another temporary parameter file abcd.txt, in that file we are having the following information like…
EMAIL|EMAI_PATH
I... (4 Replies)
Input.txt
NOTE1|VALUE1|HMM|UPSTR|
NOTE2||HMP|UPSTR|
NOTE3|VALUE3|HML|UPSTR|
NOTE4||HMD|UPSTR|
NOTE5|VALUE5|HMS|UPSTR|
NOTE6|VALUE6|HSD|UPSTR|
NOTE7||HSS|UPSTR|
NOTE8|VALUE8|HEE|UPSTR|
NOTE9|VALUE9|HER|DOWNSTR|
NOTE50|VALUE1|HEE|DOWNSTR|
I am trying to read field 1, 2 and 3 from the... (4 Replies)
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT CENTOS
end
END(7) PostgreSQL 9.2.7 Documentation END(7)NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7).
PARAMETERS
WORK, TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK(7) to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.
SEE ALSO BEGIN(7), COMMIT(7), ROLLBACK(7)PostgreSQL 9.2.7 2014-02-17 END(7)