Change the Windows Batch script to UNIX shell script. Post: 302348137

Sponsored Content

Top Forums Shell Programming and Scripting Change the Windows Batch script to UNIX shell script. Post 302348137 by tomailraj on Thursday 27th of August 2009 11:44:38 AM

08-27-2009

Registered User

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..

tomailraj

View Public Profile for tomailraj

Find all posts by tomailraj

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert unix .ksh script to windows .batch script

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...

2. Shell Programming and Scripting

FTP from unix shell script to windows

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...

3. UNIX for Advanced & Expert Users

Executing a shell script from windows;script present in unix

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. Windows & DOS: Issues & Discussions

Gawk Script in Windows batch file - Help

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...

5. Shell Programming and Scripting

FTP from windows to unix server using unix shell script

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.

6. Shell Programming and Scripting

Dos batch script to execute unix shell script

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

7. Shell Programming and Scripting

Windows Batch script for Unix commands

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...

8. Shell Programming and Scripting

To run a shell script in remote server from windows batch file

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...

9. Shell Programming and Scripting

Windows batch script to Shell script

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"...

10. Shell Programming and Scripting

Batch script to execute shell script in UNIX server

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 <...

LEARN ABOUT SUNOS

asmigrate

asmigrate(1m)						    Application Server Utility						     asmigrate(1m)

NAME

       asmigrate - automates migration of J2EE applications from other J2EE platforms to Sun Java System Application Server

SYNOPSIS

       asmigrate  [-h  |  --help]  [-v	|  --version]  [(-c  |--commandline)  |  (-u  --ui) ] [-q | --quiet] [-d | --debug][-s | --sourcedirectory
       source_directory] [-S | --sourceserver source_application_server] [-t |	--targetdirectory  target_directory]  [-T  |  --targetserver  tar-
       get_application_server]	[-n  |	--scan-native-apis-only  ]  [-p  | --scan-packages package_list] [-j | --java2db create-tables=true, drop-
       tables=true, db-vendor-name=dbVendorName]  [-m  |  --migrate-cmp  comment-pk-modifiers=true,  overwrite-conflicting-accessors=true]  [-f  |
       --file-filter  all-files=true,  html-files=true,  java-files=true,  jsp-files=true, xml-files=true, archive-files=true] [-a | --append-logs
       ][operands]

       Use the asmigrate utility to analyze your J2EE application and translate vendor specific settings to Sun JavaTMTM System Application Server
       specific settings making the application deployable on Sun's J2EE products.

       The following table identifies the supported J2EE product migrations:

       +--------------------------+--------------------------------+
       |  Source J2EE Platform	  |   Destination J2EE Platform    |
       +--------------------------+--------------------------------+
       |WebSphere    Application  |Sun ONE Application Server 6.5  |
       |Server 4.0		  |				   |
       |			  |				   |
       |WebLogic     Application  |				   |
       |Server 5.1		  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |Sun ONE Application Server 7    |
       |Server 5.1, 6.0, 6.1	  |				   |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavaTMTM    2	Platform  |				   |
       |Enterprise Edition 1.3	  |				   |
       |			  |				   |
       |Sun   ONE    Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |JavaTMTM 2 Platform, Enterprise |
       |Server 5.1, 6.0, 6.1	  |Edition 1.4 Application Server  |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavaTMTM   2	Platform  |				   |
       |Enterprise	 Edition  |				   |
       |1.3/1.4 		  |				   |
       |			  |				   |
       |Sun   ONE    Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+
       |WebLogic     Application  |Sun JavaTMTM System Application |
       |Server 5.1, 6.0, 6.1	  |Server Platform Edition 8	   |
       |			  |				   |
       |WebSphere    Application  |				   |
       |Server 4.0		  |				   |
       |			  |				   |
       |JavTMTMa    2	Platform  |				   |
       |Enterprise	 Edition  |				   |
       |1.3/1.4 		  |				   |
       |			  |				   |
       |Sun    ONE   Application  |				   |
       |Server 6.x		  |				   |
       |			  |				   |
       |Sun ONE Web Server 6.0	  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.0			  |				   |
       |			  |				   |
       |JBoss Application Server  |				   |
       |3.2			  |				   |
       |			  |				   |
       |Tomcat Web Server 4.1.12  |				   |
       +--------------------------+--------------------------------+

OPTIONS

       -h --help		displays the arguments for launching the MigrationTool.

       -v --version		displays the version of the MigrationTool.

       -u --ui			invokes the tool in user interface mode.

       -c --commandline 	invokes the tool in command-line mode.

       -q --quiet		launches the tool in quiet mode.

       -d --debug		launches the tool in debug mode.

       -s --sourcedirectory	identifes the directory where the source code to migrate or scan is present.

       -S --sourceserver	identifes the source application server of the applications to be migrated. Possible servers include:

				 o  wl51: WebLogic Application Server 5.1

				 o  wl60: WebLogic Application Server 6.0

				 o  wl61: WebLogic Application Server 6.1

				 o  as65: Sun ONE Application Server 6.5

				 o  as70: Sun ONE Application Server 7.0

				 o  ws40: WebSphere Application Server 4.0

				 o  ri13: JavaTMTM 2 Platform Enterprise Edition 1.3

				 o  ri14: JavaTMTM 2 Platform Enterprise Edition 1.3

				 o  s1ws: Sun ONE Web Server

				 o  jb30: JBoss Application Server 3.0

				 o  tc41: Tomcat Application Server 4.1

       -t --targetdirectory	target or output directory where the migrated application should be placed.

       -T --targetserver	target application server to which the application is to be migrated.

       -n --scan-native-apis-onlscans the source code only for the presence of application server specific proprietary APIs.

       -p --scan-packages	comma-separated list of Java packages to scan.

       -j --java2db		bypasses  the  creation of the sun-cmp-mapping.xml file. Instead, introduces the option argument into the sun-ejb-
			       jar.xml file. Option arguments are:

				 o  create-tables: if set to true (default), creates tables at deploy. If set to false tables are not created.

				 o  drop-tables: if set to true (default), tables are dropped at undeploy. If set to false tables are not dropped.

				 o  db-vendor-name: name of the database vendor for  the  application  to  be  migrated.  Supported  vendor  names
				    include: Oracle, Sybase, DB2, Generic SQL92, PointBase, MSSQL.

       -m --migrate-cmp 	migrates 1.1 compliant CMPs, if any, to 2.0. Option arguments are:

				 o  overwrite-conflicting-accessors:  if  set  to true (default), conflicting accessors are overwritten. If set to
				    false, conflicting accessors are not overwritten.

				 o  comment-pk-modifiers: if set to true (default), setters of primary key are commented. If set to false, setters
				    of primary key are not commented.

       -f --file-filter 	selects the type of files to migrate. Option arguments are:

				 o  all-files: if specified and set to true (default), migrates all types of files.

				 o  html-files: if specified and set to true (default), migrates HTML files.

				 o  java-files: if specified and set to true (default), migrates Java files.

				 o  jsp-files: if specified and set to true (default), migrates JSP type files.

				 o  archive-files: if specified and set to true (default), migrates jar/ear/war/rar file types.

       -a --append-logs 	if  specified,	appends  the  logging to the existing or previous logs without overwriting them. If not specified,
			       previous logs are overwritten.

       operands 		identifes the archive file (jar/ear/war/rar) to be migrated.

SEE ALSO

       asupgrade(1M)

J2EE 1.4 SDK							    March 2004							     asmigrate(1m)