01-13-2009
Hi,
I want to spool the output of query to a .txt file but when i am doing that along with the output of the query i am getting query itself and spool off in the output .txt file.
Plz tell me how can i just get the output of the query in the .txt file.
Thanks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Does anybody know if HP-UX uses any other directories besides /var/spool/lp/request to spool print jobs? I checked the man pages, and it only mentions /var/spool/lp in general. I was just wondering if anyone knew of some other place it might possibly use. thanks in advance for any help! (2 Replies)
Discussion started by: doeboy
2 Replies
2. UNIX for Dummies Questions & Answers
Hi
From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp.
can someone help me to do that .
Thanks... (2 Replies)
Discussion started by: ukadmin
2 Replies
3. Shell Programming and Scripting
hi,
can anyone help me with spool command..
i want to spool a file.. i am getting the output of an sql query into a file in the unix environment.. i want to spool the contents of this file to create a .lst file..
as of now, i am giving it like -
sql.sql : spool on
select... (4 Replies)
Discussion started by: kripssmart
4 Replies
4. UNIX for Dummies Questions & Answers
Hi! Everyone
I am new to the shell scripting basically.I have been asked to create a shell script that connect to a oracle database to read data from a particular schema then spool it into a csv file then email to customer.
Can anybody let me know how to go about that.
I have create... (14 Replies)
Discussion started by: Mr Mo
14 Replies
5. UNIX for Dummies Questions & Answers
Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement.
Thanks,
Akbar (4 Replies)
Discussion started by: s1a2m3
4 Replies
6. Shell Programming and Scripting
Hi ,
Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this..
O/p is coming as header till batch id ,im not able to see date_stored,type,type1..
Please any one can give me some suggestion
... (1 Reply)
Discussion started by: jkumsi
1 Replies
7. Shell Programming and Scripting
Hi everyone and nice to meet you :)
I'm having some issues with a script I'm writing.
It's probably most chaotic, I'm no ksh guru, but the idea is to extract an ID with that query, spool it into a file, and read that file making the ID a variable. This has to be done for every row extracted by... (10 Replies)
Discussion started by: Arkadia
10 Replies
8. Shell Programming and Scripting
Hi,
I am extracting the records of a table from oracle into a csv file using spool command in unix script. I retrieve the error message as
msgcnt 18512 vxfs: mesg 001: vx_nospace - /dev/vg02/lvol12 file system full (1 block extent)
How to resolve it ? (4 Replies)
Discussion started by: sabural
4 Replies
9. UNIX for Beginners Questions & Answers
Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email.
Here's what I already have.
#!/bin/ksh
######################################################################
# File Name : counts.sh
# Created : 2019/27/19... (1 Reply)
Discussion started by: clef
1 Replies
10. UNIX for Beginners Questions & Answers
Hello all,
I am trying to spool a SQL query output file from back-end to desktop in a certain path but it didn't work,the query writes the output in a file in the same directory at the back-end.
note : i use the same query in sql developper and file was created in the desired path fine
code... (1 Reply)
Discussion started by: bmaksoud
1 Replies
LEARN ABOUT PHP
mssql_field_name
MSSQL_FIELD_NAME(3) MSSQL_FIELD_NAME(3)
mssql_field_name - Get the name of a field
SYNOPSIS
string mssql_field_name (resource $result, [int $offset = -1])
DESCRIPTION
Returns the name of field no. $offset in $result.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $offset
- The field offset, starts at 0. If omitted, the current field is used.
RETURN VALUES
The name of the specified field index on success or FALSE on failure.
EXAMPLES
Example #1
mssql_field_name(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name], [email] FROM [php].[dbo].[userlist]');
echo 'Result set contains the following field(s):', PHP_EOL;
// Dump all field names in result
for ($i = 0; $i < mssql_num_fields($query); ++$i) {
echo ' - ' . mssql_field_name($query, $i), PHP_EOL;
}
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
Result set contains the following field(s):
- username
- name
- email
SEE ALSO
mssql_field_length(3), mssql_field_type(3).
PHP Documentation Group MSSQL_FIELD_NAME(3)