Help with pivoting table shell script Post: 302978811

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

xvsetportattribute

XvSetPortAttribute(3)					     Library Functions Manual					     XvSetPortAttribute(3)

Name
       XvSetPortAttribute - sets an attribute of a video port

Syntax
       #include <X11/extensions/Xvlib.h>

       XvSetPortAttribute(Display *dpy, XvPortID port,
			  Atom attribute, int value);

Arguments
       dpy	      Specifies the connection to the X server.

       port	      Specifies the port for which the attribute is to be used.

       attribute      Identifies the port attribute to be set by this request.	Can be one of the table entries under the column "String," below.

       value	      Identifies the value to which attribute is to be set.  Can be one of the table entries under the column "Type," below.

Description
       XvSetPortAttribute(3) permits a client to set the port attribute to specified values.  This request supports the following values:

       Attribute String        Type		Default

       "XV_ENCODING"	       XvEncodingID	Server dependent
       "XV_HUE" 	       [-1000...1000]	0
       "XV_SATURATION"	       [-1000...1000]	0
       "XV_BRIGHTNESS"	       [-1000...1000]	0
       "XV_CONTRAST"	       [-1000...1000]	0

       The supplied encoding must be one of the encodings listed for the adaptor, otherwise an Encoding error results.

       If  the	adaptor  does  not  support  the exact hue, saturation, brightness, and contrast levels supplied, the closest levels supported are
       assumed.  Use XvGetPortAttribute(3) to query the resulting levels.

       When an XvSetPortAttribute(3) request is processed, a PortControlNotify(3) event is generated for all clients that have requested for  port
       changes using XvSelectPortNotify(3).

Returned Values
       [Success]
	       Returned if XvSetPortAttribute(3) completed successfully.

       [XvBadExtension]
	       Returned if the Xv extension is unavailable.

       [XvBadAlloc]
	       Returned if XvSelectVideoNotify(3) failed to allocate memory to process the request.

Diagnostics
       [XvBadPort]
	       Generated if the requested port does not exist.

       [XvBadEncoding]
	       Generated if an encoding is specified that does not exist.

       [BadMatch]
	       Generated if the requested attribute atom does not specify an attribute supported by the adaptor.

See Also
       XvGetPortAttribute(3), XvSelectPortNotify(3), XvPortNotify(3)

X Version 11							    libXv 1.0.4 					     XvSetPortAttribute(3)

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