Sponsored Content
Full Discussion: Order of data in Spool File
Top Forums Shell Programming and Scripting Order of data in Spool File Post 303003060 by cero on Thursday 7th of September 2017 08:44:20 AM
Old 09-07-2017
You could use the sort command on the spool file, but there will be problems for example with headings.
The order by clause is the cleanest and easiest way and was designed to do what you ask for.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK - printing certain fields when field order changes in data file

I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this: sec;src;dst;proto 421;10.10.10.1;10.10.10.2;tcp 426;10.10.10.3;10.10.10.4;udp 442;10.10.10.5;10.10.10.6;tcp sec;src;fac;dst;proto 521;10.10.10.1;ab;10.10.10.2;tcp... (3 Replies)
Discussion started by: eric4
3 Replies

2. Shell Programming and Scripting

how to spool a unix file

hi, can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file .. right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed.. ... (2 Replies)
Discussion started by: kripssmart
2 Replies

3. AIX

Spool data file

Dear Gurus, Tried searching for some clues in this forum but dont seem to be able to find my answer. :confused: Anyway i have a quick question: Today I have produced a messages generated from a application and placed them on the print queue. Before this I had stopped the printer queue, so... (2 Replies)
Discussion started by: lweegp
2 Replies

4. Shell Programming and Scripting

Problem in spool file

Hi, Iam a newbie. When I give the below query at SQL prompt. SQL> select col1||'`ß`'||col2 from tablename where rownum<2; 1-J7WGX`ß`1-7OKC-23 Iam getting ß within appostropies...... If I remove appostropies and give the query it is throwing an error. If I give the same query in spool as... (1 Reply)
Discussion started by: kknayak
1 Replies

5. Shell Programming and Scripting

Help with sort data based on descending order problem

