The output file is empty. Please Help

Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers The output file is empty. Please Help
# 1  
Old 01-31-2008
The output file is empty. Please Help

Dear all,

Currently I writing a ksh script to perform some sql query. I already pipe results in a output file. But when I checked it, the output file is empty.

Below is part of the script that I wrote:


function ssttal11
echo "Enter username for the database"
read username

echo "Enter password for the database"
read password

echo "Enter SQL statement"
read sqlstatement

SQL_PLUS_COMMAND="/app/oracle/bin/sqlplus -s ${username}/${password}@ssttal11"


echo "$statement" | $SQL_PLUS_COMMAND
echo "$statement" | $SQL_PLUS_COMMAND > /migration/folder_a/sql_query.out


Do I left anything else? The code seems fine. But it doesn't shows the sql query results in the sql_query.out

Appreciate you all if can help me on this.

Thank you.
# 2  
Old 01-31-2008
try giving the path from root
# 3  
Old 01-31-2008
correct .....use complete path for the log file .. i experienced it few times and giving complete path helped in this kind of scenario.
# 4  
Old 01-31-2008
The one that I specified is already the complete path. But it still doesn't work.
# 5  
Old 02-01-2008
Try some other command in place of SQL command. like ls, cat etc. Check whether its working.
Most of the time it happens that we dig for answer at wrong places. Smilie

If its working then problem might be with you SQL command you are passing.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Parsing null or empty output

I am working an some if then statements for a script. I want to be able to check for alpha characters or empty out put then exit out. if ]]; echo "Serial Number Invaild" then exit 3; How do I account if the output is empty or null in this in this statement. Many thanks (6 Replies)
Discussion started by: andysensible
6 Replies

2. Shell Programming and Scripting

awk to reformat output if input file is empty, but not if file has data in it

The below awk improved bu @MadeInGermany, works great as long as the input file has data in it in the below format: input chrX 25031028 25031925 chrX:25031028-25031925 ARX 631 18 chrX 25031028 25031925 chrX:25031028-25031925 ARX 632 14... (3 Replies)
Discussion started by: cmccabe
3 Replies

3. Shell Programming and Scripting

awk runs but output is empty

The awk below runs, however the output file is 0 bytes. It is basically matching input files that are 21 - 259 records to a file of 11,137,660 records. Basically, what it does is use the input files of which there are 4 to search and match in a large 11,000,000 record file and output the... (4 Replies)
Discussion started by: cmccabe
4 Replies

4. Shell Programming and Scripting

Sent output to email and empty folder at same time

Hi all, i want to sent output to email and folder at same time. This is my code : echo "Hello" | mailx -s "${SUBJECT}" "${email_add}" >> ${file} I only can sent output to my email but cannot sent to my empty folder....can i know how to done it? (1 Reply)
Discussion started by: proghack
1 Replies

5. Shell Programming and Scripting

Transfer output to empty file?

Hi all, I want transfer the echo data into echo " $dir $group " >> ${file.txt} ---------- Post updated at 04:11 PM ---------- Previous update was at 03:10 PM ---------- anybody can help ? i mean in script output like echo " hello" i want transfer that output to file.txt. (4 Replies)
Discussion started by: proghack
4 Replies

6. Shell Programming and Scripting

Output only non-empty arguments

Hello, I am VERY new to shell scripting here, so please go easy. I have an assignment that requires creating a script using bash shell, outputting all command line arguments that are not empty ones such as " ", and showing total number of arguments. I know how to show the total with $# and all... (6 Replies)
Discussion started by: moderwarfare
6 Replies

7. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

8. Shell Programming and Scripting

empty option output error

I have a script ( which launches the program bsim_em.x or bsim_es.x depending on the value entered from the screen: > 1 (executes bsim_em.x) > 2 (executes bsim_es.x) which, simplifying, I do with the following lines in the script: if ... (3 Replies)
Discussion started by: josegr
3 Replies

9. Shell Programming and Scripting

Change output if file is empty

I'm very new to writing scripts, so here is my problem...I have the following code already written (in perl) system "rm file2"; open(FILE2, ">file2"); open(MYINPUTFILE, "file"); while(<MYINPUTFILE>) { my($line) = $_; chomp($line); print file2 "$line\n"; print... (2 Replies)
Discussion started by: ddrew78
2 Replies

10. UNIX for Dummies Questions & Answers

Getting same exit status for empty and non empty file

Hi All, I am checking for a empty input file to do some further action , but I am getting exit status 0 in both the cases , for empty and non empty file both. The value of $? is coming 0 in if part also and else part too. #!/bin/ksh if ]; then echo "data" # exit 0 echo "$?" else... (4 Replies)
Discussion started by: mavesum
4 Replies
Login or Register to Ask a Question