Hi erveryone..can somebody help me on the step by step configuration ans setup of my new site. My friend had finished designing my site and is hosted on his PC server work, I was able to check it on line its OK..I have a Windows 2003 server with ISA installed and running..I have purchased a [...]
Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120 seconds [...]
Scenario: We have a Word document that is our Facility Calendar. The secretary updates it as requested with meetings, seminars, etc. The problem: When someone else has the document open, she cannot save changes she makes. She then has to email everyone and tell them to close the document. Details: We will not use Outlook [...]
This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that [...]
Hi e’rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database has a [...]
We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index and is [...]
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
I am working on a report in Crystal Report, I have a stored Procedure like this ALTER PROCEDURE [dbo].[usp_cust_by_activity] @carrier as VARCHAR(10) AS –drop table #custA –drop table #custPA –drop table #cdrall –drop table #cdrPrevMonth –SET @carrier = ‘PR’ –’PR’, ‘RG’ SELECT DISTINCT fld_cust_id INTO #custA FROM tbl_cust_ld WHERE fld_ld_status = ‘active’ and fld_cust_id in [...]
From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one [...]
From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes [...]
HELLO ALL, My static ip is in the spam list. What should I do? Thanks a lot
Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under 9.2.0.7 – is [...]
I am new to Oracle forms and am faced with a problem. For records of a certain type, instead of updating the current record with the values in the form items, I am creating a new record in the table with the same values, but with a new sequence number (the primary key is a [...]
I’m frustrated as when I’m outside of my home I cant often receive and never send emails using Outlook. I have an operator who checks something which doesn’t corrispond. When I am in a firm I’m connected on the network. Could you help on this issue.
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]
I’ve created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev 16: RESTORE [...]
We are writing to a QSAM output file which we will require in case of an abend. The problem we are faced with is – what happens if the job abends prior to all the records in the QSAM buffer being physically written to the QSAM output file. Are there any JCL statements that can [...]
How do I capture the user name and date of when a specific field was last edited on my form? I know how to capture when the entire form is edited and saved.
Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik
Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik





