08-23-2009
Change the Windows Batch script to UNIX shell script.
Hi,
When I run the below script in UNIX it's throwing syntax errors. Actually it's a windows batch script. Could anyone change the below Windows Batch script to UNIX shell script...
Script:
REM :: File Name : Refresh_OTL.bat
REM :: Parameters : %1 - Region
REM :: : %2 - Cube Type
REM :: :
REM :: Notes :
REM ============================== set ENVIRONMENT VARIABLES ==========================================
set Region=%1
set CubeType=%2
set CommonPath=\export\home\essbase\OTL_REFRESH
FOR /f "eol=; tokens=1,2,3,4,5 delims=, " %%a IN (%CommonPath%\CubeList_%Region%.txt) DO (
if /i %%b EQU %CubeType% (
SET Server=%%a
SET CubeType=%%b
SET Application=%%d
SET _Application=%%c
SET Database=%%e
))
set OTLUnLockLog=%CommonPath%\Logs\%OTL_Application%_UnLock_Object.log
REM ==================================================================================================== =
essmsh Unlock_Objects.bat %Server% %OTL_Application% %Application% %Database% %OTLUnLockLog%
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
LEARN ABOUT CENTOS
set_session_authorization
SET SESSION
AUTHORIZATION(7) PostgreSQL 9.2.7 Documentation SET SESSION AUTHORIZATION(7)
NAME
SET_SESSION_AUTHORIZATION - set the session user identifier and the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
DESCRIPTION
This command sets the session user identifier and the current user identifier of the current SQL session to be user_name. The user name can
be written as either an identifier or a string literal. Using this command, it is possible, for example, to temporarily become an
unprivileged user and later switch back to being a superuser.
The session user identifier is initially set to be the (possibly authenticated) user name provided by the client. The current user
identifier is normally equal to the session user identifier, but might change temporarily in the context of SECURITY DEFINER functions and
similar mechanisms; it can also be changed by SET ROLE (SET_ROLE(7)). The current user identifier is relevant for permission checking.
The session user identifier can be changed only if the initial session user (the authenticated user) had the superuser privilege.
Otherwise, the command is accepted only if it specifies the authenticated user name.
The SESSION and LOCAL modifiers act the same as for the regular SET(7) command.
The DEFAULT and RESET forms reset the session and current user identifiers to be the originally authenticated user name. These forms can be
executed by any user.
NOTES
SET SESSION AUTHORIZATION cannot be used within a SECURITY DEFINER function.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
peter | peter
SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
paul | paul
COMPATIBILITY
The SQL standard allows some other expressions to appear in place of the literal user_name, but these options are not important in
practice. PostgreSQL allows identifier syntax ("username"), which SQL does not. SQL does not allow this command during a transaction;
PostgreSQL does not make this restriction because there is no reason to. The SESSION and LOCAL modifiers are a PostgreSQL extension, as is
the RESET syntax.
The privileges necessary to execute this command are left implementation-defined by the standard.
SEE ALSO
SET ROLE (SET_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 SET SESSION AUTHORIZATION(7)