12-02-2010
Formating output
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL WITH DEFAULT
The columns in a file are as below.where eve
COLUMNS DATATYPE NULL
COL1 CHAR(5) YES
COL2 CHAR(5) NO
.. CHAR(5)
. . CHAR(5)
COL N CHAR(5) YES
Any suggessions how to implement above mentioend syntax using the columns information from the file?
Regards
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Gurus,
In my Cal output i want to cut the date of 2nd saturday how tyo achive this.
for eg in the below output i need that second saturday 13 to be cut.
crypto $ cal
January 2007
S M Tu W Th F S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26... (2 Replies)
Discussion started by: Krrishv
2 Replies
2. Shell Programming and Scripting
I have a file proc.txt which contains the below one.
Content-type: text/html
<H2>No query</H2>
infodba-marabou:/tmp
=> export QUERY_STRING="IMAN_server_report=full"
infodba-marabou:/tmp
=> $IMAN_ROOT/web/htdocs/cgi-bin/iman > /tmp/proc.txt
infodba-marabou:/tmp
=> cat proc.txt... (20 Replies)
Discussion started by: Krrishv
20 Replies
3. Shell Programming and Scripting
Hello,
I am trying to output the values in an array to a file. The output needs to be formated such that each array value is left jusified in a field 8 character spaces long. Also, no more than 6 fields on a line. For example:
@array= 1..14;
Needs to be output to the file like so:
1 ... (4 Replies)
Discussion started by: seismic_willy
4 Replies
4. Shell Programming and Scripting
Dear All
I am stuck in one problem. Kindly help me.
I am taking below mention file as input file and want some op file as mention below.
Kindly send me all possible suggestion and query.
Thnaks
Jaydeep
bELOW IS THE INPUT FILE:
*** Connected to BSCANGR ***... (1 Reply)
Discussion started by: jaydeep_sadaria
1 Replies
5. Shell Programming and Scripting
Hi!
I'm working a program that collects 4 various inputs and format my output into tabular form.Problem is my table margins move with different character lengths.
Is there a way to fix my table margins even though the variables inside the table varies in length?
thank you very much...:( (1 Reply)
Discussion started by: Lo11001
1 Replies
6. Shell Programming and Scripting
Hi all, I want to start a new topic on this matter
I have this script,
#!perl
use strict;
use warnings;
use Data::Dumper;
open my $log, '>', 'log-external.txt' or die "Could not open log: $!";
print $log "Subnet,Static,DHCP,Unused\n";
open my $dump, '>', 'dump.log' or die... (2 Replies)
Discussion started by: richsark
2 Replies
7. UNIX for Advanced & Expert Users
if you want to parse the output from an autosys you can use the below
autorep -j Prefix_% | awk '{
if ($6 ~ /^/)
printf "%-20s \t\t %-20s\n",$1,$5 ;
else if ($6 ~ /^/)
printf "%-20s \t\t %-20s\n",$1,$6;
else
printf "%-20s \t\t %-20s\n",$1,$4
}' | awk '{
if ($2... (1 Reply)
Discussion started by: phpsnook
1 Replies
8. UNIX for Advanced & Expert Users
I have a print file taken from the print spooler and I want to delete all the formatting leaving only the text. If you vi the file it shows "\304\304 ...." which translates into a printed line on print output.
I need to be able to edit and pass this file to another process
Thnaks (10 Replies)
Discussion started by: petercp
10 Replies
9. UNIX for Dummies Questions & Answers
Hi I am a newbie here. I tried searching for the solution but I guess I either didn't find it or there hasn't been one posted.
my problem is I spooled the results of a query into a .txt file. When I cat the file the formating looks great. All the columns are aligned. However once I mailx the... (2 Replies)
Discussion started by: RB26DETT
2 Replies
10. Shell Programming and Scripting
Hi Guys,
I was searching and landed up something here only.
This is the code and I want the formatted html in email but that is not working, anybody knows the reason why?
#!/bin/sh
set -x
DATE=`date -u`
# Print beginning of webpage
function html_header
{
cat <<END
... (5 Replies)
Discussion started by: bluemind2005
5 Replies
LEARN ABOUT SUSE
alter_view
ALTER
VIEW(7) SQL Commands ALTER VIEW(7)
NAME
ALTER VIEW - change the definition of a view
SYNOPSIS
ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
ALTER VIEW name OWNER TO new_owner
ALTER VIEW name RENAME TO new_name
ALTER VIEW name SET SCHEMA new_schema
DESCRIPTION
ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.)
You must own the view to use ALTER VIEW. To change a view's schema, you must also have CREATE privilege on the new schema. To alter the
owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the view's schema.
(These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the view. However, a
superuser can alter ownership of any view anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing view.
SET/DROP DEFAULT
These forms set or remove the default value for a column. A default value associated with a view column is inserted into INSERT
statements on the view before the view's ON INSERT rule is applied, if the INSERT does not specify a value for the column.
new_owner
The user name of the new owner of the view.
new_name
The new name for the view.
new_schema
The new schema for the view.
NOTES
For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equiv-
alent to the ones shown above.
EXAMPLES
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
COMPATIBILITY
ALTER VIEW is a PostgreSQL extension of the SQL standard.
SEE ALSO
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(7)]
SQL - Language Statements 2010-05-14 ALTER VIEW(7)