04-05-2011
Try putting the closing EOF at the start of the line (i.e. do not indent it with spaces)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have 2 files with sample data enclosed.
1. GL (already sorted in ascending order by Gl number)
Gl number*glname*Year*opening balance
1000*Interest Income*2006*100.00
1005*Rental Income*2006*0.00
...
2. Transactions (file is not sorted on GL number or any other field)
Branch*Year*Gl... (12 Replies)
Discussion started by: augustinep
12 Replies
2. Shell Programming and Scripting
Hi,
I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ?
Thanks,
Sateesh (2 Replies)
Discussion started by: kotasateesh
2 Replies
3. Shell Programming and Scripting
I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format .
The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
4 Replies
4. Shell Programming and Scripting
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies
5. Shell Programming and Scripting
Our vendor produces a report that I would like to format in a particular way.
Here is the sample output from their report:
# AA.INDEX 2 11 2 239 52 (7,2) 07 MAY 11 203.1 55
# ACCOUNT 2 89561 2 ... (4 Replies)
Discussion started by: thaller
4 Replies
6. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
7. Shell Programming and Scripting
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
Discussion started by: rameshds
0 Replies
8. Shell Programming and Scripting
hi folks
am running the shell script below
#!/bin/bash
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON
--# Fire the query on database
select *
from employee;
... (2 Replies)
Discussion started by: coolboy98699
2 Replies
9. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
10. UNIX for Dummies Questions & Answers
I am trying to write a shell script which dynamically reads all the .sql (oracle sql files) from a particular directory and generates a .csv file in the target directory.
I have started first with the below sample script to see if it is working but I am not able to get it executed, please help... (7 Replies)
Discussion started by: mora
7 Replies
LEARN ABOUT DEBIAN
printfail
MESSAGES(3) libbash messages Library Manual MESSAGES(3)
NAME
messages -- libbash library that implements a set of functions to print standard status messages
SYNOPSIS
printOK [indent]
printFAIL [indent]
printNA [indent]
printATTN [indent]
printWAIT [indent]
DESCRIPTION
General
messages is a collection of functions to print standard status messages - those [ OK ] and [FAIL] messages you see during Linux boot process.
The function list:
printOK Prints a standard [ OK ] message (green)
printFAIL Prints a standard [FAIL] message (red)
printNA Prints a standard [ N/A] message (yellow)
printATTN Prints a standard [ATTN] message (yellow)
printWAIT Prints a standard [WAIT] message (yellow)
Detailed interface description follows.
indent
Column to move to before printing.
Default indent is calculated as TTY_WIDTH-10. If current tty width can not be determined (for example, in case of serial console), it
defaults to 80, so default indent is 80-10=10
FUNCTIONS DESCRIPTIONS
printOK [indent]
Prints a standard [ OK ] message (green)
printFAIL [indent]
Prints a standard [FAIL] message (red)
printNA [indent]
Prints a standard [ N/A] message (yellow)
printATTN [indent]
Prints a standard [ATTN] message (yellow)
printWAIT [indent]
Prints a standard [WAIT] message (yellow)
EXAMPLES
Run a program named MyProg, and report it's success or failure:
echo -n 'Running MyProg...'
printWAIT
if MyProg ; then
printOK
else
printFAIL
fi
AUTHORS
Hai Zaar <haizaar@haizaar.com>
Gil Ran <gil@ran4.net>
SEE ALSO
ldbash(1), libbash(1)
Linux Epoch Linux