Input file 9.99331e-13 8.98451e-65 9.98418e-34 7.98319e-08 365592 111669 74942.9 0 Desired output 365592 111669 74942.9 7.98319e-08 1.99331e-13 6.98418e-34 (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. Shell Programming and Scripting

Spool file, only if data exists.

Hi All, I have one Question, that is it possible to check the spool output? What i mean to say is "spool the file only if data exists" I am trying to fetch data from a sql query, and want to generate a file, on a condition that the file should be generated, only if the output of the sql... (5 Replies)
Discussion started by: spiabhi
5 Replies

7. Shell Programming and Scripting

how to extract data from numbered files using linux in the numerical order-

Hi experts, I have a list of files containing forces as the only number as follows. Force1.txt Force2.txt Force3.txt Force4.txt Force5.txt . . . . . . . . . Force100.txt I want to put all the data(only a number ) in these forces files in the file with the same order like 1,2,3 ..100 .... (2 Replies)
Discussion started by: hamnsan
2 Replies

8. Shell Programming and Scripting

How to insert gaussian noise to a data with an order with awk?

Hello everybody, My problem is inserting gaussian noise to a file containing data, that is, add every single noise to the number after every 6 character. here is my data 0910 1 2048 32.38 40 20.88 28 35.53 9.62 0.00 MSDMP0 1.790MSDMS1 2.840KCTXP2 4.400KRCMP0 4.600BOZMP0 5.640BOZMS2... (26 Replies)
Discussion started by: miriammiriam
26 Replies

9. Shell Programming and Scripting

Spool Data in a file

Hello, I am trying to spool data from database into a file on solaris through ksh. Data is getting fetched but the problem is record is getting split in to multiple lines. excerpt from sql is whenever sqlerror exit 1; set define on set echo off set feed off set head off set... (1 Reply)
Discussion started by: abhi1988sri
1 Replies

10. Shell Programming and Scripting

How order a data matrix using awk?

is it possible to order the following row clusters from ascending to descending. thanx in advance input 1 2 4 0 1 2 4 0 3 3 3 3 1 5 1 0 1 5 1 0 6 0 0 0 5 1 1 1... (4 Replies)
Discussion started by: quincyjones
4 Replies
scalac(1)							   USER COMMANDS							 scalac(1)

NAME
scalac - Compiler for the Scala 2 language SYNOPSIS
scalac [ <options> ] <source files> PARAMETERS
<options> Command line options. See OPTIONS below. <source files> One or more source files to be compiled (such as MyClass.scala). OPTIONS
The compiler has a set of standard options that are supported on the current development environment and will be supported in future releases. An additional set of non-standard options are specific to the current virtual machine implementation and are subject to change in the future. Non-standard options begin with -X. Standard Options -g:{none,source,line,vars,notc} "none" generates no debugging info, "source" generates only the source file attribute, "line" generates source and line number information, "vars" generates source, line number and local variable information, "notc" generates all of the above and will not perform tail call optimization. -nowarn Generate no warnings -verbose Output messages about what the compiler is doing -deprecation Indicate whether source should be compiled with deprecation information; defaults to off (accepted values are: on, off, yes and no) Available since Scala version 2.2.1 -unchecked Enable detailed unchecked warnings Non variable type-arguments in type patterns are unchecked since they are eliminated by erasure Available since Scala version 2.3.0 -classpath <path> Specify where to find user class files (on Unix-based systems a colon-separated list of paths, on Windows-based systems, a semi- colon-separate list of paths). This does not override the built-in ("boot") search path. The default class path is the current directory. Setting the CLASSPATH variable or using the -classpath command-line option over- rides that default, so if you want to include the current directory in the search path, you must include "." in the new settings. -sourcepath <path> Specify where to find input source files. -bootclasspath <path> Override location of bootstrap class files (where to find the standard built-in classes, such as "scala.List"). -extdirs <dirs> Override location of installed extensions. -d <directory> Specify where to place generated class files. -encoding <encoding> Specify character encoding used by source files. The default value is platform-specific (Linux: "UTF8", Windows: "Cp1252"). Executing the following code in the Scala interpreter will return the default value on your system: scala> new java.io.InputStreamReader(System.in).getEncoding -target: <target> Specify which backend to use (jvm-1.5,msil). The default value is "jvm-1.5" (was "jvm-1.4" up to Scala version 2.6.1). -print Print program with all Scala-specific features removed -optimise Generates faster bytecode by applying optimisations to the program -explaintypes Explain type errors in more detail. -uniqid Print identifiers with unique names (debugging option). -version Print product version and exit. -help Print a synopsis of standard options. Advanced Options -Xassem <file> Name of the output assembly (only relevant with -target:msil) -Xassem-path <path> List of assemblies referenced by the program (only relevant with -target:msil) -Xcheck-null Emit warning on selection of nullable reference -Xdisable-assertions Generate no assertions and assumptions -Xexperimental enable experimental extensions -Xno-uescape Disable handling of u unicode escapes -Xplug-types Parse but ignore annotations in more locations -Xplugin: <file> Load a plugin from a file -Xplugin-disable: <plugin> Disable a plugin -Xplugin-list Print a synopsis of loaded plugins -Xplugin-opt: <plugin:opt> Pass an option to a plugin -Xplugin-require: <plugin> Abort unless a plugin is available -Xprint: <phases> Print out program after <phases> (see below). -Xprint-pos Print tree positions (as offsets) -Xprint-types Print tree types (debugging option). -Xprompt Display a prompt after each error (debugging option). -Xresident Compiler stays resident, files to compile are read from standard input. -Xshow-class <class> Show class info. -Xshow-object <object> Show object info. -Xshow-phases Print a synopsis of compiler phases. -Xsource-reader <classname> Specify a custom method for reading source files. -Xscript <object> Compile as a script, wrapping the code into object.main(). Compilation Phases initial initializing compiler parse parse source files namer create symbols analyze name and type analysis refcheck reference checking uncurry uncurry function types and applications lambdalift lambda lifter typesasvalues represent types as values addaccessors add accessors for constructor arguments explicitouterclasses make links from inner classes to enclosing one explicit addconstructors add explicit constructor for each class tailcall add tail-calls wholeprog perform whole program analysis addinterfaces add one interface per class expandmixins expand mixins by code copying boxing makes boxing explicit erasure type eraser icode generate icode codegen enable code generation terminal compilation terminated all matches all phases ENVIRONMENT
JAVACMD Specify the java command to be used for running the Scala code. Arguments may be specified as part of the environment variable; spaces, quotation marks, etc., will be passed directly to the shell for expansion. JAVA_HOME Specify JDK/JRE home directory. This directory is used to locate the java command unless JAVACMD variable set. JAVA_OPTS Specify the options to be passed to the java command defined by JAVACMD. With Java 1.5 (or newer) one may for example configure the memory usage of the JVM as follows: JAVA_OPTS="-Xmx512M -Xms16M -Xss16M" With GNU Java one may configure the memory usage of the GIJ as follows: JAVA_OPTS="--mx512m --ms16m" EXAMPLES
Compile a Scala program to the current directory scalac HelloWorld Compile a Scala program to the destination directory classes scalac -d classes HelloWorld.scala Compile a Scala program using a user-defined java command env JAVACMD=/usr/local/bin/cacao scalac -d classes HelloWorld.scala Compile all Scala files found in the source directory src to the destination directory classes scalac -d classes src/*.scala EXIT STATUS
scalac returns a zero exist status if it succeeds to compile the specified input files. Non zero is returned in case of failure. AUTHOR
Written by Martin Odersky and other members of the Scala team. REPORTING BUGS
Report bugs to http://lampsvn.epfl.ch/trac/scala. COPYRIGHT
This is open-source software, available to you under a BSD-like license. See accomponying "copyright" or "LICENSE" file for copying condi- tions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. SEE ALSO
fsc(1), sbaz(1), scala(1), scaladoc(1), scalap(1) version 0.4 April 18, 2007 scalac(1)
All times are GMT -4. The time now is 09:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy