06-28-2012
Quote:
Originally Posted by
sri_aue
Can some one help me related to .sql file issue.
Perhaps, if you start your own thread instead of hijacking another's. It's basic netiquette not to do that.
Regards,
Alister
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all,
Have a small problem.
Back in October the pervious sys-admin (of a client's company) made the necessary adjustments to the system clock for daylight savings (Sydney time - +11 GMT).
As far as I can gather, they just amended the time - NO TIMEZONE !?!
Is there an effective and safe... (5 Replies)
Discussion started by: Cameron
5 Replies
2. Shell Programming and Scripting
Hi,
I'm thinking of running a script via cron (every hour) to do the log rolling.
The file is "file.txt" and there going to be 10 files rolling (file.txt.n).
The file is being written constantly by an application.
The script will do the following:
1. cat file.txt > file.txt.0
2. cat... (0 Replies)
Discussion started by: chaandana
0 Replies
3. Shell Programming and Scripting
Hi guys, I was wondering if someone can give me a hand in helping me append transaction header line in a file at the end of the transaction detail lines.
Basically, I have a file that looks like this:
FHEAD File1
THEAD TRANS1-blah
TDETL HI1
TDETL HI2
TDETL HI3
TTAIL TRANS1-blah
THEAD... (3 Replies)
Discussion started by: rookie12
3 Replies
4. AIX
Hi,
is it possible to roll back currently updated Technology level ? what are steps required?
Regards,
Manoj (2 Replies)
Discussion started by: manoj.solaris
2 Replies
5. Linux
I am writing a software product and hope that it will work on a variety of Linux distributions. At the moment, I am trying to create some kind of Linux version of patches/upgrades of installed software. Gathering information on available updates isn't hard, nor is installation of updates, but I... (27 Replies)
Discussion started by: Brandon9000
27 Replies
6. Shell Programming and Scripting
#!/bin/sh
# This script returns the number of rows updated from a function
echo "The execution is starting ....."
sqlplus -silent $UP <<EOF
set serveroutput on
set echo off
set pagesize 0
VAR no_rows_updated NUMBER;
EXEC :no_rows_updated :=0;
DECLARE
CURSOR c_update is
SELECT * FROM... (4 Replies)
Discussion started by: LoneRanger
4 Replies
7. Shell Programming and Scripting
Hi all,
Hopefully you can help. This is what I'm trying to achieve:
Obtain a list of usernames out of an Oracle Database
Based on this list, link each username with an Oracle Internet Directory (OID) GUID
Using the username and GUID perform a database update for all users
Here are the... (7 Replies)
Discussion started by: exm
7 Replies
8. UNIX for Dummies Questions & Answers
Dear Help,
The input file is below ---
13 2238422.00000 101083.00000 0.89024 0.00416 0.00467
14 2238318.00000 101090.00000 0.89100 0.00416 0.00467
15 2238209.00000 101100.00000 0.90964 0.00424 0.00466
16 2238104.00000 101104.00000 0.97568 0.00463 0.00475
17 2237991.00000 101113.00000... (8 Replies)
Discussion started by: Indra2011
8 Replies
9. Programming
What's the difference between BEGIN TRANSACTION vs START TRANSACTION?
Also goes for COMMIT TRANSACTION vs COMMIT? (0 Replies)
Discussion started by: dan139
0 Replies
END(7) SQL Commands 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 [commit(7)].
PARAMETERS
WORK
TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK [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 [commit(7)], which is specified in the SQL standard.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]
SQL - Language Statements 2010-05-14 END(7)