10-19-2007
File Format issue: Output of sqlplus
Hi,
I am using a query like below in my shell script :
{
{
echo "set echo off"
echo "set head off"
echo "whenever sqlerror exit -1;
select NUMBER ||','||
FNAME ||','||
LOC ||','||
NUM ||','||
DESC ||','||
ID ||','||
INC ||','||
to_char(start_date,'dd-mm-yyyy') ||','||
to_char(end_date,'dd-mm-yyyy')
from emp_details
where .....
} | sqlplus -s testuser/testpass@testdb > EmpDetails.txt
}
As I need a comma separated file.
When the file is created, a sample lines looks like below:
2514,MY_TEST_NAME_IS,351,23728929,THIS_IS_A_TEST VALUEQ,47265,Y,01-04-2008,01-01
-2027
As you can see there is an extra carriage return coming after "01-01" and the "-2027" is going to the next line. This is happening with all the outout lines. Any data after a particular length is going to the next line.
How can I remove this formatting issue?
Thanks
Deepak
10 More Discussions You Might Find Interesting
1. Solaris
Hi Gurus,
I had downloaded the below script from the net and used it to get the Link and duplex settings in my Sun servers.
In all except one(Sol-5.10 on X86) i am getting output format like below:
root: /var/ADMIN/bin/speed_duplex.sh
Interface Speed Duplex
--------- ... (2 Replies)
Discussion started by: Hari_Ganesh
2 Replies
2. Shell Programming and Scripting
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies
3. Shell Programming and Scripting
Hi
I have developed bash script to connect to database and execute .sql files. I am logging some statements in to log file using echo. While logging I am adding the date in front of the log statements which makes sense. I am unable to add date in front of output from the sqlplus and sqlldr,... (8 Replies)
Discussion started by: murtymvvs
8 Replies
4. Shell Programming and Scripting
Hi All,
I tried searching a lot about this but to no avail. I have a HTML file. I used
links -dump file_page.html > text_html.txt
What the above command gave me was a filtered text from the HTML file with tags removed. Now, the the output from the above command looked something like this:... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
5. Shell Programming and Scripting
Dear Friends,
Need your help.
$cat input.txt
TITLE
Date:01-01-2011
Day: Friday
Details Particulares Qty
$
$
$
$
$
$more test.sh
cat input.txt | while read line
do
echo "${line}"
done
$
$ (5 Replies)
Discussion started by: anushree.a
5 Replies
6. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
7. Shell Programming and Scripting
Hi All,
In unix is there any command to format the file in exact order.I have a file which there is no order in the fileds, I need to order it. Its a dat file
wrong format
TDEAIG36533827CB1210004241 EUR20130610BL1300351 refers to CB|CCI|A|A|C|R|T 246.76 ... (1 Reply)
Discussion started by: nag_sathi
1 Replies
8. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
9. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have some questions about sqlplus running from bash. I am still new and learning. I have the code shown below:
echo "exit" | sqlplus... (10 Replies)
Discussion started by: mohca2020
10 Replies
LEARN ABOUT PHP
mssql_field_seek
MSSQL_FIELD_SEEK(3) MSSQL_FIELD_SEEK(3)
mssql_field_seek - Seeks to the specified field offset
SYNOPSIS
bool mssql_field_seek (resource $result, int $field_offset)
DESCRIPTION
Seeks to the specified field offset. If the next call to mssql_fetch_field(3) won't include a field offset, this field would be returned.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $field_offset
- The field offset, starts at 0.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Using mssql_field_seek(3) on the example for mssql_fetch_field(3)
<?php
// Connect to MSSQL and select the database
mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Send a select query to MSSQL
$query = mssql_query('SELECT * FROM [php].[dbo].[persons]');
// Construct table
echo '<h3>Table structure for 'persons'</h3>';
echo '<table border="1">';
// Table header
echo '<thead>';
echo '<tr>';
echo '<td>Field name</td>';
echo '<td>Data type</td>';
echo '<td>Max length</td>';
echo '</tr>';
echo '</thead>';
// Dump all fields
echo '<tbody>';
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
// Fetch the field information, notice the
// field_offset parameter is not set. See
// the mssql_field_seek call below
$field = mssql_fetch_field($query);
// Print the row
echo '<tr>';
echo '<td>' . $field->name . '</td>';
echo '<td>' . strtoupper($field->type) . '</td>';
echo '<td>' . $field->max_length . '</td>';
echo '</tr>';
// Move the internal seek pointer to the next
// row in the result set
mssql_field_seek($query, $i + 1);
}
echo '</tbody>';
echo '</table>';
// Free the query result
mssql_free_result($query);
?>
SEE ALSO
mssql_fetch_field(3).
PHP Documentation Group MSSQL_FIELD_SEEK(3)