06-11-2014
Quote:
Originally Posted by
pamu
Yes agreed, But many times we don't have many options.
I have only putty to access this DB and I want to validate there itself. You should understand that there are many things which are not in our hand in actual world.(basically in any bank)
Then we have to try within our boundaries itself. Don't have any options
.
I have tried all the inputs given in this post but nothing is working for me.
Please suggest how I can achieve this.
Thanks,
Pamu
I wasn't suggesting you do anything any differently, anything that would be outside of your control. Your subject and question simply suggested that you don't have a clear understanding of the relationship of putty to your actual problem, and I was trying to clarify that for you. Perhaps I was reading too much between the lines, but I see a LOT of people who don't have a clear understanding of what processes are happening on their own workstation vs. what is actually happening on a server they are connected to.
I can't suggest "how to achive this" because I don't know where you want this file to end up and what you want to do with it when you get it.
The phrase "nothing is working for me" contains no useful, actionable information. What rdbms product are you issuing the sql statement to? What command line utility are you using to connect to that database and issue the SQL statement? What output ARE you getting? Error messages? A file with something other than what you expect? A file located somewhere other than where you expect?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In
unload to
"/usr/home/data.012202"
I wish to use a date variable as in
unload to
"/usr/home/data.`date`" for the file
is that possible in a query to do, or will i need to add a mv command after the query to do it.
I tried backquotes, , and () on `date` but didn't seem to work
Thanks... (2 Replies)
Discussion started by: Link_02
2 Replies
2. Shell Programming and Scripting
Hi,
I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file.
for example,
i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies
3. Shell Programming and Scripting
Hi ,
I just found you while surfing for the string
'Redirecting sql select query output from within a shell script to txt file/excel file'
Could you find time sending me the code for the above question?
It'll be great help for me.
I have a perl file that calls the sql file... (1 Reply)
Discussion started by: dolphin123
1 Replies
4. Shell Programming and Scripting
Hi Yogesh,
Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel"
I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies
5. Shell Programming and Scripting
Hi All,
I want to format the result driven from the query into neat format.
For example pls find the below code,
#! /bin/sh
result='
sqlplus -s uname/passwrd@DBname
select no,name,address,ph_no, passport_no,salary,designation
from emp_table where salary>1000;
exit
EOF'
... (8 Replies)
Discussion started by: little_wonder
8 Replies
6. UNIX for Dummies Questions & Answers
This is basically what I want to do:
I have a file that contains single lines of IDs.
I want to query the oracle database using these IDs
to get a count of which ones match a certain condition.
the basic idea is:
cat myfile |
while read id
do
$id in select count(PC.ptcpnt_id)
from... (4 Replies)
Discussion started by: whoknows
4 Replies
7. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
8. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
9. UNIX for Advanced & Expert Users
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies
10. Programming
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
PEV(1) General Commands Manual PEV(1)
NAME
pev - show information about MS-Windows excutables files
SYNOPSIS
pev [OPTION]... file
DESCRIPTION
Make an analysis and show useful information of PE32/PE32+ file given.
OPTIONS
-A, --all
Equivalent to -cdhoprs. This is the default action if none is specified.
-c, --coff
Show the COFF file header.
-d, --dos
Show the DOS file header.
-h, --help
Show usage and exit.
-o, --optional
Show the Optional (a.k.a. PE) file header.
-p, --product-version
Show the Product Version (if added by programmer/compiler) of PE file.
-r, --resources
Show first level resource items information.
-s, --sections
Show information about executable sections.
-v, --version
Show version and exit.
EXAMPLES
To get only the Product Version of putty.exe file:
$ pev -p putty.exe
To show DOS and COFF file headers of cards.dll:
$ pev -dc cards.dll
Display all possible information about svchost.exe file:
$ pev svchost.exe
AUTHOR
Written by Coding 40o group
REPORTING BUGS
Report pev bugs at http://sourceforge.net/p/pev/tickets/
COPYRIGHT
Copyright (C) 2010-2011 Coding 40o. Licensed GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>. This is free software:
you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
PEV(1)