IMHO you should open 1 thread for each question, else people who are seeing this thread in future could be confused. So I am answering very first question of yours. Could you please try following.
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Hi
I am looking for the script which can move 1month old data from a TXT file.actully in this file data is appended on daily basis.pleasehalp me out.
Thanks in advance (3 Replies)
I have a code given below...
ERROR=`grep "Job Status" ${LOG_FILE}`
ERROR=${ERROR##*\(}
ERROR=${ERROR%%\)*}
if
then
echo "The job completed successfully"
EXIT_STATUS=0
else
echo "The job failed"
EXIT_STATUS=1
fi
can anybody tell me what is
ERROR=${ERROR##*\(}... (1 Reply)
hi
i am new to linux world please help me,i have two files in diff location
i need to compare both and i need to see difference b/w them
ex /media/txt (file1)
xxxxxx
xxxxxx
xxxxx
xxxxxx
xxxxxx
/media/rev/ (file2) rev is a folder which contains some files so i need to compare the files in... (3 Replies)
Hi!! Im new to shell scripting. I have an important assignment to complete in my company tomorrow. Please help me. I have to write an interactive script which does the following thing:
There is a file named ""rules"in a folder say /home/f1/ . This file contains text in the form:
123
345... (5 Replies)
hi,
Im trying to select from a sql using shell script and once i get count i need to add the count to the subject line and send mail to every1..
ex :
Select count(*) from emp;
In Shell script
echo $PASSWORD|$ORACLE_HOME/bin/sqlplus $USERID@$DBNAME @$SCRIPT_DIR/emp_count.sql... (1 Reply)
Hey all. Sometimes I'm tasked to change some router configs for the entire network (over 3,000 Cisco routers). Most of the time its a global config parameter so its done with a loop and an IP list as its the same configuration change for all routers. This is working OK.
However, sometimes an... (3 Replies)
Hi,
I am developing a script for writing out the failed jobs in file,
1)First step i need to create an empty file Status with today's date.
2)After that i need to execute the below command:
dsjob -server servername -user uname -password pwd -ljobs projectname
This will listout all... (5 Replies)
Hi,
I have a big list like this --> 3285
3289
328D
3291
3295
3299
329D
32A1
I need to make it like -->
3285|3289|328D|3291|3295|3299|329D|32A1
Please suggest. This is Linux OS. (8 Replies)
Hi team,
I am looking to execute some command through xargs.
$cat testfile | grep myloc
alias myloc='cd /export/nfs-1sv-23/'
I am trying to execute that alias as soon as i cat and grep ?
I tried with $cat testfile | grep myloc | xargs --> no luck ...
Can some one assist me with... (6 Replies)
TAG flow Between SDR and DELTA
SDR is the Source table.
Delta is the target table having one staging table and one Main table.
Tags flows between SDR and Delta through ER gateway.
From SDR (SDR.CUSTOMER_PRODUCT and SDR.CUSTOMER_PRODUCT_RELATIONSHIP) the Tags flows to ER... (2 Replies)
Discussion started by: patitapaban
2 Replies
LEARN ABOUT CENTOS
create_user_mapping
CREATE USER MAPPING(7) PostgreSQL 9.2.7 Documentation CREATE USER MAPPING(7)NAME
CREATE_USER_MAPPING - define a new mapping of a user to a foreign server
SYNOPSIS
CREATE USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
[ OPTIONS ( option 'value' [ , ... ] ) ]
DESCRIPTION
CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a
foreign-data wrapper uses together with the information encapsulated by a foreign server to access an external data resource.
The owner of a foreign server can create user mappings for that server for any user. Also, a user can create a user mapping for his own
user name if USAGE privilege on the server has been granted to the user.
PARAMETERS
user_name
The name of an existing user that is mapped to foreign server. CURRENT_USER and USER match the name of the current user. When PUBLIC
is specified, a so-called public mapping is created that is used when no user-specific mapping is applicable.
server_name
The name of an existing server for which the user mapping is to be created.
OPTIONS ( option 'value' [, ... ] )
This clause specifies the options of the user mapping. The options typically define the actual user name and password of the mapping.
Option names must be unique. The allowed option names and values are specific to the server's foreign-data wrapper.
EXAMPLES
Create a user mapping for user bob, server foo:
CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret');
COMPATIBILITY
CREATE USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
ALTER USER MAPPING (ALTER_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7)), CREATE FOREIGN DATA WRAPPER
(CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE SERVER (CREATE_SERVER(7))
PostgreSQL 9.2.7 2014-02-17 CREATE USER MAPPING(7)