help for writing shell script to export table data Post: 302082236

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...

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...

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,

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 .

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;...

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.

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...

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 ; ...

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. ...

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>...

LEARN ABOUT HPUX

symlink

symlink(4)						     Kernel Interfaces Manual							symlink(4)

NAME

       symlink - symbolic link

DESCRIPTION

       A symbolic (or soft ) link is a file whose name indirectly refers (points) to a relative or absolute path name.

       During  path  name  interpretation,  a symbolic link to a relative path name is expanded to the path name being interpreted, and a symbolic
       link to an absolute path name is replaced with the path name being interpreted.

       Thus, given the path name

	      If is a symbolic link to a relative path name such as the path name is interpreted as

	      If is a symbolic link to an absolute path name such as the path name is interpreted as

       All symbolic links are interpreted in this manner, with one exception: when the symbolic link is the last component of a path name,  it	is
       passed  as  a  parameter  to  one of the system calls: or (see readlink(2), rename(2), symlink(2), unlink(2), chown(2) and lstat(2)).  With
       these calls, the symbolic link, itself, is accessed or affected.

       Unlike normal (hard) links, a symbolic link can refer to any arbitrary path name and can span different logical devices (volumes).

       The path name can be that of any type of file (including a directory or another symbolic link), and may be invalid if no such  path  exists
       in  the	system.   (It is possible to make symbolic links point to themselves or other symbolic links in such a way that they form a closed
       loop.  The system detects this situation by limiting the number of symbolic links it traverses while translating a path name.)

       The mode and ownership of a symbolic link is ignored by the system, which means that affects the actual file, but not the  file	containing
       the symbolic link (see chmod(1)).

       Symbolic links can be created using or (see ln(1) and symlink(2)).

AUTHOR

       was developed by HP and the University of California, Berkeley.

SEE ALSO

       cp(1), symlink(2), readlink(2), link(2), stat(2), mknod(1M).

																	symlink(4)