10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file.
psql -U postgres -d database -o textfile.txt << EOF
Query1;
Query2;
Query ....;
EOF
When executing the script, queries outputs are directed to textfile.txt, however... (2 Replies)
Discussion started by: nms
2 Replies
2. Shell Programming and Scripting
Hi All,
I have a file queries.txt as follows :
SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT... (2 Replies)
Discussion started by: SriRamKrish
2 Replies
3. Shell Programming and Scripting
In a .txt file i have a set of teradata queries which i need to execute and capture result for all queries.Is there any way to run teradata queries from a file? (1 Reply)
Discussion started by: katakamvivek
1 Replies
4. Shell Programming and Scripting
Hi,
I have written a small script to transfer a file from one unix server to other using scp command which is working fine. As I know with scp, if any file with the same name is already present on destination server, it would get overwritten without any notification to user. Could anyone help me... (14 Replies)
Discussion started by: dsa
14 Replies
5. Emergency UNIX and Linux Support
Hello friends,
I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences.
my sql query file will consist of 50.000 times the below line consecutively:
insert into subscriber... (6 Replies)
Discussion started by: EAGL€
6 Replies
6. Shell Programming and Scripting
Hi All,
it might not be an sound question,
i have two server like A and B..
i want to transfer file from B to A
..here i have some questions..
1) do we need to create private and public key to connect..and
transferring files...from B to A..?
2) i tried with scp options like... (2 Replies)
Discussion started by: Shahul
2 Replies
7. Shell Programming and Scripting
Hi,
I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible.
List of queries are stored in a file. For example, I have to run a query like this:
Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies
8. UNIX for Dummies Questions & Answers
Dear all,
Can anybody let me know how to automate a file transfer process to a remote m/c thru SFTP , automate means it will not prmpt for password.
how i am going to achive this....and what all methods are available or tools are available ???? (2 Replies)
Discussion started by: manas_ranjan
2 Replies
9. Shell Programming and Scripting
hi all
how do i copy a file from one server to another
thanks
bkan77 (4 Replies)
Discussion started by: bkan77
4 Replies
10. UNIX for Dummies Questions & Answers
Can anyone help..
I have a .dat file which contains 5 columns of data. I need to select one row containing just 3 of the columns. I'm not sure how to select a single row? I then need perform arithmetic on on two out of the three columns and display the output in a new column.
For example..
... (1 Reply)
Discussion started by: computersaysno
1 Replies