Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: #Spool/Query executing with extra space.
Top Forums UNIX for Dummies Questions & Answers #Spool/Query executing with extra space. Post 302897621 by Mohammed_Tabish on Tuesday 15th of April 2014 07:07:30 AM
Old 04-15-2014
Thanku dod,

the rpad functn to replace the spaces worked, i just did some changes in the numbers.

thanks a lot.Smilie
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

NOQUEUE: low on space ( have 0, SMTP-DAEMON needs 101 in /var/spool/mqueue)

hi, I'm in Solaris 2.8 env. When i'm trying to add a ftp user account , encountered "no space in disk" .. couldn't create any user. Then check the fs disk space with "df - k " and /var/adm/syslog .. got the below message. Jun 9 03:10:53 mail sendmail: NOQUEUE: low on space (have 0,... (10 Replies)
Discussion started by: Dolly
10 Replies

2. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks (2 Replies)
Discussion started by: kingluke
2 Replies

3. Shell Programming and Scripting

To spool output from a database query

Hi all, I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script: ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1" OUTFILE="/tmp/invalid.out" FILE="$HOME/admin/scripts" $ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies

4. Programming

Single sql query to spool to multiple files

Is there anyway to spool my select statement into spool files of max 10000 records each? eg I have a select statement that will return 45000 records. A normal spool command will output the 45000 into just one spool file. How can I make sqlplus do this? 00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies

5. Shell Programming and Scripting

extra space issue with awk

for diskname in $(lspv |awk '{print $1}') do lquerypv -h /dev/|awk '/'$diskname'/ { print ; exit }' done No output is returning from the loop. I think awk put an extra space to the command - lquerypv -h /dev/ so that the command is executed as i.e. lquerypv -h /dev/ hdisk230 with a space... (7 Replies)
Discussion started by: Daniel Gate
7 Replies

6. Shell Programming and Scripting

m4 adds extra space at top of file.

I have used m4 in the past to generate source code where aesthetics and space were of no consequence . Now I am using it to generate script and program templates . So here is an excerpt from my m4 file for producing a generic bash script: dnl `$Id$' define(`START_SCRIPT',`#!/bin/bash... (8 Replies)
Discussion started by: Bubnoff
8 Replies

7. Shell Programming and Scripting

my shell now adds extra space at end of each line!

Hi, Since today, with csh or tcsh, if I do 'ls files* > list', every lines end with an extra space! What happenned? What can I do to go back when there was no extra space? If I change to bash, there's no extra space. Thanks, Patrick ---------- Post updated at 03:19 PM... (1 Reply)
Discussion started by: trogne
1 Replies

8. Shell Programming and Scripting

[Solved] Howto remove extra space in the file

Hi Gurus, I have a file which contains some special char or space. when using cat -evt I can see the file as following: 0,"0000","abc/def aaa ... (6 Replies)
Discussion started by: ken6503
6 Replies

9. Shell Programming and Scripting

Query on executing awk using SSH

Hi All, Im trying to find the count of process running on remote server using SSH. Below command dosen't work. ssh -q user@host "ps -ef | grep "pattern" | grep -v 'grep' | awk '{print $2}'|wc -l" But below command works. ssh -q user@host "ps -ef | grep "pattern" | grep -v... (1 Reply)
Discussion started by: Girish19
1 Replies

10. Shell Programming and Scripting

Extra Space in output - remove

Hi All I am trying to perform the below operation -count=`cat abc.txt | wc -l` echo$count 5 Head=Start"$DATE"00000"$count"File echo $HEAD START15020300000 5File There is a space coming before 5 which is not needed . How to ignore that . (4 Replies)
Discussion started by: honey26
4 Replies

LEARN ABOUT CENTOS

snmptranslate

SNMPTRANSLATE(1)						     Net-SNMP							  SNMPTRANSLATE(1)

NAME

       snmptranslate - translate MIB OID names between numeric and textual forms

SYNOPSIS

       snmptranslate [OPTIONS] OID [OID]...

DESCRIPTION

       snmptranslate  is  an  application that translates one or more SNMP object identifier values from their symbolic (textual) forms into their
       numerical forms (or vice versa).

       OID is either a numeric or textual object identifier.

OPTIONS

       -D[TOKEN[,...]]
	       Turn on debugging output for the given TOKEN(s).  Try ALL for extremely verbose output.

       -h      Display a brief usage message and then exit.

       -m MIBLIST
	       Specifies a colon separated list of MIB modules to load for this application.  This overrides the environment variable MIBS.

	       The special keyword ALL is used to specify all modules in all directories when searching for MIB files.	Every file whose name does
	       not begin with "." will be parsed as if it were a MIB file.

       -M DIRLIST
	       Specifies a colon separated list of directories to search for MIBs.  This overrides the environment variable MIBDIRS.

       -T TRANSOPTS
	       Provides control over the translation of the OID values.  The following TRANSOPTS are available:

	       -Td   Print full details of the specified OID.

	       -Tp   Print a graphical tree, rooted at the specified OID.

	       -Ta   Dump the loaded MIB in a trivial form.

	       -Tl   Dump a labeled form of all objects.

	       -To   Dump a numeric form of all objects.

	       -Ts   Dump a symbolic form of all objects.

	       -Tt   Dump a tree form of the loaded MIBs (mostly useful for debugging).

	       -Tz   Dump a numeric and labeled form of all objects (compatible with MIB2SCHEMA format).

       -V      Display version information for the application and then exit.

       -w WIDTH
	       Specifies the width of -Tp and -Td output. The default is very large.

       In  addition  to  the  above options, snmptranslate takes the OID input (-I), MIB parsing (-M) and OID output (-O) options described in the
       INPUT OPTIONS, MIB PARSING OPTIONS and OUTPUT OPTIONS sections of the snmpcmd(1) manual page.

