Sponsored Content
Full Discussion: Spool issue in unix
Top Forums Shell Programming and Scripting Spool issue in unix Post 302678839 by i150371485 on Monday 30th of July 2012 01:28:57 AM
Old 07-30-2012
Error Spool issue in unix

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 :

Code:
1|BANG|KINR|3456
2|KIBNJ|UIE|6347
3|JEEM|Y34E|3874

data which is spooling in to the file :

Code:
 
1|BANG|KINR|3456.
2|KIBNJ|UIE.|6347
3.|JEEM|Y34E|3874

Please Help .. i tried trim option on the columns but no hope. Smilie

Last edited by Scott; 07-31-2012 at 05:59 AM.. Reason: Code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Spool Issue

Hi: At every month end I would like to collect the information of a spool. Every Spool has more then one job, below is the individual job information, I really want to collect into a text file. Sp-id Proc User Printer Id Pty Form Copy Total SP7494 MONTHEND SYED R123 P2 1 WIDE ... (3 Replies)
Discussion started by: shah2
3 Replies

2. Shell Programming and Scripting

code to FTP the spool file from Sqlplus to the unix server.

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

3. Shell Programming and Scripting

how to spool a unix file

hi, can anyone help me by saying how can i spool a unix file.. do we need to specify the pathname as such to spool the file .. right now, i tried giving like spool filename in the sql prompt.. but its not giving me the required output even if i can see that the command is being executed.. ... (2 Replies)
Discussion started by: kripssmart
2 Replies

4. UNIX for Dummies Questions & Answers

Spool command in Unix

Hi, Is there any command in unix similar to spool command in oracle. (6 Replies)
Discussion started by: manosubsulo
6 Replies

5. UNIX for Dummies Questions & Answers

Spool setting in unix environment for SAP

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

6. UNIX for Dummies Questions & Answers

Like spool in UNIX

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

7. Shell Programming and Scripting

UNIX/SQL loop to spool files!!

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

8. UNIX for Dummies Questions & Answers

Issue with SPOOL

Hi, I use SunOS and i connect to database via isql. When tried using SPOOL command to extract the report from database, system thrown me saying "Spoool command not found". Please advise. (3 Replies)
Discussion started by: kusathy
3 Replies

9. Solaris

/var/spool/mqueue issue

Hi guys . I have a solaris machine serving as a DNS server for my environment. Everytime I go into /var/spool/mqueue , there are an aweful lot of emails with names likes: qfqB6ChrpL006644. When I cat the file , I get the following output: H??Received: from machine.domain.com... (3 Replies)
Discussion started by: Junaid Subhani
3 Replies

10. Solaris

DNS server /var/spool issue

Hello all Currently I am working in a live production environment with 100+ Solaris servers . The environment has one DNS server and one SMTP server. The problem that I am facing since the past 2 months is that the /var/spool/mqueue on my DNS server keeps getting full i.e. mails with name... (1 Reply)
Discussion started by: Junaid Subhani
1 Replies
ISDNCONF(1)						      Linux System Utilities						       ISDNCONF(1)

NAME
isdnconf - manipulate or read ISDN phone number config files. SYNOPSIS
isdnconf DESCRIPTION
isdnconf can manipulate or read the file /etc/isdn/callerid.conf as well as ~/.isdn. Entries can be added or removed from these files. Additionally, entries can be searched for and displayed in a way similar to grep. An entry can be an own MSN ([MSN]) or a phone number ([NUMBER]). You can use this program to build your own phonebook. These files are used by many of the other ISDN utilities that use phone numbers, to display a number symbolicly instead of as a plain number. OPTIONS
Note: usage of the options -A and -D is dangerous! The complete structure of the file may be changed, and all comments are removed! Make backups of your data files before trying these. COMMAND OPTIONS: -A Add a new entry, which is read from standard input. The following values are asked for (here with examples): Alias: Fred Number: 0815/441777 SI: 0 Zone: 4 Interface: - Flags: I|O Program: /usr/local/bin/ring User: uucp Group: user Interval: Time: 8-20 Flags: (control-D here indicates end of flags) Alias: (control-D here indicated end of entries) If you want another [Flags] entry, simply enter the data for another program for this number at the point where the control-D was given above. If you want to add another number, simply enter the data for the next number at the Alias prompt. You can also pipe the data into this program; the input data then must correspond to the prompts that the program gives! Note that you can only add one number at a time then (there's no way of telling isdnconf that you want to stop giving Flags info and start giving the next Alias info). -D Delete one or more entries which match the data options given. How to supply the data to match is discussed below (see DATA OPTIONS). -V version: display the program's version and terminate. If both -A and -D are given together, isdnconf will terminate, as this is not a valid combination. If neither -A nor -D is given, then isdnconf will display entries which match the data given. DATA OPTIONS: (none applicable for -A) -n 'number' number: match the given number. It can contain wildcards. -a 'alias' alias: match the given alias name. The name can contain wildcards. Note: due to a bug, use '?' instead of '-'. -t 'SI' SI: match the given service indicator. -c 'code' code: match the area code of the phone number. Only usable for displaying (not for -A nor -D). -i ignore case for the -n and -a options. -w word: the parameters for -n and -a must match the whole value, not just a substring. Examples (here for -n): "*34*" matches 123456, 345677, 1234 "34*" matches 34567, 34111 but not 1234 "34??" matches 3411, 3456 "34" matches only 34 Without the -w option, these would match: "*34*" matches 123456, 345677, 1234 "34*" matches 123456, 345677, 1234, 34567, 34111 "34??" matches 123456, 345677, 1234, 3411, 3456 "34" matches 123456, 345677, 1234, 3411, 3456, 34567 -d and: by default the values given to options -n, -a and -t will be combined with a logical OR. If these should be combined with a logi- cal AND (which is probably what most people expect!) you must use this -d option. In this case you can only supply each of the -n, -a and -t options exactly once. OTHER OPTIONS: -q quiet: when using the -A or -D commands, the output is suppressed. When not using the -A or -D commands, only the alias of the match- ing number is shown, or just the number in case the alias is not found. -m MSN: when used in combination with the -A command, instructs isdnconf to create a new MSN entry; the default is to create a new NUMBER entry. Only the values alias, number, SI, zone and interface are applicable to an MSN entry. The following two options do not apply to the -A and -D commands. They only change the output format. -s short: only display the alias and the number. -l long: also display the programs to run ([START]). -f 'filename' file: usually isdnconf uses the /etc/isdn/callerid.conf and the ~/.isdn files. If isdnconf should be applied to another file, use this option. -g global: only applies to the -A and -D commands. Instead of editing ~/.isdn, /etc/isdn/callerid.conf is edited. -1 first: only delete or display the first entry. -M isdnmon: used internally by isdnmon to get alias info. AUTHOR
Andreas Kool <akool@isdn4linux.de> manpage adapted from the README by Paul Slootman <paul@isdn4linux.de> SEE ALSO
callerid.conf(5), isdnlog(8) isdn4k-utils-3.13 1998/12/29 ISDNCONF(1)
All times are GMT -4. The time now is 09:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy