Dear experts required you support to achieve below
i need the file 2 values show on top of file 1 for mentioned valuesENTER CREDENTIALS or beside this
please support to achieve the expected result . if I get the result 2 that will be better
I have two files
Code:
File 1
ENTER CREDENTIALS
BILLING - ONLINE BILL DETAILS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
ENTER CREDENTIALS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
ENTER CREDENTIALS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
BILLING - ONLINE BILL DETAILS
ENTER CREDENTIALS
Code:
File 2
auabc,1234
auabc,5678
auabc,9711
Code:
Expected result
auabc,1234
ENTER CREDENTIALS
BILLING - ONLINE BILL DETAILS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
auabc,5678
ENTER CREDENTIALS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
auabc,9711
ENTER CREDENTIALS
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE
BILLING - ONLINE BILL DETAILS
or (appreciate we can achieve this one )
ENTER CREDENTIALS ,auabc,1234
BILLING - ONLINE BILL DETAILS ,auabc,1234
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE ,auabc,1234
ENTER CREDENTIALS ,auabc,5678
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE ,auabc,5678
ENTER CREDENTIALS ,auabc,9711
INTERACTION - SUB ORDERS - VIEW - MANAGED SERVICE ,auabc,9711
BILLING - ONLINE BILL DETAILS ,auabc,9711
Please someone I need information on how to change a Unix form/document into a microsoft word document in order to be emailed to another company. Please help ASAP. Thankyou :confused: (8 Replies)
Hi I have a requirement like this.
I have two files
This is how data1.txt looks:
EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY ... (4 Replies)
Hi All
Looking for some help here I want to query a file and mv all files that are older than seven days to an archive folder.
the archive folder already exists but I am having trouble with the date comparison.
list file is as follows
eg
dd2302071334.txt
dd2302071358.txt... (7 Replies)
Friends,
os: redhat enterprise linux/SCO UNIX5.0
I have two files and I would like to merge on given key value.
Now I have tried with join commd but it does not supporte multiple delimiters.
and if records length is not fixed.
join -a1 5 -a2 1 -t -o file1 file2 > outname
Can any... (7 Replies)
Hello,
Using the instruction mget (within ftp) and with "Interactive mode off", I want to get all files from directory (DirAA), but not the files in sub-directories.
The files names don't follow any defined rule, so they can be just letters without (.) period
Directory structure example: ... (0 Replies)
Hi,
I have two files a.txt and b.txt.
a.txt
1
2
3
4
b.txt
a
b
c
d
e
I want to generate a file c.txt by merging these two file and the resultant file would contain
c.txt
1 (4 Replies)
Friends,
I need help with the following in UNIX.
Merge all csv files in one folder considering only 1 header row and ignoring header of all other files.
FYI - All files are in same format and contains same headers.
Thank you (4 Replies)
Hi All ,
I have a scenario where we need to combine two files .
Below are the sample files and expected output ,
File 1:
1|ab
1|ac
1|ae
2|ad
2|ac
File 2:
1|xy
1|fc
2|gh
2|ku
Output file :
1|ab|xy (3 Replies)
Hi All,
I have 2 files which i need to merge together based on the column names provided in the file. The first line in both files are header records.
The first file has fixed columns but second file can have subset of the columns from file 1
File 1:
... (6 Replies)
Discussion started by: kushagra
6 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)