Recent content by MeganP

I am trying to configure Cognos ReportNet on my Windows XP Home. Here is the status of the tasks. 1. Installed Apache WebServer - Tested and it is working fine 2. Installed Cogns ReportNet 1.1 - Installed properly. 3. Content Manager setup - Tried to connect Oracle 9i database with admin...

HI, I need to migrate perl program from one server to another. What steps do I need to follow during the process? If I simply install perl in the desired folder, will it be enough or do I need to tweak in any way to make it work? After installation do I need to do any additional tasks? Thank...

Thanks for your prompt reply. Previously GREEN and ZONE could find next to each other (side by side column values), but now there are two empty columns between them. If I could make the following change, Would it be suffiecient? next if $_ !~ /PECO\s*\,\,\,\s*ZONE\s*\,/;

HI, I am newbie to Perl. I started supporting one application that has one perl program and it needs modification. It does get next record if current record doesn't match pattern. I couldn't understand the use of s* and , in the match pattern. Could some one explain me in detail, please? next...

HI all, How could I migrate DTS packages, as a group, from one server to another? Currently I am coping one package at a time. Any help is greatly appreciated! Thanks!

Thanks a lot!

Hi, I have written the following script to schedule a job to run on 3rd Wednesday of every month, but It is executing on every Wednesday and every day between 15-21 dates. Can some one help me in fixing this bug. Any help is greatly appreciated! 00 16 15-21 * 3 /u11/cdw_prod/Script1.ksh Thanks!

I know the SQL (in Oracle) for removing duplicates (leaves one record). Can some one translate the below or write new one in T-SQL? delete from my_table t1 where exists (select 'x' from my_table t2 where t2.key_value1 = t1.key_value1 and t2.key_value2 =...

Can some one explain me how to intrepret SQL profiler produced information, please? I am looking for detailed information. Thanks,

I ran SQL profiler on both the servers and found out that INDEX has not been used on new server. HOw can I force SQL Server to use index for update process?

DTS package executes SQL update query, but the source is TEXT file. In DTS it shows like this UPDATE Supplier SET SUPPLIER_LINE_1 =?, SUPPLIER_LINE_2 =?, Lineage_Full =?, Lineage_Short =? WHERE Supplier_number = ? How can I use this query in Query Analyzer? What changes do I need to make...

How can I review the execution plan of DTS Package? I would really appreciate if You would throw some light on this.

HI all, When we migrated SQL server database from one server to another (New Server is robust), Insert performance has been improved a lot, but Update performance has diminished a lot. I couldn't find any change in objects like Indexes, Keys. What could be the issue? PS: DTS packages are...

SOme how I am just getting the table layout, not all the properties (Indexes, dependenies etc..)

When I copy table (export data) from one SQL Server database to another, How I can import all the properties of table including primary key, indexes, dependencies etc. Any help is greatly appreciated!