trackingnum in the position 1-6 6 bytes
trackingnumsuffix in the position 8-9 2 bytes
effdate in the position 11-20
tstmpupdated in the position 22-57 26 bytes
I dont know how to use substring.
Basically I need to extract the trackingnum, trackingnumsuffix and tstmpupdated and pass those values to a query. If it is present in that table, then I need to store the output of query to a file.
I have tried by writing the shell script as follows.
Code:
====================
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export mondir=/home/bmwdev1/script/krishna/arc
export monlog=$mondir/rcbl2_`date +%Y%m%d`.log
# connect to DB
db2 connect to r2pdev user bmwdevup using summer08
while read line
do
trackingnum=`expr substr $line 1 6`
trackingnumsuffix=`expr substr $line 8 9`
tstmpupdated=`expr substr $line 22 57`
#db2 "SELECT * FROM ZB_RCBL_ERROR_MSG_MIG WHERE TRACKING_NUM = $TRACKING_NUM AND TRACKING_NUM_SUFFIX = $TRACKING_NUM_SUFFIX AND TIMESTAMP_UPDATED = $TIMESTAMP_UPDATED WITH UR" >> new.log
done < "$monlog"
# disconnect from DB2
db2 terminate
exit 0
====================
The above shell script is not working. It throws error message.
Can anyone help me to fix this issue.
Krishnakanth
====================
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export mondir=/home/bmwdev1/script/krishna/arc
export monlog=$mondir/rcbl2_`date +%Y%m%d`.log
# connect to DB
db2 connect to r2pdev user bmwdevup using summer08
while read line
do
trackingnum=`expr substr $line 1 6`
Code:
trackingnum=`expr substr "$line" 1 6`
Quote:
Code:
trackingnumsuffix=`expr substr $line 8 9`
tstmpupdated=`expr substr $line 22 57`
#db2 "SELECT * FROM ZB_RCBL_ERROR_MSG_MIG WHERE TRACKING_NUM = $TRACKING_NUM AND TRACKING_NUM_SUFFIX = $TRACKING_NUM_SUFFIX AND TIMESTAMP_UPDATED = $TIMESTAMP_UPDATED WITH UR" >> new.log
done < "$monlog"
# disconnect from DB2
db2 terminate
exit 0
====================
The above shell script is not working. It throws error message.
What is the error messsage?
Do you still get it after enclosing $line in quotes?
For sample I have given 3 records. But in production there will be n number of records.
So I am reading line by line in a loop.
The first field trackingnum will be in the position 1-6
The field trackingnumsuffix will be in the position 8-9
the tstmpupdated will be in the position 22-57
Code:
while read line
do
trackingnum=`expr substr $line 1 6`
trackingnumsuffix=`expr substr $line 8 9`
tstmpupdated=`expr substr $line 22 57`
db2 "SELECT * FROM ZB_RCBL_ERROR_MSG_MIG WHERE TRACKING_NUM = $TRACKING_NUM AND TRACKING_NUM_SUFFIX = $TRACKING_NUM_SUFFIX AND TIMESTAMP_UPDATED = $TIMESTAMP_UPDATED WITH UR" >> new.log
done < "rcbl2_`date +%Y%m%d`.log"
try to echo $line inside while loop and check whether you are getting the required line..
and you have to use double quotes if $line has space
because i am getting no errors
Hi all,
Please, i'd like to extract string just before '.fr'.
Here is some lines of my file:
g-82.text.text1.fr.worker1
g-xx.yyyyyy.zzzz.fr.worker2
i'd like to extract this text:
g-82.text.text1
g-xx.yyyyyy.zzzz
Please, which command i have to use in my script shell ?
... (16 Replies)
I want to check if the string has the substring in IF condition then process...
i tried below but not working
if ];
then
.............
field can be "reserved1" ....reservedn / fillspaces1 ... fillspacesn (4 Replies)
Hi all,
I am new to scripting.
I have a file with colon separated values called mylist.txt
cat mylist.txt
192.123.76.89:lmprod89
162.122.20.28:lmtstserver28
10.80.32.139:hewprod139
.
.
using our internal os utility (called mvsping) we need to check all these servers if they are... (6 Replies)
hi all,
i need an urgent help for writing a shell script which will extract out and print a substring which is the shortest substring from the given string where first and last character of that substring will be given by the user.
for e.g.
if str="abcdpqracdpqaserd"
now if the user gives 'a'... (18 Replies)
I need a help in getting substring of each line in input file.
I am writing a script that will read a file from a directory on daily basis, I mean everyday a new file will be stored in this directory, it will replace old file. I have to read contents of this file, the contents will be as... (5 Replies)
please give me proper solution for finding a shortest substring from given string if string itself and first char and last char of that substr are also given by user
if S="dpoaoqooroo" and FC="o" and LC="o",then shortest substr is "oo" and rest of the string is "dpoaoqroo"
i have code but it is... (1 Reply)
Hi
I'm new to Shell scripting. Someone please help me in extracting a portion of string from a file.
Eg:
I got a file like, Readme.txt and has the following name value pairs
input1 : /homes/input1/
input2 : /homes/input2/
...
...
When I give the parameter input1, the value... (3 Replies)
Hi All,
Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box:
/home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH&
/opt/tools/ds/Template/&PH&
/data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH&
/data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (5 Replies)
Hi All,
Following is the output of a find commnd to locate log directories for various projects of UNIX AIX box:
/home/hbinz6pf/projectlibs/dpr_pfsdw_dev/&PH&
/opt/tools/ds/Template/&PH&
/data/ds/ms/hmsdw/projectlibs/dpr_ms_dev/&PH&
/data/ds/riskmi/projectlibs/dpr_riskmi_dev/&PH&... (1 Reply)
i am a new user of C-shell script.
I want to know can i create a substring in a string.
That means when i got a variable $input = "it is number 2"
I want to get the "2" to be another variable.
Can i do that in C-shell and how to ?
Thank you so much
dinodash (0 Replies)