1

Spool Data in a file

view story
linux-howto

http://www.unix.com – 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 Code: whenever sqlerror exit 1; set define on set echo off set feed off set head off set trimspool on set verify off set linesize 150 set newpage 0 set pagesize 0 set space 0   select * from &2;   SPOOL OFF; quit; Table data is (below each field separated by space): Code: D 11 120822FX400000046 208101981802950 33602205271 63080 G    01 20120713120718  &nbs (HowTos)

more's picture
Submitted by more on 09/11/2012

Stories similar to Spool Data in a file

I am trying to get the data from oracle table to a variable I have tried the below code

Code: #/usr/bin/sh         echo " I am in correct loop"         SPOOL_FILE=/app/scripts/alt.lst       sqlplus /nolog  <<END_SQL         connect bindu/bindu@gis         whenever sqlerror exit

I am fetching a database table in spool file and send that details as a email.

The Spooled file content is properly being displayed in UNIX.

See Example below :

Code:         ID|FILENAME        |ABCDEF_DT |PROCESSED_DT        |STATUS ----------|-----------------|----------|--------------------|----------     &nbsp

String matching using awk 37 weeks 6 days ago

Hello,

I am working with google ngram data set which is of size 100s of gb.

Getting a 90% disc full alert 1 year 13 weeks ago

Hello experts, need help One of filesystem on my solaris server is 90% full

/dev/dsk/c1t0d0s3 32G 28G 3.3G 90% /usr

here is contents of the folder

HTML Code: jboss-ie10ux013:/usr\n\r-> ls 4lib        X11R6      ccs        j2se        lost+found  openv      proc   

Hello, I have a comma seperated data sheet with multiple fields of biological data. One column contains the ID name of the sample, where there could be more than one sample separated by a comma. I would like a script that reads this field, and for each sample ID, copies the entire line and writes it below.

Example data

Code: Gi1/10  Gi1/12          xl32lytscb07 3/11                to nyc 3/12                41764 ecomm 3/13                hxcsxsa 2/1 3/14                ziim570-rsvd 3/15    &

Hi,

I have a csv file which contains data that looks something like this:

Code: Key1 Key2 Key3 New_Key1 New_Key2 New_Key3 102  30      0        -                -                  - 102  40      1        30    &nbsp

Pivoting the data 25 weeks 8 hours ago

Hello Unix guys,

I have the following 4 column data, which is a output of db2 select query:

Need to pivot the data.

sample Input: Year Month Country Counts

Code:       2012 Aug    Canada        114       2012 Aug    USA          92       2012 Aug    Mexico  &n

Good day all.

I have the following entries of data in a file in a column, however, I need this data written on a single line with several parameters in a different order.

Current format:

Code: Treatment       ,parmeter1=value       ,parmeter2=value       ,parmeter3=value       ,parmeter4=value       ,parmeter5=value