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
Do until loop help!
I’m trying to figure out how to produce an error message if the person doesn’t enter an actual string when prompted to enter a product code. If they enter the empty string or push okay/cancel without entering the right product code a msgbox is supposed to pop up. I can’t figure it out! This is [...]
Answer Question
| October 29, 2012 10:40 PM
DO LOOP statement, Input box Question, MsgBox
I’m trying to figure out how to produce an error message if the person doesn’t enter an actual string when prompted to enter a product code. If they enter the empty string or push okay/cancel without entering the right product code a msgbox is supposed to pop up. I can’t figure it out! This is [...]
Answer Question
| October 29, 2012 10:40 PM
DO LOOP statement, Input box Question, MsgBox
Phone answer message
How do I have a message for incoming phone calls?
Answer Question
| October 29, 2012 7:03 PM
Phone messages, Phone systems
How do I have a message for incoming phone calls?
Answer Question
| October 29, 2012 7:03 PM
Phone messages, Phone systems
CO-PA Value field maintenance
How does one change the description of a unused CO-PA Value field that been transported to production in ECC6 or ultimate how can one delete this unused Value. field. No values have been posted to it yet.
Answer Question
| October 29, 2012 2:58 PM
CO-PA, SAP ECC 6
How does one change the description of a unused CO-PA Value field that been transported to production in ECC6 or ultimate how can one delete this unused Value. field. No values have been posted to it yet.
Answer Question
| October 29, 2012 2:58 PM
CO-PA, SAP ECC 6
