Recent content by cjohnson6

I've just loaded Informix Dynamic Server 2000 (version 9.21.TC1-1) for NT here locally. But my question is what is the maximum server name length i can use when creating new instances? In the past when we had Informix version 7.3 in place, we would run into issues when the server name exceeded...

I work for a company that is looking into purchasing some 3rd party software applications that will allow for full data modeling capabilities on a larger scale. the primary solution was said to be Rational Rose & i've done my research of their products & what they offer. however, does anyone...

I work for a company that is looking into purchasing some 3rd party software applications that will allow for full data modeling capabilities on a larger scale. the primary solution was said to be Rational Rose & i've done my research of their products & what they offer. however, does anyone...

Can anyone assist me on where i can find information, link or a website that will provide me with detailed information re: Oracle's INIT.ORA configuration file & its parameters? I am a relatively novice user to Oracle & want to better understand the specifics of each parameter, why they are &...

My company has just implemented Oracle 8.1.7 & i am in the process of using Oracle's NetAsst. to try & create my first database instance. however, with the limited knowledge i have of Oracle, can anyone tell me if there are any limitations or restrictions on what your global database name must...

Can anyone direct me to where i can find and research a particular Sybase error i'm getting? (SYB SQL ERR -840?) Thinking there has to be somewhere out there (the internet) that i can reference this info from. After checking sybase.com for assistance, i found nothing. the reference materials...

I'm a fairly novice user of Oracle but having used SQL Server 7.0 and 2000, i'm very familiar with relational databases and structure. However, i am having problems with an Oracle server that is confirmed to be started and running. the proper tnsnames.ora is in place with the correct entries...

Can anyone point me in the right direction on where I can find good info online detailing how to, the pros and cons, syntax required, etc. for using Informix replication? Either 'high end' or 'enterprise' replication. Any assistance would be appreciated. Thank you, Claude Johnson...

I Hope i phrase this question to where it will make sense. My company recently purchased Oracle 8i (er 8.1.7) and loaded it onto a new Sun Solaris box. The access to this box from a stand alone PC can be accessed through a mapped drive we have created (called S:\). It is through this network...

Is there anything in Oracle's packaged documentation or anything online that gives a better explanation of the INIT.ORA file and its parameters? I ask aske we (my company) has had to make subtle changes to its parameters in the past without fully understanding the limitations of said changes...

Thanks to all that have responded so far. It has helped me in better monitoring the way our Oracle databases are handling data and ongoing queries/processes.

I am new to an Oracle environment (Database Support/Analysis) and its utilities and after review of the included Oracle documentation, I have been unable to locate any basic utilities that will assist me in identifying 'deadlock' issues and how I can address them. Can anyone assist me in...

CREATE TRIGGER [Trig_CheckReleased] ON dbo.t_candidate1 FOR INSERT, UPDATE AS My name is Claude Johnson and I have attached a new trigger I've created below and what I am trying to do within this trigger is call a value through a SELECT statement and then if a particular condition is TRUE, I...

Thanks Malcolm. That worked out great. I really appreciate your help and speedy response. I've found the folks in this forum are really cordial and helpful. Claude

I am trying to create the syntax (stored procedure) that will allow me to first check the status of a given date field, and if that date field is OLDER than 1 year (365 calendar days), I'll print out a statement and update the appropriate table(s). Can anyone assist me with this task? Here is a...