03-31-2018
Hi..
Thanks for reply..
now it better..but not completely
I see two problems now:
1. headers row not aligned
2. Most of data rows are aligned..i see only problem in those rows where SERVICE column data is having huge length that why its pushing other columns..the max length of this column is 40....
after position 40 the rest of the columns to be printed .. how can i force to print 2nd column onwards after 40th position
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello ,
I want to get current system open file table value. Can any one help.
Thanking you,
mahesh (0 Replies)
Discussion started by: mahesh.
0 Replies
2. Shell Programming and Scripting
Data in File
ABC:DEFGHI:123
ABCZYE:DEFI:123
ABCFGD:DEF:123
ABCEERRRRR:DEFGHI:123
Expected Format
1 ABC DEFGHIFE 123
2 ABCZYE DEFI 123
3 ABCFGD DEF 123
4 ABCEERRRRR DEFGHI 123
However when i enter the following... (2 Replies)
Discussion started by: blurboy
2 Replies
3. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
4. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
5. Solaris
Hello and Merry Christmas...
Quick question after tireless search around the web.
Description:
I have a WD My book world edition II that met an untimely death. However the 2 SATA disks inside seem to be working just fine. Want to add either one of them to my Solaris Desktop.
Since I... (5 Replies)
Discussion started by: michnmi
5 Replies
6. Red Hat
Hi, I have a linux file that has data like this..
REQUEST_ID|text^Ctext^Ctext^C
REQUEST_ID|text^Ctext^C
REQUEST_ID|
REQUEST_ID|
REQUEST_ID|text^Ctext^Ctext^Ctext^Ctext^Ctext^C....
Where ever I see a ^C character, I need to copy the corresponding REQUEST_ID and that part of the text to a new... (17 Replies)
Discussion started by: charithainfadev
17 Replies
7. Shell Programming and Scripting
I am new to this shell scripting....
I have a file which contains list of users. This files get updated when new user comes into the system.
I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies
8. Shell Programming and Scripting
Hi
I have the below output:
736f14c4-eda2-4531-9d40-9de4d6d1fb0f
An account already exists for this email address. Please enter a different email address.
c3716baf-9bf8-42da-8a44-a13fff68d20f
An account already exists for this email address. Please enter a different email address.
Is... (4 Replies)
Discussion started by: ankur328
4 Replies
9. Web Development
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT CENTOS
spi_modifytuple
SPI_MODIFYTUPLE(3) PostgreSQL 9.2.7 Documentation SPI_MODIFYTUPLE(3)
NAME
SPI_modifytuple - create a row by replacing selected fields of a given row
SYNOPSIS
HeapTuple SPI_modifytuple(Relation rel, HeapTuple row, int ncols,
int * colnum, Datum * values, const char * nulls)
DESCRIPTION
SPI_modifytuple creates a new row by substituting new values for selected columns, copying the original row's columns at other positions.
The input row is not modified.
ARGUMENTS
Relation rel
Used only as the source of the row descriptor for the row. (Passing a relation rather than a row descriptor is a misfeature.)
HeapTuple row
row to be modified
int ncols
number of column numbers in the array colnum
int * colnum
array of the numbers of the columns that are to be changed (column numbers start at 1)
Datum * values
new values for the specified columns
const char * Nulls
which new values are null, if any (see SPI_execute_plan for the format)
RETURN VALUE
new row with modifications, allocated in the upper executor context; NULL only if row is NULL
On error, SPI_result is set as follows:
SPI_ERROR_ARGUMENT
if rel is NULL, or if row is NULL, or if ncols is less than or equal to 0, or if colnum is NULL, or if values is NULL.
SPI_ERROR_NOATTRIBUTE
if colnum contains an invalid column number (less than or equal to 0 or greater than the number of column in row)
PostgreSQL 9.2.7 2014-02-17 SPI_MODIFYTUPLE(3)