Advertisement

12.19.2007 at 07:52PM PST, ID: 23035138
[x]
Attachment Details

How do I use PERL to search and replace some keywords ??

Asked by dn_learner in Perl Programming Language, MS SQL Server, Sybase Database

Tags: ,

Hi Folks,
I have a folder where I have .SQL files that contain DDL (Data Definition Language)  statements for creating Views in T-SQL. My goal is to take those DDL scripts and create the views on the Sybase ASE database. However there are some keywords on SQL server side that I need to search and replace with equivalent keywords that Sybase expects. The mapping of the keywords is currently stored in a database table on the sybase side.

My question is How do I use use PERL to perform the above described scenario ?  I'm new to PERL and I would really appreciate any ideas and/or code snipptes that could help me get started.

Thanks in advance.Start Free Trial
[+][-]12.19.2007 at 10:08PM PST, ID: 20505090

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.19.2007 at 10:11PM PST, ID: 20505097

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]12.20.2007 at 04:28AM PST, ID: 20506086

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]12.20.2007 at 08:05PM PST, ID: 20511684

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Perl Programming Language, MS SQL Server, Sybase Database
Tags: replace, search
Sign Up Now!
Solution Provided By: nedfine
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628