The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
check if file is empty stolz Shell Programming and Scripting 6 07-24-2007 12:24 PM
File is not empty? lesstjm Shell Programming and Scripting 7 07-12-2007 07:21 AM
How to empty a file(already created) laknar Shell Programming and Scripting 4 07-04-2007 10:00 AM
How to empty a file without removing it. jxh461 UNIX for Dummies Questions & Answers 8 06-01-2007 06:45 AM
empty file in hp-ux Mizi UNIX for Advanced & Expert Users 2 08-09-2006 03:29 AM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-30-2008
Registered User
 

Join Date: Jan 2008
Posts: 8
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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"

statement=${sqlstatement}

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.
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 01-30-2008
Registered User
 

Join Date: Nov 2007
Posts: 43
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
try giving the path from root
Reply With Quote
  #3 (permalink)  
Old 01-30-2008
Registered User
 

Join Date: Nov 2005
Posts: 20
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
correct .....use complete path for the log file .. i experienced it few times and giving complete path helped in this kind of scenario.
Reply With Quote
  #4 (permalink)  
Old 01-30-2008
Registered User
 

Join Date: Jan 2008
Posts: 8
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
The one that I specified is already the complete path. But it still doesn't work.
Reply With Quote
  #5 (permalink)  
Old 01-31-2008
Registered User
 

Join Date: Oct 2007
Posts: 23
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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.

If its working then problem might be with you SQL command you are passing.
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 04:54 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101