i want to create an index for a view so the the the individual record can be assessed faster.

You can create an index with no concern about any view.

It doesn’t have to be “for a view”. SQL will use the index the same way. It wouldn’t be any faster if it was “for a view”.

Tom

Physical checking is necessary as my opinion like nic, lan cable etc etc…. as u mentioned only one has this kind of probs ! Is it possible to test with a cross cable that happens only two pcs connecting a wire with this cable’s both ends and then ping each of them with their IP. I am not sure but u can do a try.

I transfered the database output into excel file using CPYTOIMP command…

The CPYTOIMPF command cannot create Excel files. It can create .CSV files that can be imported into Excel; and then Excel can put its output into an Excel file.

But SNDDST cannot send Excel files through e-mail unless you have properly encoded them first. If you are really sending Excel files, what did you use for the encoding?

Tom

PRBAR is called with four parameters. It’s called multiple times to pass different key pieces of information like height, position, data, etc. The bar code prints on the open document of the callling program.
Parameters:
1. printfile name 10a
2 key word such as “position” 10a
3 information pertaining to keyword 10a or 80a I forget
4. 2 position code. blanks 2a

I can call it from a command line with the 4 parameters and get the same error msg.

I resolved the issue. The program did have an internally described printfile like qsysprt. I referred to the cobol manuals and changed the code to use an externally defined printfile. Once you told me it was s/36, I understood and I decided to get away from that type of programming.
Thanks again for your response.

You can not delete a PF while there is a LF over it. You can delete the object FL code then delete the PF. The LF can be recomplied later.

This question is about Lotus Notes Archiving, but the answer refers to MS Outlook Archives!!!

In Notes 8, you can Open your existing Archive, go to Actions, Archive, Create Criteria. In this dialog, you can set the name of the file and location of your new archive, create a selection criteria and enable it. Then you go to Actions, Archive, Archive Now to use the recently created criteria. This will preserve your old archive’s folder structure.
From there, you can select further documents that you’d like to archive (and were not included in your Criteria), and drag them to your new archive.

may this could suggest to ur answer

NANAK, you can’t create indexes on views.

Your best bet would be to create appropriate indexes on the underlying tables, to make sure your view’s query runs fast.

As a matter of fact, you cannot rename any User profiles. I agree with the rest of the comments. best way to satisy Audit requirements for QSECOFR is to not use and have diabled with password secured in a secure environment with only Security officer having access. Use a duplicate of QSECOFR as a different profile with same authorities for the Security officer to Use on a daily basis if needed.

what is the Difference between windows server 2003 server & windows server 2008 . highlight the point

All PCs are in domain..it was working properly. I am facing this issue from last 2 weeks only.one of them i have tried disjointed from domain to test whether it is domain policy issue.

please i am using an oracle database

please i also have a familiar issue.

i want to create an index for a view so the the the individual record can be assessed faster. but i know that the view takes it data from from the author table. please how do i do this

regrettably no one has answered but i’m just happy i just found it
when you are viewing the archived message folders, at the left bar (lotus notes 6.5) below the folders tree, there is a green area with 3 icons: one of them is the (archived) calendar!!!

SpiceWorks has a pretty good one:

http://www.spiceworks.com/free-network-mapping-software/

If you make the second server a DC (domain controller) the AD is automatically replicated to it.

Look at the original program source and find the lines in th eO specs that reference those indicators.
Or in the C specs to see if those indicators are used to condition outpuit.

That should solve your mystery

After changing those identified indicators OFF status in the O specification the printing of BLANK line between each row is stopped. I am just not sure on this fix which was handled by another consultant.

Try out the following….just enter sql command line and do the rest !
conn / as sysdba

alter user system identified by manager; (ucan type as ur desire instead of manager)

it shows like user altered. Next try the same action.

Though I believe u may know the db SYS pass however.

Hi,

I am trying to delete folders which are 3 days old. Folder size is more than 400MB. There are around 6-7 folders in this location. But the script i tried is deleting 1-2 folders.
I have used the below code in my VBS file.

strFolderPath = “C:TestBuilds” ‘Folder Path
strLogFolderPath=”C:TestBuildsLogs”
NumberOfDays = 3 ‘Anything older than this many days will be removed

On Error Resume Next
Dim fso,objFolder,objFile,objSubfolder,objLogFolder
Set fso = CreateObject(“Scripting.FileSystemObject”)
Set objFolder = fso.GetFolder(strFolderPath)
Set objLogFolder = fso.GetFolder(strLogFolderPath)

‘DELETE all subfolders in Folder Path older than Number of days
For Each objSubfolder In objFolder.Subfolders
If objSubFolder.Name = “Logs” Then
‘ Set objSubFolder= Nothing
Else If DateDiff(“d”, objSubfolder.DateCreated,Now) > NumberOfDays Then
objSubfolder.Delete True
Wait 20
End If
End If
Next

‘Delete all the folders in Log folder
For Each objSubfolder In objLogFolder.Subfolders
If DateDiff(“d”, objSubfolder.DateCreated,Now) > NumberOfDays*5 Then
objSubfolder.Delete True
End If
Next

Set fso=Nothing
Set objFolder=Nothing
Set objLogFolder=Nothing
Set objSubfolder=Nothing

Can anyone suggest me on this.

- Durga Prasad