archives

RMAN, Best Practice?

10.2.0.4 on AIX if it matters: I think we will end up with n number of databases on various machines, and an RMAN catalog database elsewhere (I'm not concerned with how the RMAN catalog is itself backed up; that is someone else's problem). Questions: Should RMAN be invoked locally, or from the "master"? Does it

FAQ 9.23 How do I find out my hostname, domainname, or IP address?

This is an excerpt from the latest version perlfaq9.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Perl search engine

A new search engine through a perl-related websites is opened: [link] Hope it would be useful useful to somebody.

FAQ 9.4 How do I remove HTML from a string?

This is an excerpt from the latest version perlfaq9.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Give me your tired, your poor, your really cool old IDUG stuff

Your reading Willie's "Getting the Most out of DB2 for z/OS and System z" blog. My apologies to Emma Lazarus for "borrowing" the first line from her poem “The New Colossus”; you know that poem on the plaque at the base of the Statue of Liberty. And I really don't want you to physically send

Bug with ANSI/92 joins USING clause in Oracle 10g? Can't SELECT on join fields?

The following query, using the ON clause, works fine: -- Query #1 select e.employee_id, d.department_id, d.department_name from employees e INNER JOIN departments d ON e.department_id = d.department_id The same query, employing (pun intended) the USING clause does not work: -- Query #2 select e.employee_id, d.department_id, d.department_name

Choosing a surrogate key vs. a composite key - "holy war" issue or clear best practice?

Early in my career, I was accustomed to seeing simple, sequence- generated surrogate keys. Seemed clean and logical. Later in my career, I saw seemingly monstrous (to me) composite keys of up to 5 fields. Found them initially repulsive because they made queries difficult to read and write. I'm wondering if there is a clear best

FAQ 9.7 How do I make an HTML pop-up menu with Perl?

This is an excerpt from the latest version perlfaq9.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Storing codes vs. human-intelligible values - best practice?

In a pre-existing project, many tables reference domain (lookup) tables of the general structure: intelligible value; max varchar length varies by table, but typically no longer than 30 characters * COL_CD (column code) -- a not null field with a unique constraint, typically an integer with a length of 1-2 digits.

Need help with a question.

I'm having a problem with my Perl script, what I would like the script to achieve is to read a file, search it for certain words, put the results into an Array so I can then call each result with $var[1] etc and print output to a file. I tried doing it without Sub routines but wasn't able to split the results. When I rapped the code into a Sub I

FAQ 8.25 How can I capture STDERR from an external command?

This is an excerpt from the latest version perlfaq8.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Open Source Database Explorer

DBAs, Analysts, Developers, and even Business types can benefit from a database explorer tool that quickly and gets them to information. Talend Open Profiler, an Open Source application, enables users to quickly and easily find data analysts, DBAs, and business users the ability to research data structures and data quality

What is CRM in Higher Ed? Research houses should step up & define it.

CRM's meaning in Higher Education needs to be defined and standardized to reduce market confusion and increase adoption rates.