Please help with SQL query
I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in [...]
Answer Question
| October 19, 2012 6:28 PM
Embedded SQL in AS/400
I have a file which has 6 different account numbers. For each of this account number, I need to check in File1 which has account number, security and Quantity. I need to sum up the qty field for a combination of Acc num and security. Once I get the security, I need to search in [...]
Answer Question
| October 19, 2012 6:28 PM
Embedded SQL in AS/400
sophos
I have always problem wih sophos.
Answer Question
| October 19, 2012 5:48 PM
Anti-malware, Antivirus, Sophos
I have always problem wih sophos.
Answer Question
| October 19, 2012 5:48 PM
Anti-malware, Antivirus, Sophos
Apple application developer certificate
I own mountain lion on my mac and tried to open an app from a unidentified developer. Particularly to protect my identity because of work I do in democratic struggle in Mexico. I´m talking about the Tor browser. is there any way around this problem. any suggestions?
Answer Question
| October 22, 2012 5:21 PM
Mac OS X
I own mountain lion on my mac and tried to open an app from a unidentified developer. Particularly to protect my identity because of work I do in democratic struggle in Mexico. I´m talking about the Tor browser. is there any way around this problem. any suggestions?
Answer Question
| October 22, 2012 5:21 PM
Mac OS X
unwanted copy of Calendar 2010 invitation
I receive a copy of all invitations sent to a co-worker. We each share our calendar with the other. How do I disable this feature?
Answer Question
| October 19, 2012 4:30 PM
INVITATION, Microsoft Outlook Calendar 2010
I receive a copy of all invitations sent to a co-worker. We each share our calendar with the other. How do I disable this feature?
Answer Question
| October 19, 2012 4:30 PM
INVITATION, Microsoft Outlook Calendar 2010
What is the security risk to install IIS on our Domain Controllers with a web redirect ?
Management wants our inside users to access www.domain.com by typing http://domain.com, what is the risk to install IIS on our DCs and do a web redirect ?
Answer Question
| October 19, 2012 3:55 PM
Active Directory 2008
Management wants our inside users to access www.domain.com by typing http://domain.com, what is the risk to install IIS on our DCs and do a web redirect ?
Answer Question
| October 19, 2012 3:55 PM
Active Directory 2008
Port Activity
Using the command NETSTAT option 3. I can not see port 443 nor 80 to check activity. Is it only seen once active? How will I be able activate if necessary? Thanks
Answer Question
| October 19, 2012 3:38 PM
NETSAT
Using the command NETSTAT option 3. I can not see port 443 nor 80 to check activity. Is it only seen once active? How will I be able activate if necessary? Thanks
Answer Question
| October 19, 2012 3:38 PM
NETSAT
VBA to copy sent email subject and to fields
We use a Corel X5 macro along with Outlook 2007&2010 here to send or “export” drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and “TO” fields to a [...]
Answer Question
| October 19, 2012 3:15 PM
CorelDRAW, Macros, outlook2010, outloook 2007, VBA
We use a Corel X5 macro along with Outlook 2007&2010 here to send or “export” drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and “TO” fields to a [...]
Answer Question
| October 19, 2012 3:15 PM
CorelDRAW, Macros, outlook2010, outloook 2007, VBA
Unwanted connection to internet
At varying times during operating my computer (and sometimes when no one is logged on)a ‘mysterious’ signal…i.e. sometimes music and sometimes talk comes on?
Answer Question
| October 22, 2012 3:13 PM
Internet connection
At varying times during operating my computer (and sometimes when no one is logged on)a ‘mysterious’ signal…i.e. sometimes music and sometimes talk comes on?
Answer Question
| October 22, 2012 3:13 PM
Internet connection
XML-INTO with allowmissing option
if I use the xml-into command with allowmissing=yes, how can I tell if I recieved a tag name? allowmissing=yes will prevent it from giving an error but I want to know which tags I recieved. allowmissing=no will tell me I didn’t get all my fields but I want to know which one I did receive. [...]
Answer Question
| October 19, 2012 3:07 PM
allowmissing, XML-INTO
if I use the xml-into command with allowmissing=yes, how can I tell if I recieved a tag name? allowmissing=yes will prevent it from giving an error but I want to know which tags I recieved. allowmissing=no will tell me I didn’t get all my fields but I want to know which one I did receive. [...]
Answer Question
| October 19, 2012 3:07 PM
allowmissing, XML-INTO
DASD storage levels
Is there a recommended storage level percentage for optimum performance / cost ? Obviously I realise there are lots of factors to take into consideration, such as projected growth, disk sizes / arms, I/O etc. But with all these catered for should I be looking at something around 75% or say 50%? 50% would seem [...]
Answer Question
| October 19, 2012 2:48 PM
DASD, Storage
Is there a recommended storage level percentage for optimum performance / cost ? Obviously I realise there are lots of factors to take into consideration, such as projected growth, disk sizes / arms, I/O etc. But with all these catered for should I be looking at something around 75% or say 50%? 50% would seem [...]
Answer Question
| October 19, 2012 2:48 PM
DASD, Storage
Using a template to adjust existing word documents
I have word documents that are generated by a program and autofill in a word document. My problem is that the program messes up the spacing and layout of the document in doing so. My question is, is there any way to build a template to apply to these documents once they have been created [...]
Answer Question
| October 22, 2012 2:37 PM
Microsoft Word 2010, Microsoft Word documents
I have word documents that are generated by a program and autofill in a word document. My problem is that the program messes up the spacing and layout of the document in doing so. My question is, is there any way to build a template to apply to these documents once they have been created [...]
Answer Question
| October 22, 2012 2:37 PM
Microsoft Word 2010, Microsoft Word documents
Citrix and VDI_in _a_BOX
Hi Guys , I intend to deploy VDI-in-a-Box solution in combination with NetScalre Access Gateway and HP Thin-Client, could anyone please advise me to know the best solution and let me know if you have better solution over this situation. Also please let me know about Thin-Client Hardware Compatibility and advise me what HP part [...]
Answer Question
| October 19, 2012 1:23 PM
cloud
Hi Guys , I intend to deploy VDI-in-a-Box solution in combination with NetScalre Access Gateway and HP Thin-Client, could anyone please advise me to know the best solution and let me know if you have better solution over this situation. Also please let me know about Thin-Client Hardware Compatibility and advise me what HP part [...]
Answer Question
| October 19, 2012 1:23 PM
cloud
Message file within message subfile
I have created a message file and now i want to link my message file to the DDS. Please suggest any way….
Answer Question
| October 19, 2012 12:25 PM
AS/400 Subfiles
I have created a message file and now i want to link my message file to the DDS. Please suggest any way….
Answer Question
| October 19, 2012 12:25 PM
AS/400 Subfiles
System i Navigator Run SQL Script block CL commands
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.
Answer Question
| October 19, 2012 11:53 AM
CL command, IBM, iNavigator, Sql Script
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.
Answer Question
| October 19, 2012 11:53 AM
CL command, IBM, iNavigator, Sql Script
LTE network testing
Given that we a laptop, ZTE MF820 modem and an LTE base station – what measurements can be made in order to test an LTE network? These are trivial: Upload speed [Mbps], Download speed [Mbps], Signal strength [dB] depending on the distance from the base station, Lattency [ms]. What about the security tests? Spectrum maybe? [...]
Answer Question
| October 19, 2012 9:05 AM
4G, LTE, test
Given that we a laptop, ZTE MF820 modem and an LTE base station – what measurements can be made in order to test an LTE network? These are trivial: Upload speed [Mbps], Download speed [Mbps], Signal strength [dB] depending on the distance from the base station, Lattency [ms]. What about the security tests? Spectrum maybe? [...]
Answer Question
| October 19, 2012 9:05 AM
4G, LTE, test
File read
I have a file1 with a field account number. Accnum A B C I have another file2 with field Accnum, Security and Qty AccNum Security Qty A X 1 A X 3 A Y 2 A Y 3 Now I need to generate a summary file like this by summing up the quantity for those [...]
Answer Question
| October 19, 2012 6:59 AM
AS/400
I have a file1 with a field account number. Accnum A B C I have another file2 with field Accnum, Security and Qty AccNum Security Qty A X 1 A X 3 A Y 2 A Y 3 Now I need to generate a summary file like this by summing up the quantity for those [...]
Answer Question
| October 19, 2012 6:59 AM
AS/400
List of objects
Hi.. I got to create a pf which will have list of objects present in all the user libraries availabe. When i use DSPOBJD, the server gets struck. DSPOBJD works fine when a specified library is specified. But in order to get all the objects, is there anyother options?
Answer Question
| October 19, 2012 5:46 AM
DSPOBJD, object, Outfile, RPG, RPGLE
Hi.. I got to create a pf which will have list of objects present in all the user libraries availabe. When i use DSPOBJD, the server gets struck. DSPOBJD works fine when a specified library is specified. But in order to get all the objects, is there anyother options?
Answer Question
| October 19, 2012 5:46 AM
DSPOBJD, object, Outfile, RPG, RPGLE
Figured out – Adminp Rename Process – Administrative Server connection?
Appeared to be an ACL issue. Made sure Primary Admin server was in ACL of Domino Directory and in Admin database. I have a java agent with the following code to start the rename process. noteid = aprename.renameWebUser(oldname,tlname, NewLast, First, NewMiddle,“*”, “*”); When the Domino Directory Administrative server is available(can connect), it works fine. But [...]
Answer Question
| October 19, 2012 8:12 PM
Administraion, AdminP, Lotus Domino, Lotus Domino 8.5.2
Appeared to be an ACL issue. Made sure Primary Admin server was in ACL of Domino Directory and in Admin database. I have a java agent with the following code to start the rename process. noteid = aprename.renameWebUser(oldname,tlname, NewLast, First, NewMiddle,“*”, “*”); When the Domino Directory Administrative server is available(can connect), it works fine. But [...]
Answer Question
| October 19, 2012 8:12 PM
Administraion, AdminP, Lotus Domino, Lotus Domino 8.5.2
How to capture decimal value of numeric fld
I need a way to capture the decimal value of a numeric field (i.e. 5.78). Need a way to be able to break the decimal value away to do computations on it. How do I achieve this using RPG III coding techniques?
Answer Question
| October 18, 2012 6:50 PM
RPG
I need a way to capture the decimal value of a numeric field (i.e. 5.78). Need a way to be able to break the decimal value away to do computations on it. How do I achieve this using RPG III coding techniques?
Answer Question
| October 18, 2012 6:50 PM
RPG
Disaster recovery exercise steps for AS400
Hello..would like to know what are the steps for a disaster recovery exercise on as400?
Answer Question
| October 18, 2012 3:28 PM
AS400 admin
Hello..would like to know what are the steps for a disaster recovery exercise on as400?
Answer Question
| October 18, 2012 3:28 PM
AS400 admin