EXAMPLES

       o   snmptranslate -On -IR sysDescr
	   will translate "sysDescr" to a more qualified form:

	   system.sysDescr

       o   snmptranslate -Onf -IR sysDescr
	   will translate "sysDecr" to:

	   .iso.org.dod.internet.mgmt.mib-2.system.sysDescr

       o   snmptranslate -Td -OS system.sysDescr
	   will translate "sysDecr" into:

	   SNMPv2-MIB::sysDescr
	   sysDescr OBJECT-TYPE
	     -- FROM SNMPv2-MIB
	     -- TEXTUAL CONVENTION DisplayString
	     SYNTAX OCTET STRING (0..255)
	     DISPLAY-HINT "255a"
	     MAX-ACCESS read-only
	     STATUS current
	     DESCRIPTION "A textual description of the entity. This
			  value should include the full name and
			  version identification of the system's
			  hardware type, software operating-system,
			  and networking software."
	   ::= { iso(1) org(3) dod(6) internet(1) mgmt(2) mib-2(1) system(1) 1 }

       o   snmptranslate -Tp -OS system
	   will print the following tree:

	   +--system(1)
	      |
	      +-- -R-- String	 sysDescr(1)
	      |        Textual Convention: DisplayString
	      |        Size: 0..255
	      +-- -R-- ObjID	 sysObjectID(2)
	      +-- -R-- TimeTicks sysUpTime(3)
	      +-- -RW- String	 sysContact(4)
	      |        Textual Convention: DisplayString
	      |        Size: 0..255
	      +-- -RW- String	 sysName(5)
	      |        Textual Convention: DisplayString
	      |        Size: 0..255
	      +-- -RW- String	 sysLocation(6)
	      |        Textual Convention: DisplayString
	      |        Size: 0..255
	      +-- -R-- Integer	 sysServices(7)
	      +-- -R-- TimeTicks sysORLastChange(8)
	      |        Textual Convention: TimeStamp
	      |
	      +--sysORTable(9)
		 |
		 +--sysOREntry(1)
		    |
		    +-- ---- Integer   sysORIndex(1)
		    +-- -R-- ObjID     sysORID(2)
		    +-- -R-- String    sysORDescr(3)
		    |	     Textual Convention: DisplayString
		    |	     Size: 0..255
		    +-- -R-- TimeTicks sysORUpTime(4)
			     Textual Convention: TimeStamp

       o   snmptranslate -Ta | head
	   will produce the following dump:

	   dump DEFINITIONS ::= BEGIN
	   org ::= { iso 3 }
	   dod ::= { org 6 }
	   internet ::= { dod 1 }
	   directory ::= { internet 1 }
	   mgmt ::= { internet 2 }
	   experimental ::= { internet 3 }
	   private ::= { internet 4 }
	   security ::= { internet 5 }
	   snmpV2 ::= { internet 6 }

       o   snmptranslate -Tl | head
	   will produce the following dump:

	   .iso(1).org(3)
	   .iso(1).org(3).dod(6)
	   .iso(1).org(3).dod(6).internet(1)
	   .iso(1).org(3).dod(6).internet(1).directory(1)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2).mib-2(1)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2).mib-2(1).system(1)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2).mib-2(1).system(1).sysDescr(1)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2).mib-2(1).system(1).sysObjectID(2)
	   .iso(1).org(3).dod(6).internet(1).mgmt(2).mib-2(1).system(1).sysUpTime(3)

       o   snmptranslate -To | head
	   will produce the following dump

	   .1.3
	   .1.3.6
	   .1.3.6.1
	   .1.3.6.1.1
	   .1.3.6.1.2
	   .1.3.6.1.2.1
	   .1.3.6.1.2.1.1
	   .1.3.6.1.2.1.1.1
	   .1.3.6.1.2.1.1.2
	   .1.3.6.1.2.1.1.3

       o   snmptranslate -Ts | head
	   will produce the following dump

	   .iso.org
	   .iso.org.dod
	   .iso.org.dod.internet
	   .iso.org.dod.internet.directory
	   .iso.org.dod.internet.mgmt
	   .iso.org.dod.internet.mgmt.mib-2
	   .iso.org.dod.internet.mgmt.mib-2.system
	   .iso.org.dod.internet.mgmt.mib-2.system.sysDescr
	   .iso.org.dod.internet.mgmt.mib-2.system.sysObjectID
	   .iso.org.dod.internet.mgmt.mib-2.system.sysUpTime

       o   snmptranslate -Tt | head
	   will produce the following dump

	     org(3) type=0
	       dod(6) type=0
		 internet(1) type=0
		   directory(1) type=0
		   mgmt(2) type=0
		     mib-2(1) type=0
		       system(1) type=0
			 sysDescr(1) type=2 tc=4 hint=255a
			 sysObjectID(2) type=1
			 sysUpTime(3) type=8

SEE ALSO

       snmpcmd(1), variables(5), RFC 2578-2580.

V5.7.2								    20 Jul 2010 						  SNMPTRANSLATE(1)
All times are GMT -4. The time now is 05:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy