Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Fetching from file and printing

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Fetching from file and printing
# 1  
Old 05-18-2012
Fetching from file and printing
Hi,

i am using below command in shell scripting and getting the output.

Code:
echo "dis qc(*) CLUSTER($clus) clusqmgr"|runmqsc -e XX.QM.CNEDCT1|egrep 'QUEUE|CLUSQMGR'|sed '$!N;s/\n/,/'|grep -v XX.QM.CNEDCT1

here i think i need to put the output in a file and fetch for every CLUSQMGR.
Output coming as
Code:
   QUEUE(XX.CL.GTCOSMT2.SLOTTER.MSA_GTC_TO_ENC.01),   CLUSQMGR(XX.QM.SLOTHT1)
   QUEUE(XX.CL.GTCOSMT2.SLOTTER.MSA_GTC_TO_ENC.01),   CLUSQMGR(XX.QM.OTTERT1)
   QUEUE(ACF),    CLUSQMGR(XX.QM.STAN)
   QUEUE(UNC),    CLUSQMGR(XX.QM.MAWN)
   QUEUE(BCM),    CLUSQMGR(XX.QM.ROWN)
   QUEUE(RVG),    CLUSQMGR(XX.QM.ROWN)
   QUEUE(HUN),    CLUSQMGR(XX.QM.STAN)

but i want for every CLUSQMGR it should print all related queues. Expecing output as

Code:
Queues of XX.QM.SLOTHT1

   QUEUE(XX.CL.GTCOSMT2.SLOTTER.MSA_GTC_TO_ENC.01),   CLUSQMGR(XX.QM.SLOTHT1)
Queues of XX.QM.OTTERT1
   QUEUE(XX.CL.GTCOSMT2.SLOTTER.MSA_GTC_TO_ENC.01),   CLUSQMGR(XX.QM.OTTERT1)
Queues of XX.QM.STAN
QUEUE(ACF),    CLUSQMGR(XX.QM.STAN)
QUEUE(HUN),    CLUSQMGR(XX.QM.STAN)

Queues of XX.QM.MAWN

   QUEUE(UNC),    CLUSQMGR(XX.QM.MAWN)
Queues of XX.QM.ROWN
   QUEUE(BCM),    CLUSQMGR(XX.QM.ROWN)
   QUEUE(RVG),    CLUSQMGR(XX.QM.ROWN)

---------- Post updated at 07:14 AM ---------- Previous update was at 05:41 AM ----------

I tried and got the output with below one
Code:
echo "dis qc(*) clusqmgr"|runmqsc -e $QMGR|egrep 'QUEUE|CLUSQMGR'| sed 's/QUEUE/+QUEUE/'|tr -d "\n"|tr '+' '\n'|tr -d ' '| sed 's/CLUSQMGR/,CLUSQMGR/g'| grep -v BT.QM.CNEDCT1|sort -f -u| sed -e 's/QUEUE(//g' \
                 -e 's/)//g' \
                 -e 's/CLUSQMGR(//g'\
                 -e '/^$/d'>clusqs.out


cut clusqs.out|cut -d ',' -f2|sort -f -u| while read line
do
echoh $line
grep $line clusqs.out
done

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Fetching data from file

Hi All, I'm facing issue while using script. Chk_Etl_Status=`cat /dstage/questnet/qnetdv/input/Etl_Status.dat|cut -d"," -f1` echo Chk_Etl_Status=$Chk_Etl_Status above result is giving me sometime value as 1 and sometime error message as Chk_Etl_Status= dsjoblaunch.sh: test: Specify a... (5 Replies)
Discussion started by: Amit786
5 Replies

2. Shell Programming and Scripting

Fetching variable from config file

I am using . .profile in my script below I want to fech it it from my configuration file .id_pass_file.txt(it has all user_name and passwords) how can i do this PROFILE_PATH=. .profile AND IN MY SCRIPT $PROFILE_PATH IS THIS CORRECT #!/bin/sh ORACLE_HOME=/var/opt/oracle/product/10g;... (8 Replies)
Discussion started by: rafa_fed2
8 Replies

3. Shell Programming and Scripting

File fetching from mysql database

I have a configuration file namely: abcd, that will be use for some service (like gammu) Inside that configuration file: number1 = 66673527 number1 = 8373272 How can I make the file to search the number1 and number2 from a mysql database? Any help will be very appreciated. Thanks (1 Reply)
Discussion started by: jazzyzha
1 Replies

4. Shell Programming and Scripting

help in fetching a field from a file

I have an input file with contents like : '1LTYSJSD2KQ8KLE' -audit_grp_id , internal error qty < recycle qty requested, skipping record '1LTYSJSD2KQ8KLE' -audit_group_id, 0 records has been written, 1 was skipped '1LTZLJRDFBEWJX9' -audit_grp_id , internal error qty < recycle qty requested,... (3 Replies)
Discussion started by: rkrish
3 Replies

5. UNIX for Dummies Questions & Answers

Need help in not fetching a file while file writing operation is not completed

Hi All, We have a Unix program in oracle when we run the program this connects to specified ftp and will get the file into local server. We are facing a problem like when file writing operations is not completed, this program is getting the incomplete file. Could anyone please help me... (2 Replies)
Discussion started by: world.apps
2 Replies

6. UNIX for Advanced & Expert Users

Fetching file name from directory

Hi Friends, I have to write a script to find the file name in the directory. file name in the directory is like sourcefile_abc_001.txt sourcefile_abc_002.txt sourcefile_abc_003.txt. valuename in the file i.e. between '_' and .txt i.e. 001 or 002 or 003 will be in another file and I... (1 Reply)
Discussion started by: manish8484
1 Replies

7. Shell Programming and Scripting

Fetching data from .csv file

Hi Experts, I have created a table with columns as empname,empid,phone,shiftname. Now I am having a .csv file format which contains the shift datas of the employees. I have to fetch this file and compare with the table I created to send an alert to the specified user. (2 Replies)
Discussion started by: micky3112
2 Replies

8. UNIX Desktop Questions & Answers

Fetching unique values from file

After giving grep -A4 "feature 1," <file name> I have extracted the following text feature 1, subfeat 2, type 1, subtype 5, dump '30352f30312f323030392031313a33303a3337'H -- "05/01/2009 11:30:37" -- -- ... (1 Reply)
Discussion started by: shivi707
1 Replies

9. Shell Programming and Scripting

Logic for file fetching based on date

Dear friends, I receive the following files into a FTP location on a daily basis -rw-r----- 1 guest ftp1 5021 Aug 19 09:03 CHECK_TEST_Extracts_20080818210000.zip -rw-r----- 1 guest ftp1 2437 Aug 20 05:15 CHECK_TEST_Extracts_20080819210000.zip -rw-r----- 1 guest ... (2 Replies)
Discussion started by: sureshg_sampat
2 Replies

10. UNIX for Advanced & Expert Users

Fetching file from windows server

hi i am having 2 servers.... one having windows & the other one is having Solaris on it. Now i need to fetch files from windows server and copy them on to solaris server. the problem is that a new folder is created after every one hour in the window server and i have to fetch 2 files from this... (5 Replies)
Discussion started by: rochitsharma
5 Replies
Login or Register to Ask a Question