05-22-2006
Unix shell scripting
Hi,
we are writing this fields dynamically retrieved from database and writing
into the file.
$bmpRec = $bmpRec.'|'.$cust_id; # sp4
$bmpRec = $bmpRec.'|'.$serv_id; # sp5
$bmpRec = $bmpRec.'|'.$site_id; # sp6
$bmpRec = $bmpRec.'|'.$loc_id; # sp7
$bmpRec = $bmpRec.'|'.substr($si_room, 0, 25); # sp8
$bmpRec = $bmpRec.'|'.substr($floor, 0, 9); # sp9
$bmpRec = $bmpRec.'|'.substr($sof_id, 0, 20); # sp10
$bmpRec = $bmpRec.'|'.substr($cc_case_num, 0, 10); # sp11
$bmpRec = $bmpRec.'|'.substr($cc_part_num, 0, 30); # sp12
$bmpRec = $bmpRec.'|'. ""; # sp13, (cc_site_id) 01d removed from db
$bmpRec = $bmpRec.'|'.substr($acc_type, 0, 20); # sp14
$bmpRec = $bmpRec.'|'.$speed_value; # sp15
$bmpRec = $bmpRec.'|'.substr($link_protocol, 0, 10); # sp16
$bmpRec = $bmpRec.'|'.$site_glbl_dlci; # sp17
$bmpRec = $bmpRec.'|'.$intnl_gw_popid; # sp18
$bmpRec = $bmpRec.'|'.substr($fr_encapsulation, 0, 10); # sp19
$bmpRec = $bmpRec.'|'.substr($csu_dsu, 0, 25); # sp20
$bmpRec = $bmpRec.'|'. ""; # sp21 (lpw)
Finally we are printing the $bmpRec to a file
printf OUT "$bmpRec|\n"
When we are printing this variable into the file it has printed upto
I # sp9 and also it has not printed the final new line character (\n)
after this a shell script will append a trailer record (TRLR|727)with
the total number of records in the file.
Because the last record was half printed we are getting the trailer
record on the same line (appended to the last record) as follows
USP|200605|2212404|5314|15|880863|661897|CABL PLNT|1||TRLR|727|
Last edited by Maruthi Kunnuru; 05-23-2006 at 07:12 AM..
Reason: To give clear view of the problem
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I need to write a script which analyses an invoice file, counting the amount of pages in the file to be printed per account number and per invoice. The account numbers are stored in another file which has instructions on what do with ach customers invoice as per their account number.
please... (6 Replies)
Discussion started by: la_burton
6 Replies
2. Shell Programming and Scripting
please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies
3. Shell Programming and Scripting
Hi All,
Greetings!!
I am trying to write a script that will get me the syslog.log file output of last week...
That is ...my cron will run on Monday and will get me the syslog output of previous week , last monday-last sunday.
I tried using date formatting and tail..but did not succeed.... (4 Replies)
Discussion started by: premamadhuri
4 Replies
4. UNIX for Advanced & Expert Users
Hi Friends,
1. Bash Shell Scrpt to take backup at evening
2. I need a bash shell script for killing all processes. (5 Replies)
Discussion started by: vinayraj
5 Replies
5. Shell Programming and Scripting
I 'm new to unix shell scripting can some one guide me to any e-book or link from where i can learn unix shell scripting .. i want to learn create interactive scripts for my day to day solaris work. Any help would be appreciated (1 Reply)
Discussion started by: fugitive
1 Replies
6. UNIX for Dummies Questions & Answers
Hello Experts,
I have the following questions to be discussed here at this esteemed discussion forum.
I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies
7. UNIX for Dummies Questions & Answers
I'm sorry if this doesn't go here, but I'm in depserate need of help with my last unix homework.
Anyways, I'm taking summer classes, and one of them is UNIX. I've understood everything thus far, but I'm having a killer time with how my instructor has worded the problems for shell scripting. I... (3 Replies)
Discussion started by: dw15
3 Replies
8. Shell Programming and Scripting
I am new to Unix..
Can someone please help me to understand the concept of Login shell and non login shell ?
what exactly the difference between them :confused: (1 Reply)
Discussion started by: lokita jain
1 Replies
9. Programming
Hi All,
need help to complete the automation but stuck at a perticular situation
below is the code
<code>
fixed_function_name
{
code....
code....
variable_map=
{
a="/a"
b="/b"
c="/c"
so on...
} (7 Replies)
Discussion started by: yadavricky
7 Replies
10. UNIX for Beginners Questions & Answers
Describe in short the word completion feature of the tcsh
Completion works anywhere in the command line, not at just the end, for both commands and filenames. Type part of a word and hit the Tab key, and the shell replaces the incomplete word with the complete one in the input buffer. The... (1 Reply)
Discussion started by: Elena Lauren
1 Replies
LEARN ABOUT FREEBSD
mailq
MAILQ(1) General Commands Manual MAILQ(1)
NAME
mailq - print the mail queue
SYNOPSIS
mailq [-Ac] [-q...] [-v]
DESCRIPTION
Mailq prints a summary of the mail messages queued for future delivery.
The first line printed for each message shows the internal identifier used on this host for the message with a possible status character,
the size of the message in bytes, the date and time the message was accepted into the queue, and the envelope sender of the message. The
second line shows the error message that caused this message to be retained in the queue; it will not be present if the message is being
processed for the first time. The status characters are either * to indicate the job is being processed; X to indicate that the load is
too high to process the job; and - to indicate that the job is too young to process. The following lines show message recipients, one per
line.
Mailq is identical to ``sendmail -bp''.
The relevant options are as follows:
-Ac Show the mail submission queue specified in /etc/mail/submit.cf instead of the MTA queue specified in /etc/mail/sendmail.cf.
-qL Show the "lost" items in the mail queue instead of the normal queue items.
-qQ Show the quarantined items in the mail queue instead of the normal queue items.
-q[!]I substr
Limit processed jobs to those containing substr as a substring of the queue id or not when ! is specified.
-q[!]Q substr
Limit processed jobs to quarantined jobs containing substr as a substring of the quarantine reason or not when ! is specified.
-q[!]R substr
Limit processed jobs to those containing substr as a substring of one of the recipients or not when ! is specified.
-q[!]S substr
Limit processed jobs to those containing substr as a substring of the sender or not when ! is specified.
-v Print verbose information. This adds the priority of the message and a single character indicator (``+'' or blank) indicating
whether a warning message has been sent on the first line of the message. Additionally, extra lines may be intermixed with the
recipients indicating the ``controlling user'' information; this shows who will own any programs that are executed on behalf of this
message and the name of the alias this command expanded from, if any. Moreover, status messages for each recipient are printed if
available.
Several sendmail.cf options influence the behavior of the mailq utility: The number of items printed per queue group is restricted by
MaxQueueRunSize if that value is set. The status character * is not printed for some values of QueueSortOrder, e.g., filename, random,
modification, and none, unless a -q option is used to limit the processed jobs.
The mailq utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
sendmail(8)
HISTORY
The mailq command appeared in 4.0BSD.
$Date: 2013-11-22 20:51:55 $ MAILQ(1)