Sponsored Content
Top Forums Shell Programming and Scripting help for writing shell script to export table data Post 302093227 by ankitgupta on Wednesday 18th of October 2006 06:01:03 AM
Old 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

shell script to read data from text file and to load it into a table in TOAD

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

Export data from DB2 table to .txt file(space delimited)

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

How to export table data to xml file?

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

Shell script to export data from Oracle table .

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

How to get full sql table data using shell script

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

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

Data export UNIX shell script

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

How to export hive table data to a file on local UNIX?

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

Parsing - export html table data as .csv file?

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

Writing a UNIX shell script to call a C function and redirecting data to a .txt file

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
connect(2)							System Calls Manual							connect(2)

Name
       connect - initiate a connection on a socket

Syntax
       #include <sys/types.h>
       #include <sys/socket.h>

       connect(s, name, namelen)
       int s;
       struct sockaddr *name;
       int namelen;

Description
       The  call  initiates  a	connection  on a socket.  The parameter s is a socket.	If the socket is of type SOCK_DGRAM, this call permanently
       specifies the peer to which datagrams are sent.	If it is of type SOCK_STREAM, this call attempts to make a connection to  another  socket.
       The other socket is specified by name, which is an address in the communications space of the socket.  Each communications space interprets
       the name parameter in its own way.  The size of the structure sockaddr is namelen.

Return Values
       If the connection or binding succeeds, then 0 is returned.  Otherwise, a -1 is returned, and a more specific error code is stored in errno.

Diagnostics
       The call fails under the following conditions:

       [EBADF]	      The s is not a valid descriptor.

       [ENOTSOCK]     The s is a descriptor for a file, not a socket.

       [EADDRNOTAVAIL]
		      The specified address is not available on this machine.

       [EAFNOSUPPORT] Addresses in the specified address family cannot be used with this socket.

       [EINPROGRESS]  The connection is requested on a socket with FNDELAY set (using

       [EISCONN]      The socket is already connected.

       [ETIMEDOUT]    Connection establishment timed out without establishing a connection.

       [ECONNREFUSED] The attempt to connect was forcefully rejected.

       [ENETUNREACH]  The network is not reachable from this host.

       [EADDRINUSE]   The address is already in use.

       [EFAULT]       The name parameter specifies an area outside the process address space.

       [EWOULDBLOCK]  The socket is nonblocking, and the connection cannot be completed immediately.  You can select the  socket  for  writing	by
		      using the system call while it is connecting.

       The following errors are specific to connecting names in the ULTRIX domain:

       [ENOTDIR]      A component of the path prefix is not a directory.

       [ENAMETOOLONG] A component of a pathname exceeded 255 characters, or an entire path name exceeded 1023 characters.

       [ENOENT]       The named socket does not exist.

       [EACCES]       Search permission is denied for a component of the path prefix.

       [ELOOP]	      Too many symbolic links were encountered in translating the pathname.

See Also
       accept(2), fcntl(2), getsockname(2), select(2), shutdown(2), socket(2)

																	connect(2)
All times are GMT -4. The time now is 06:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy