HELLO ALL,
URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE.
FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY
and the CITY column records will be: Newyork
washington
... (1 Reply)
Hi,
I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.
... (2 Replies)
i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance
regards
brad
input.txt
---------
START
TYPE:OPT
INIT_SEQ:01... (8 Replies)
I have a text file in the following format. can any one please help me in printing the output in userfriendly format mentioned below.
Input.
1) /ss/abc/1/w/s/domainname/abc1/logname/
########error###################
########error###################
########error###################... (2 Replies)
consider this as a csv file.
H,0002,0002,20100218,17.25,P,barani
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
T,5
N
i want to read the csv file and count the number of rows that start with D and... (11 Replies)
hi all,
i want script to print the output in the following format
filename yyyy/mm/dd count
where count= no.of records in the file
Thanks in advance
hemanthsaikumar (11 Replies)
I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert
Typical Insert Statement I use to insert one row :
insert into employee(empid, country, state)... (5 Replies)
Hi, I am new to advanced scripting.
I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters.
I need to do this via shell scripting, I have got half logic (on how to get varchar/char columns and stored it in a... (2 Replies)
hello all,
I have requirement to identify similar records matching about 80% to 90%.I have to black list customers with multiple accounts.
The data is in the Oracle Database, but is there any way I can get the data into flat file and compare the strings and fetch similar matching records?
... (2 Replies)
DBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pmUser Contributed Perl DocumentatiDBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pm)NAME
DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 - Important Information Related to Upgrading from Version 0.04006
What Changed
o add_column
The new Loader detects much more information about columns and sets flags like "is_auto_increment" that it didn't set before.
o RelBuilder
The new RelBuilder will give you nicer accessor names for relationships, so you will no longer have conflicts between a foreign key
column and the relationship accessor itself (if the FK is named "_id".)
It will also more correctly infer the relationship type, e.g. some relationships that were previously detected as a "has_many" will now
be a "might_have" (when it detects a unique constraint on the foreign key column.)
Also "cascade_delete" and "cascade_copy" are turned off for by default for "has_many" and "might_have" relationships, while
"belongs_to" relationships are created with "on_delete => 'CASCADE'" and "on_update => 'CASCADE'" by default. This is overridable via
relationship_attrs.
o moniker_map
Table names are now singularized when determining the "Result" class names. So the table "user_roles" would have become "UserRoles" in
0.04006 but now becomes "UserRole" instead.
o use_namespaces
Now defaults to on. See "use_namespaces" in DBIx::Class::Schema::Loader::Base and "load_namespaces" in DBIx::Class::Schema.
o Support for more databases
We now support Microsoft SQL Server and Sybase, and there are also many improvements to the other backends.
Backward Compatibility
In backward compatibility mode, the Loader will use the old relationship names and types, will not singularize monikers for tables, and
"use_namespaces" will be off.
To control this behavior see "naming" in DBIx::Class::Schema::Loader::Base and "use_namespaces" in DBIx::Class::Schema::Loader::Base.
Static Schemas
When reading a "Schema.pm" from a static schema generated with an 0.04 version of Loader, backward compatibility mode will default to on,
unless overridden with the "naming" and/or "use_namespaces" attributes.
Dynamic Schemas
Dynamic schemas will always by default use 0.04006 mode and have "use_namespaces" off.
To upgrade a dynamic schema, set the "naming" and "use_namespaces" attributes (which is proxied to the loader) in your "Schema.pm":
__PACKAGE__->naming('current');
__PACKAGE__->use_namespaces(1);
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-06-10 DBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pm)