08-27-2009
Hi KenJackson,
You are almost there in getting my intent.
Purpose of the script:
The purpose of the script is… if the CubeType equals to the second entry of any line of the file CubeList_Europe.txt then the variables Server, CubeType, Application, OTL_Application, Database, OTLUnLockLog should be populated with the rest of entries of the same line.
The CubeList_Europe.txt contains the below information.
; ==================================================================================================== =
; :: File Name : CubeList_Europe.txt
; :: Purpose : This file lists all the Europe Cubes that need to be Outline refreshed.
; :: : The general syntax is 'Server, Cube Type, Application, Application, Cube'
; :: : where the first application is the Outline application, the 2nd app is the
; :: : refreshing app and the cube name applies to both apps.
; :: Creation :
; :: Modifications :
;=================================================================================================== ==
Egfrtsap1,DayGPO,OTLDGPO,Rajx,DayGPO
Egfrtsap1,DayLbl,OTLDLBL,Raj1x,DayLbl
**************************************************************************************
As per your inputs I have changed the script as below:
Script:
;******************************************************************
CubeType=DayGPO
CommonPath=/export/home/essbase/OTL_REFRESH
while IFS=, read a b c d e; do
if [ b = $CubeType ]; then
Server="$a"
CubeType="$b"
Application="$d"
OTL_Application="$c"
Database="$e"
break
fi
done < $CommonPath/CubeList_Europe.txt
OTLUnLockLog=$CommonPath/Logs/$OTL_Application_UnLock_Object.log
echo Server=$Server
echo CubeType=$CubeType
echo Application=$Application
echo OTL_Application=$OTL_Application
echo Database=$Database
echo OTLUnLockLog=$OTLUnLockLog
;***************************************************************
The script is running fine without any errors. But it’s not populating any values to the defined variables except for “$b”.
The current output is as below:
Server=
CubeType=DayGPO
Application=
OTL_Application=
Database=
OTLUnLockLog=/export/home/essbase/OTL_REFRESH/Logs/.log
Except CubeType no other variable got populated.
The Expected Output is:
Server=Egfrtsap1
CubeType=DayGPO
Application=Raj
OTL_Application=OTLDGPO
Database=DayGPO
OTLUnLockLog=/export/home/essbase/OTL_REFRESH/Logs/OTLDGPO_UnLock_Object.log
Please correct this script so that it servers its purpose. Thanks in advance.
Last edited by tomailraj; 08-27-2009 at 01:00 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am using awk in my .ksh script but when I am trying to run in windows
its not recognising awk part of the ksh script , even when I changed it to gawk it does not work, this is how my .ksh and .bat files look like.
thanx.
#!/bin/ksh
egrep -v "Rpt 038|PM$|Parameters:|Begin |Date: |End... (1 Reply)
Discussion started by: 2.5lt V8
1 Replies
2. Shell Programming and Scripting
Hi,
I m trying to connect/establish FTP from unix shell script to my PC.Below the script i have written
#!/bin/ksh
ftp -v -n ddcappip01.com << "EOF"
user Amit jason
bye
EOF
------------------------------ERROR--------------------------
but i m getting the below error for the... (4 Replies)
Discussion started by: ali560045
4 Replies
3. UNIX for Advanced & Expert Users
I need to execute a shell script kept in unix machine from windows. User id, password area available.
For eg.
There's a shell script wich moves all the logs kept in my home directory to a directory named LOGS.
Now i need to get this done through windows; either using a batch file, or java... (4 Replies)
Discussion started by: rajneesh_kapoor
4 Replies
4. Windows & DOS: Issues & Discussions
Good morning all. I have been running into a problem running a simple gawk script that selects every third line from an input file and writes it to an output file.
gawk "NR%3==0" FileIn > FileOut
I am attempting to run this command from a batch file at the command line. I have several hundred... (6 Replies)
Discussion started by: 10000springs
6 Replies
5. Shell Programming and Scripting
Hi,
Is it possible to ftp a huge zip file from windows to unix server using unix shell scripting?
If so what command i need to use.
thanks in advance. (1 Reply)
Discussion started by: Shri123
1 Replies
6. Shell Programming and Scripting
Can anyone help me with a dos batch script to execute a shell script residing in an unix server. I am not able to use ssh.
Thanks in advance (2 Replies)
Discussion started by: Shri123
2 Replies
7. Shell Programming and Scripting
I wish to create a folder on a unix server B from my windows box using windows batch script.
Below is my windows batch script.
@ ECHO OFF
::Enter your Directory name:
echo Enter your Directory name:
set /p mydir=
plink user1@ServerA
mkdir %mydir%
At plink command i get logged... (7 Replies)
Discussion started by: mohtashims
7 Replies
8. Shell Programming and Scripting
Hi all,
i need to run a shell script on remote server. I have created file .bat file in windows server with following code,
c:\Users\Desktop\putty.exe -ssh -pw password user@server ./script.sh
i need to run the script.sh in my remote server
Above command is not working, any... (4 Replies)
Discussion started by: rammm
4 Replies
9. Shell Programming and Scripting
Hi everyone,
I've below windows batch script which is used to filter the file contents line by line and assign the matched values to the variables in for loop.
for /F "tokens=1,3 delims=:" %%A in (%LOG_DIR%\PM_IS_workflow_status.log) do (
set "ATTR_NAME=%%A"
if /i "!ATTR_NAME!" EQU "Folder"... (1 Reply)
Discussion started by: Kathraji
1 Replies
10. Shell Programming and Scripting
Hi team,
My requirement is to transfer pdf files from windows machine to unix server and then from that unix server we should sftp to another server.
I have completed the first part i.e From windows to using to unix server with the help of psftp.exe
code:
psftp user@host -pw password <... (1 Reply)
Discussion started by: bhupeshchavan
1 Replies
SCRIPT(1) BSD General Commands Manual SCRIPT(1)
NAME
script -- make typescript of terminal session
SYNOPSIS
script [-a] [-c COMMAND] [-f] [-q] [-t] [file]
DESCRIPTION
Script makes a typescript of everything printed on your terminal. It is useful for students who need a hardcopy record of an interactive
session as proof of an assignment, as the typescript file can be printed out later with lpr(1).
If the argument file is given, script saves all dialogue in file. If no file name is given, the typescript is saved in the file typescript.
Options:
-a Append the output to file or typescript, retaining the prior contents.
-c COMMAND
Run the COMMAND rather than an interactive shell. This makes it easy for a script to capture the output of a program that behaves
differently when its stdout is not a tty.
-f Flush output after each write. This is nice for telecooperation: One person does `mkfifo foo; script -f foo' and another can super-
vise real-time what is being done using `cat foo'.
-q Be quiet.
-t Output timing data to standard error. This data contains two fields, separated by a space. The first field indicates how much time
elapsed since the previous output. The second field indicates how many characters were output this time. This information can be used
to replay typescripts with realistic typing and output delays.
The script ends when the forked shell exits (a control-D to exit the Bourne shell (sh(1)), and exit, logout or control-d (if ignoreeof is not
set) for the C-shell, csh(1)).
Certain interactive commands, such as vi(1), create garbage in the typescript file. Script works best with commands that do not manipulate
the screen, the results are meant to emulate a hardcopy terminal.
ENVIRONMENT
The following environment variable is utilized by script:
SHELL If the variable SHELL exists, the shell forked by script will be that shell. If SHELL is not set, the Bourne shell is assumed. (Most
shells set this variable automatically).
SEE ALSO
csh(1) (for the history mechanism), scriptreplay(1).
HISTORY
The script command appeared in 3.0BSD.
BUGS
Script places everything in the log file, including linefeeds and backspaces. This is not what the naive user expects.
AVAILABILITY
The script command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.
Linux July 30, 2000 Linux