01-02-2012
[Solved] Append instead of overwrite
Hi,
I have a script which append the .csv file which already exist but in my scenarion every time instead of appending the contect it overwrite the file and creating new .csv file.
PHP Code:
SET ORAUSR=ops$371664
SET ORAPWD=Oracle12345
SET ORADB=orcl
SET DBCON=%ORAUSR%/%ORAPWD%@%ORADB%
sqlplus -l -s %DBCON% @AEAE.sql >C:\opapps\xmltemp\AEAE.csv
,
What else option i have to mention in this script to append the file.
---------- Post updated at 08:06 AM ---------- Previous update was at 07:58 AM ----------
for append >>
Last edited by radoulov; 01-02-2012 at 09:17 AM..
Reason: Marked as solved.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
if i want to pipe output to a file, say,
cat abc.dat > abc.txt, how do i make it replace the existing file? (9 Replies)
Discussion started by: Duckman
9 Replies
2. UNIX for Dummies Questions & Answers
Hi
im using the following to copy a file to a directory, the user being prompted to overwrite if the file already exists in that directory,
cp -i myfile /home/brief/bin2
but this reveals the path of the directory when being prompted to overwrite (below)
cp: overwrite... (2 Replies)
Discussion started by: ali999
2 Replies
3. UNIX for Dummies Questions & Answers
I am running a command which has a parameter that outputs the results to a file each time it is run.
Here is the command:
--fullresult=true > importlog.xml
Can I add the output to the file rather than creating a new one which overwrites the existing one?
If not can I make the file name... (2 Replies)
Discussion started by: Sepia
2 Replies
4. Shell Programming and Scripting
Ok, I have a script with a commandline option that allows the user to add a custom function to the script file. I have tried everything in my limited knowledge of sed to get this to work and keep coming up short. I need sed to search for a line starting with a pattern, I've got that part so far,... (0 Replies)
Discussion started by: DC Slick
0 Replies
5. Shell Programming and Scripting
Hi All,
I am trying to write a shell script but not getting desired output.
What i am trying to do.
1.I want to use find command command and then use it xargs/exec to append the find output.But i am not getting desired output
here is what i am trying to do
#find init*.ora -exec `echo... (4 Replies)
Discussion started by: sahil_shine
4 Replies
6. Shell Programming and Scripting
Dear All,
I would like to find an automatic way to add a given code which belong to a class at the end of the column , for example this is my input file:
0610009O20Rik
V$VMYB_01 310 (+) 1 0.971 v-Myb
V$EVI1_04 782 (-) 0.763 0.834 Evi-1
V$ELK1_02 1966 (-) 1 0.984 Elk-1... (4 Replies)
Discussion started by: paolo.kunder
4 Replies
7. Shell Programming and Scripting
Hello All,
I had just a question about my Bash Script I'm currently writing.
The script I have writes some text to a output file. After I write to the output file I send the file to another server to do
some stuff with it.
After the file sends in the script, I don't need the output/txt... (4 Replies)
Discussion started by: mrm5102
4 Replies
8. Shell Programming and Scripting
Hi all,
I'm trying to do a basic append into /home/joe/.bashrc:
/usr/bin/test -z `sudo /bin/grep umask /home/joe/.bashrc` && sudo /bin/sed -i '/PATH=/a \
umask 0022
' /home/joe/.bashrc
I run this as user floren with full root privileges in sudoers.
For some reason, the first command is... (1 Reply)
Discussion started by: TECK
1 Replies
9. UNIX for Dummies Questions & Answers
Hi all,
as i have to deal every day with .log and also .csv files,
i would like to know if there is any way to suppress "do you wish to overwrite (y or n)?" prompt with the option no for all prompts,
the command i usually run is the following,
find... (2 Replies)
Discussion started by: charli1
2 Replies
10. Shell Programming and Scripting
I'm overwriting .unl in first run and after that in seq. runs appending by following method. Any other method or command can do it easier?
ARY_VALUE=1
while
do
if ; then
type.sql > out.unl
else
type.sql >>out.unl
fi
ARY_VALUE--;
done (3 Replies)
Discussion started by: Roozo
3 Replies
LEARN ABOUT OSX
set_constraints
SET
CONSTRAINTS(7) SQL Commands SET CONSTRAINTS(7)
NAME
SET CONSTRAINTS - set constraint checking modes for the current transaction
SYNOPSIS
SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }
DESCRIPTION
SET CONSTRAINTS sets the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of
each statement. DEFERRED constraints are not checked until transaction commit. Each constraint has its own IMMEDIATE or DEFERRED mode.
Upon creation, a constraint is given one of three characteristics: DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY IMMEDIATE, or NOT
DEFERRABLE. The third class is always IMMEDIATE and is not affected by the SET CONSTRAINTS command. The first two classes start every
transaction in the indicated mode, but their behavior can be changed within a transaction by SET CONSTRAINTS.
SET CONSTRAINTS with a list of constraint names changes the mode of just those constraints (which must all be deferrable). The current
schema search path is used to find the first matching name if no schema name is specified. SET CONSTRAINTS ALL changes the mode of all
deferrable constraints.
When SET CONSTRAINTS changes the mode of a constraint from DEFERRED to IMMEDIATE, the new mode takes effect retroactively: any outstanding
data modifications that would have been checked at the end of the transaction are instead checked during the execution of the SET CON-
STRAINTS command. If any such constraint is violated, the SET CONSTRAINTS fails (and does not change the constraint mode). Thus, SET CON-
STRAINTS can be used to force checking of constraints to occur at a specific point in a transaction.
Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable.
Triggers that are declared as ``constraint triggers'' are also affected.
NOTES
This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside of a trans-
action block (BEGIN/COMMIT pair), it will not appear to have any effect.
COMPATIBILITY
This command complies with the behavior defined in the SQL standard, except for the limitation that, in PostgreSQL, it only applies to for-
eign-key constraints.
SQL - Language Statements 2010-05-14 SET CONSTRAINTS(7)