10-18-2006
here is the script'
connect to db;
export to 'path of the file' of del select * form table
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
2. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
3. Shell Programming and Scripting
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies
4. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
5. Shell Programming and Scripting
i have a Oracle table like
col1 col2
---- -----
a 1
b 2
c 3
when i write a script for it , it gives me all the data in one column.
Please give me the solution which gives the exact result like we see in sql editors.
for a in `echo "
set feedback off;
set pagesize 40;... (1 Reply)
Discussion started by: ss135r
1 Replies
6. Shell Programming and Scripting
Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies
7. Shell Programming and Scripting
Hi,
I want to write a shell script which connect to my database with the following credentials :
User name : user
PWD : rap_user_1
Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID : PTNC1
Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
8. Shell Programming and Scripting
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
9. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
10. Programming
Hi, I am complete new to C programming and shell scripting. I just wrote a simple C code to calculate integral using trapezoid rule. I am prompting user to pass me No. of equally spaced points , N , upper and lower limit. My code looks as follows so far:
#include<stdio.h>
#include<string.h>... (2 Replies)
Discussion started by: bjhjh
2 Replies
LEARN ABOUT CENTOS
ipa-csreplica-manage
ipa-csreplica-manage(1) IPA Manual Pages ipa-csreplica-manage(1)
NAME
ipa-csreplica-manage - Manage an IPA CS replica
SYNOPSIS
ipa-csreplica-manage [OPTION]... [connect|disconnect|del|list|re-initialize|force-sync]
DESCRIPTION
Manages the CA replication agreements of an IPA server.
connect [SERVER_A] <SERVER_B>
- Adds a new replication agreement between SERVER_A/localhost and SERVER_B
disconnect [SERVER_A] <SERVER_B>
- Removes a replication agreement between SERVER_A/localhost and SERVER_B
del <SERVER>
- Removes all replication agreements and data about SERVER
list [SERVER]
- Lists all the servers or the list of agreements of SERVER
re-initialize
- Forces a full re-initialization of the IPA CA server retrieving data from the server specified with the --from option
force-sync
- Immediately flush any data to be replicated from a server specified with the --from option
The connect and disconnect options are used to manage the replication topology. When a replica is created it is only connected with the
master that created it. The connect option may be used to connect it to other existing replicas.
The disconnect option cannot be used to remove the last link of a replica. To remove a replica from the topology use the del option.
If a replica is deleted and then re-added within a short time-frame then the 389-ds instance on the master that created it should be
restarted before re-installing the replica. The master will have the old service principals cached which will cause replication to fail.
OPTIONS
-H HOST, --host=HOST
The IPA server to manage. The default is the machine on which the command is run Not honoured by the re-initialize command.
-p DM_PASSWORD, --password=DM_PASSWORD
The Directory Manager password to use for authentication
-v, --verbose
Provide additional information
-f, --force
Ignore some types of errors
--from=SERVER
The server to pull the data from, used by the re-initialize and force-sync commands.
EXAMPLES
List a server's replication agreements.
# ipa-csreplica-manage list srv1.example.com
srv2.example.com
srv3.example.com
Re-initialize a replica:
# ipa-csreplica-manage re-initialize --from srv2.example.com
This will re-initialize the data on the server where you execute the command, retrieving the data from the srv2.example.com replica
Add a new replication agreement:
# ipa-csreplica-manage connect srv2.example.com srv4.example.com
Remove an existing replication agreement:
# ipa-csreplica-manage disconnect srv1.example.com srv3.example.com
Completely remove a replica:
# ipa-csreplica-manage del srv4.example.com
Using connect/disconnect you can manage the replication topology.
EXIT STATUS
0 if the command was successful
1 if an error occurred
IPA
Jul 14 2011 ipa-csreplica-manage(1)