|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
connecting to table to extract multiple rows into file from unix script
Post 302587873 by Rksiva on Friday 6th of January 2012 06:59:14 AM
01-06-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I am trying to write a bash shell script that does the following:
1.Finds all *.txt files within my directory of interest
2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format)
3. skips the first 10 rows of the file
4. extracts and... (4 Replies)
Discussion started by: manishabh
4 Replies
2. Shell Programming and Scripting
Suppose there is a table like the following...I just wanted to know if there is any command using which we can get the record/name of the person who joined before 2005..
Sl Name des y.o.joining
1 Ram Engineer 2001
2 Hari Doctor 2004
3 David Plumber 2005
4 Rahim painter 2007
5 gurmeet... (1 Reply)
Discussion started by: satyajit007
1 Replies
3. Shell Programming and Scripting
Hi Gurus,
I'm a unix newbie and I would like to connect to multiple unix servers from unix server using shell script i.e from server a to server b,c,d etc. I want to copy the files from unix server a to server b, c, d. I can access staright using ssh without the need to have password and user... (5 Replies)
Discussion started by: sexyTrojan
5 Replies
4. Shell Programming and Scripting
I have an Employee with EID, ENAME and ESTATUS as columns in SQL.
I want to extract the status of an employee and update the details if the status is 'A'.
Can anyone help in writing the shell script. (1 Reply)
Discussion started by: vkca
1 Replies
5. Shell Programming and Scripting
I have bash, awk, and sed available on my portable device. I need to extract 10 fields from each table row from a web page that looks like this:
</tr>
<tr>
<td>28 Apr</td>
<td><a... (6 Replies)
Discussion started by: rickgtx
6 Replies
6. Shell Programming and Scripting
hi,
i have a requirement where i need to connect sqlplus from unix and i am able to do so by following command:
cust_count=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF
set pagesize 0
set feedback off
set verify off
... (1 Reply)
Discussion started by: lovelysethii
1 Replies
7. Shell Programming and Scripting
Hi, i want to create a table automatically based on another table (sms_key).
For example;
If user create a new row with sms_keyword field: IRC then a table created automatically (with some field on it, like: name, ph_number, messages).
select * from sms_key;
+-------------+
|... (1 Reply)
Discussion started by: jazzyzha
1 Replies
8. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
9. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
10. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
LEARN ABOUT SUNOS
asadmin-export
asadmin-export(1AS) User Commands asadmin-export(1AS) NAME
asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode SYNOPSIS
export [ name=value [ name=value]*] Marks a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable name is displayed. If the export command is used without any arguments, a list of all the exported variables and their values is displayed. Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and set as exported variables within asadmin. Unexported environment variables cannot be read by the asadmin utility. OPERANDS
name=value variable name and value for automatic export to the environment to be used by subsequent commands. Example 1: Using export to list the environment variables asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password asadmin> export AS_ADMIN_PREFIX=server1.jms-service asadmin> export //to list the environment variables that are set AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=******** AS_ADMIN_PREFIX=server1.jms-service Where: the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service. EXIT STATUS
0 command executed successfully 1 error in executing the command asadmin-unset(1AS), asadmin-multimode(1AS) J2EE 1.4 SDK March 2004 asadmin-export(1AS)