USING INDEX
From all the givens, don’t understand why B is the correct answer. There is no prior index on the table according to the exhibit. Please explain. Thanks View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table: ALTER TABLE emp [...]
Answer Question
| October 30, 2012 9:33 PM
USING INDEX
From all the givens, don’t understand why B is the correct answer. There is no prior index on the table according to the exhibit. Please explain. Thanks View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table: ALTER TABLE emp [...]
Answer Question
| October 30, 2012 9:33 PM
USING INDEX
AS/400 model 9402 won’t power on
Our company has an AS/400 model 9402 that was manually shutdown due to an extreme storm. We cannot turn the system back on. The system attention light is lit and system will not power on. Any help would be GREATLY appreciated.
Answer Question
| October 31, 2012 8:53 PM
AS/400, AS/400 system administration
Our company has an AS/400 model 9402 that was manually shutdown due to an extreme storm. We cannot turn the system back on. The system attention light is lit and system will not power on. Any help would be GREATLY appreciated.
Answer Question
| October 31, 2012 8:53 PM
AS/400, AS/400 system administration
Trying to copy a string to the clipboard in an Outlook 2007 script
I’m building a script that will be triggered by a rule from Outlook 2007. The script is looking for a specific string in the body of the message and extracting some text. I’d like to copy that text into the clipboard to use it in another application. Here is my code: Sub SaveAsText(MyMail As MailItem) [...]
Answer Question
| October 31, 2012 7:43 PM
Microsoft Outlook 2007, Microsoft Outlook script
I’m building a script that will be triggered by a rule from Outlook 2007. The script is looking for a specific string in the body of the message and extracting some text. I’d like to copy that text into the clipboard to use it in another application. Here is my code: Sub SaveAsText(MyMail As MailItem) [...]
Answer Question
| October 31, 2012 7:43 PM
Microsoft Outlook 2007, Microsoft Outlook script
DSPLY SQL value is zeros
I am trying to display the 2 result values from this SQL statement and they are zeros: D totdlq S 11 2 inz(0) D totcnt S 5 0 inz(0) * D totdel S 20a D totrec S 10a /Free Exec sql DECLARE C1 CURSOR FOR DynSqlStmt; Exec sql open C1; Exec sql Select sum(utcbal), count(*) [...]
Answer Question
| October 30, 2012 7:19 PM
AS400 - Embedded SQL
I am trying to display the 2 result values from this SQL statement and they are zeros: D totdlq S 11 2 inz(0) D totcnt S 5 0 inz(0) * D totdel S 20a D totrec S 10a /Free Exec sql DECLARE C1 CURSOR FOR DynSqlStmt; Exec sql open C1; Exec sql Select sum(utcbal), count(*) [...]
Answer Question
| October 30, 2012 7:19 PM
AS400 - Embedded SQL
LAN
In a LAN running TCP/IP evey computer has both an IP address and a what?
Answer Question
| October 30, 2012 7:14 PM
Windows 7 and Vista
In a LAN running TCP/IP evey computer has both an IP address and a what?
Answer Question
| October 30, 2012 7:14 PM
Windows 7 and Vista
Lotus notes signature’s problem, characters don’t match
Hello all, could you please help me to solve problem with my signature? The problem is that loaded signature doesn’t have the same size of characters like signature saved in MS word. The procedure I created and loaded signature was base on instruction. I don’t always want to edit it before sending. thanks
Answer Question
| October 30, 2012 3:50 PM
Lotus Notes, Lotus Notes Signatures
Hello all, could you please help me to solve problem with my signature? The problem is that loaded signature doesn’t have the same size of characters like signature saved in MS word. The procedure I created and loaded signature was base on instruction. I don’t always want to edit it before sending. thanks
Answer Question
| October 30, 2012 3:50 PM
Lotus Notes, Lotus Notes Signatures
Job Scheduler Authority
I have a operator that is unable to submit a job in the scheduler using the “Option 10 to Run Immediately”. He gets a error message “Not Authorized to user QSYSOPR” How do i authorize his group profile to user QSYSOPR? I’m not to familiar with the Job Scheduler and am looking for some help.
Answer Question
| October 30, 2012 3:25 PM
Authority, JOB SCHEDULER
I have a operator that is unable to submit a job in the scheduler using the “Option 10 to Run Immediately”. He gets a error message “Not Authorized to user QSYSOPR” How do i authorize his group profile to user QSYSOPR? I’m not to familiar with the Job Scheduler and am looking for some help.
Answer Question
| October 30, 2012 3:25 PM
Authority, JOB SCHEDULER
Convert a spool file into PDF
Is there any commands in AS/400 to convert a 53M spoll file into PDF.
Answer Question
| October 30, 2012 2:34 PM
pwopen12
Is there any commands in AS/400 to convert a 53M spoll file into PDF.
Answer Question
| October 30, 2012 2:34 PM
pwopen12
Subfile positioning while adding records
Hi, I am having problem in repositioning subfile when I add a record. Scenario is like my subfile is self extending and page size is 4 .Data is like a,b,d. Suppose i add e then it gets positioned to e and page up don’t work . It shows end of file found. Now if i [...]
Answer Question
| October 30, 2012 1:49 PM
AS/400, RPGLE
Hi, I am having problem in repositioning subfile when I add a record. Scenario is like my subfile is self extending and page size is 4 .Data is like a,b,d. Suppose i add e then it gets positioned to e and page up don’t work . It shows end of file found. Now if i [...]
Answer Question
| October 30, 2012 1:49 PM
AS/400, RPGLE
CPF3343
When I execute DLTSPLF command,I am getting an error CPF3343- Duplicate Job Names found and also it happens only for one USER .For rest of us, it works perfectly.Can you please help me in reolving this issue
Answer Question
| October 30, 2012 12:49 PM
CPF3343
When I execute DLTSPLF command,I am getting an error CPF3343- Duplicate Job Names found and also it happens only for one USER .For rest of us, it works perfectly.Can you please help me in reolving this issue
Answer Question
| October 30, 2012 12:49 PM
CPF3343
Sharepoint 3.0 website no longer working after Windows updates installed
We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error : Failed to upgrade SharePoint Products [...]
Answer Question
| October 30, 2012 12:40 PM
SharePoint, SQL Express 2005, Windows Server 2003
We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error : Failed to upgrade SharePoint Products [...]
Answer Question
| October 30, 2012 12:40 PM
SharePoint, SQL Express 2005, Windows Server 2003
Changed external data structure
I have RPG program P1 which has an external data structure D1 on a file F1. I am reading the file F1 in PGM A and based on a condition I am calling PGM B. In PGM B I am updating a field of the file F1.When the control returns to PGM A, the updated field [...]
Answer Question
| October 30, 2012 12:01 PM
PGM, RPG Program
I have RPG program P1 which has an external data structure D1 on a file F1. I am reading the file F1 in PGM A and based on a condition I am calling PGM B. In PGM B I am updating a field of the file F1.When the control returns to PGM A, the updated field [...]
Answer Question
| October 30, 2012 12:01 PM
PGM, RPG Program
*ALLOBJ
Hi, I need to create an ID, the main condition is that he should not have any special authorities(especially *allobj ). where he should be able to access (Read and write only ) for some library and its objects (more than 10 libraries and 20000 objects). Where those libraries and its objects are in exclude [...]
Answer Question
| October 30, 2012 11:44 AM
*ALLOBJ, AS/400 v6r1
Hi, I need to create an ID, the main condition is that he should not have any special authorities(especially *allobj ). where he should be able to access (Read and write only ) for some library and its objects (more than 10 libraries and 20000 objects). Where those libraries and its objects are in exclude [...]
Answer Question
| October 30, 2012 11:44 AM
*ALLOBJ, AS/400 v6r1
Blackberry 9300
I have a second hand BlackBerry 9300 and every time I charge it, it switches off without any warning. I’ve tried taking out my SIM card and charging but it is still the same issue. I’m not sure if the problem is with my phone or the charger.
Answer Question
| October 30, 2012 10:55 AM
Blackberry 9300, SIM card
I have a second hand BlackBerry 9300 and every time I charge it, it switches off without any warning. I’ve tried taking out my SIM card and charging but it is still the same issue. I’m not sure if the problem is with my phone or the charger.
Answer Question
| October 30, 2012 10:55 AM
Blackberry 9300, SIM card
IMPORT OR EXCEL DATA INTO ORACLE FORMS 6I
Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger. can any one help me in this regard with source code. thanks a lot in advance
Answer Question
| October 30, 2012 9:55 AM
EXCEL DATA, Import, Oracle 6i
Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger. can any one help me in this regard with source code. thanks a lot in advance
Answer Question
| October 30, 2012 9:55 AM
EXCEL DATA, Import, Oracle 6i
Mail sent from BlackBerry
Sometimes, when a mail is sent from BlackBerry, it can not be read in Lotus Notes 7 client. When try to open mail in Notes, message pop up and say something like: this mail can not be read in this version of Notes. On BlackBerry Enterprise server is installed Lotus Domino 8.5.1 Any solution?
Answer Question
| October 30, 2012 9:13 AM
BlackBerry Enterprise Server, Lotus Domino 8.5.1, Lotus Notes 7
Sometimes, when a mail is sent from BlackBerry, it can not be read in Lotus Notes 7 client. When try to open mail in Notes, message pop up and say something like: this mail can not be read in this version of Notes. On BlackBerry Enterprise server is installed Lotus Domino 8.5.1 Any solution?
Answer Question
| October 30, 2012 9:13 AM
BlackBerry Enterprise Server, Lotus Domino 8.5.1, Lotus Notes 7
VPN: LAN access
Hi, I use to connect to my customer VPN with Cisco Anyconnect VPN Client (v. 2.4.1012). While connected I can’t use internet, outlook, … The VPN administrator told me that the VPN is configured in this way and the rule cannot be modified for policy reason. I’m sure that there is a workaround for this [...]
Answer Question
| October 30, 2012 9:10 AM
Cisco VPN, Cisco VPN Client
Hi, I use to connect to my customer VPN with Cisco Anyconnect VPN Client (v. 2.4.1012). While connected I can’t use internet, outlook, … The VPN administrator told me that the VPN is configured in this way and the rule cannot be modified for policy reason. I’m sure that there is a workaround for this [...]
Answer Question
| October 30, 2012 9:10 AM
Cisco VPN, Cisco VPN Client
AD report
Hi I need to get all the mobile numbers for all the users in a region. What is the easiest way to do this. There are different OU’s for the different companies in the organization. but i need only the one region info not the whole company. regards rey
Answer Question
| October 30, 2012 8:51 AM
Active Directory 2008
Hi I need to get all the mobile numbers for all the users in a region. What is the easiest way to do this. There are different OU’s for the different companies in the organization. but i need only the one region info not the whole company. regards rey
Answer Question
| October 30, 2012 8:51 AM
Active Directory 2008
Exchange Questions
Kindly give me my below questions answers We have One DC (XYZ.Com) and one Exchange server, If my main DC will goes down what happend in exchange ? Same setup and my DNS Server goes down then which problem we will face?
Answer Question
| October 30, 2012 7:33 AM
Exchange Server 2007, Exchange Server 2010 Administration
Kindly give me my below questions answers We have One DC (XYZ.Com) and one Exchange server, If my main DC will goes down what happend in exchange ? Same setup and my DNS Server goes down then which problem we will face?
Answer Question
| October 30, 2012 7:33 AM
Exchange Server 2007, Exchange Server 2010 Administration
Data in Dump
I have got a dump file of a program which went to message wait last month. From the dump I got to know the value of a field as ‘Asset’. I would like to know there can be a possibility that data is ‘ASSET’ but displayed in dump as ‘Asset’?
Answer Question
| October 30, 2012 4:42 AM
AS/400
I have got a dump file of a program which went to message wait last month. From the dump I got to know the value of a field as ‘Asset’. I would like to know there can be a possibility that data is ‘ASSET’ but displayed in dump as ‘Asset’?
Answer Question
| October 30, 2012 4:42 AM
AS/400
