Help with pivoting table shell script Post: 302978843

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a table in a shell script

Dear all: I want to write a script capable of reading specific rows and collumns of a table, into a variable. Just imagine i have a file named table.dat which contains: GENERAL INFORMATION Col 1 Col2 Col3 1 1 2 2 3 3 4 4 What i want to do...

2. Shell Programming and Scripting

Alter Table Shell Script

I want to add some columns to a existing tables through a shell script. Please help.

3. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through...

4. Shell Programming and Scripting

Truncating table from a shell script

I am trying to truncate a table using below script. When I ran the script it runs fine but table was not truncated and the spool is empty. I am not sure what is wrong with pl/sql block. #!/bin/ksh # ---------------------------------------------------------------------- # # Created by: XXXX...

5. Shell Programming and Scripting

Create DB table through shell script

Hi, Can anyone tell me that, How to create table in Oracle database through shell script(ksh). Table contains 3 fields, 1] Emp ID, String, primary key 2] Name, String 3] B Date, date. Thanks in advance.

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

7. Shell Programming and Scripting

Transposing rows and columns (pivoting) using shell scripting

Here is the contents of an input file. A,1,2,3,4 10,aaa,bbb,ccc,ddd 11,eee,fff,ggg,hhh 12,iii,jjj,lll,mmm 13,nnn,ooo,ppp I wanted the output to be A 10 1 aaa 10 2 bbb 10 3 ccc 10 4 ddd 11 1 eee 11 2 fff 11 3 ggg 11 4 hhh ..... and so on How to do it in ksh...

8. Shell Programming and Scripting

Shell Script Table

Hi, i need a bit help. I must write a script with shell- and sed-commands, which reads a table from stdin and writes a html-table on stdout (so i can open it with a web browser). The number of columns must be a parameter for the script, so i can start it for example with: "./htmltab.sh 3...

9. Shell Programming and Scripting

Pivoting using shell scripts

Hi , Please any one help using shell scripts achieve the below output(pivoting on top_cd i mean type code values will come as individual columns and fixed amount is value for that .Any help would be greate tx_id tx_amt typ_cd fixed_dis_amt 100 200 mc ...

10. Shell Programming and Scripting

Download a db table through UNIX shell script

Hi, I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env. I was able to connect to the prod db and then run a simple query as below. @@@@@@@@@@ ...

LEARN ABOUT X11R4

ed2k

ED2K(1) 							  aMule utilities							   ED2K(1)

NAME

       ed2k - aMule eD2k link parser

SYNOPSIS

       ed2k [-c <path>] [-t <num>] [-e] [-l] <eD2k-link>

       ed2k [-h]

       ed2k [-v]

DESCRIPTION

       Sends the given <eD2k-link> to aMule, i.e. writes it to the file ~/.aMule/ED2KLinks, which will be checked by aMule every second for links.

       [ -c <path>, --config-dir=<path> ]
	      Read config from <path> instead of home

       [ -t, --category=<num> ]
	      Set category for passed eD2k links to <num>

       [ -e, --emulecollection ]
	      Loads all link found in the emulecollection given as <ed2k-link>

       [ -l, --list ]
	      Lists all link found in the emulecollection given as <ed2k-link>

       [ -h, --help ]
	      Prints a short usage description.

       [ -v, --version ]
	      Displays the current version number.

       [ eD2k-link ]
	      Adds an eD2k-link to the core.

       The eD2k link to be added can be:

	  o a file link (ed2k://|file|...), it will be added to the download queue;

	  o a server link (ed2k://|server|...), it will be added to the server list;

	  o a serverlist link, in which case all servers in the list will be added to the server list;

	  o a magnet link;

	  o an emulecollection file.

       The  order  in  which you give the parameters is important.  You can give more than one link, and every link can have it's own params.  For
       example ed2k <link1> -t2 <link2> will download <link1> in standard category and <link2> in category 2.

FILES

       ~/.aMule/ED2KLinks

REPORTING BUGS

       Please report bugs either on our forum (http://forum.amule.org/), or in our bugtracker (http://bugs.amule.org/).  Please do not report bugs
       in e-mail, neither to our mailing list nor directly to any team member.

COPYRIGHT

       aMule and all of its related utilities are distributed under the GNU General Public License.

SEE ALSO

       amule(1)

AUTHOR

       This manpage was written by Vollstrecker <amule@vollstreckernet.de>

aMule eD2k link parser v1.5.1					   November 2011							   ED2K(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a table in a shell script

Discussion started by: luiscarvalheiro

2. Shell Programming and Scripting

Alter Table Shell Script

Discussion started by: ankitgupta

3. Shell Programming and Scripting

To update a column in a table through shell script

Discussion started by: shilpa_acc

4. Shell Programming and Scripting

Truncating table from a shell script

Discussion started by: gunaah