06-18-2008
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id.
My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
Discussion started by: vprevin
0 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Is there any command in unix similar to spool command in oracle. (6 Replies)
Discussion started by: manosubsulo
6 Replies
3. UNIX for Dummies Questions & Answers
HI
Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.
Getting error: SP2 0308: cannot close spool file.
Any thoughts?
sqlplus -s user/pwd << EOF
set term off
set head off
set trims on
set pages 0
set... (1 Reply)
Discussion started by: Leo_NN
1 Replies
4. Shell Programming and Scripting
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
hi all,
am trying to write a ksh script which will take a username, password, db instance as input arguments and login to the database using sqlplus and select some data via sql and spool to a file.
problem is that i am using "sqlplus -s" in order to hide the username/password and it doesnt... (8 Replies)
Discussion started by: cesarNZ
8 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
Please help me regarding this.
we have our SAP system with unix environment.
Spool setting in unix ,we are not able to cancel any unix spool from SIDADM because the spool user is nor SIDADM. for example :-
Any idea how to make the spool from OS level as SIDADM, Please suggest.... (3 Replies)
Discussion started by: dravi_laxmi
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
Can you please help me how to spool the unix commands executed in my client and its output to a file in local machine.
Basically, I want to save all OS commands executed in my session and its output into a file from my client something like we do oracle with "SPOOL".
Thanks in advance.... (2 Replies)
Discussion started by: pointers
2 Replies
8. Shell Programming and Scripting
I want to spool files from unix using a sql script that would
take values from another sql query within the KSH script..
unix loop
select order_date from date_tbl
for each order_Date i need to call this spool script with the value
sqlplus scott/tiger@order_db @/ordspool/order_date.sql... (2 Replies)
Discussion started by: vr23
2 Replies
9. Shell Programming and Scripting
Hi Friends,
I am trying to spool the data from Teradata. The rpoblem which i am facing is , the coulmn data is appended with ".(dot)" for some coulmns. Please find the below data :
data i want in file :
1|BANG|KINR|3456
2|KIBNJ|UIE|6347
3|JEEM|Y34E|3874
data which is spooling... (6 Replies)
Discussion started by: i150371485
6 Replies
10. UNIX and Linux Applications
Hello All,
I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.
I'm setting below options :
SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
LEARN ABOUT REDHAT
uri::url
URI::URL(3) User Contributed Perl Documentation URI::URL(3)
NAME
URI::URL - Uniform Resource Locators
SYNOPSIS
$u1 = URI::URL->new($str, $base);
$u2 = $u1->abs;
DESCRIPTION
This module is provided for backwards compatibility with modules that depend on the interface provided by the "URI::URL" class that used to
be distributed with the libwww-perl library.
The following differences compared to the "URI" class interface exist:
o The URI::URL module exports the url() function as an alternate constructor interface.
o The constructor takes an optional $base argument. The "URI::URL" class is a subclasses of "URI::WithBase".
o The URI::URL->newlocal class method is the same as URI::file->new_abs
o URI::URL::strict(1)
o $url->print_on method
o $url->crack method
o $url->full_path; same as ($uri->abs_path || "/")
o $url->netloc; same as $uri->authority
o $url->epath, $url->equery; same as $uri->path, $uri->query
o $url->path and $url->query pass unescaped strings.
o $url->path_components; same as $uri->path_segments (if you don't consider path segment parameters).
o $url->params and $url->eparams methods.
o $url->base method. See URI::WithBase.
o $url->abs and $url->rel have an optional $base argument. See URI::WithBase.
o $url->frag; same as $uri->fragment
o $url->keywords; same as $uri->query_keywords;
o $url->localpath with friends map to $uri->file
o $url->address and $url->encoded822addr; same as $uri->to for mailto URI.
o $url->groupart method for news URI.
o $url->article; same as $uri->message
SEE ALSO
URI, URI::WithBase
COPYRIGHT
Copyright 1998-2000 Gisle Aas.
perl v5.8.0 2002-05-09 URI::URL(3)