SAP list of performed transactions by users in a month.
For a couple of days I’m trying to figure out how to create a list with the following elements for each month: User -> Role -> Transactions -> Steps I’m aware of the ST03 transaction which show me the amount of steps per user or per transactions for each months. The issue with this is [...]
Answer Question
| April 20, 2012 7:33 PM
SAP, SAP Transactions
For a couple of days I’m trying to figure out how to create a list with the following elements for each month: User -> Role -> Transactions -> Steps I’m aware of the ST03 transaction which show me the amount of steps per user or per transactions for each months. The issue with this is [...]
Answer Question
| April 20, 2012 7:33 PM
SAP, SAP Transactions
Select Criteria
I want to pull data from Item Descriptions utilizing only certain words within the description; i.e., Vesuvio Beige Hand Board. I want to pull all records with the words “Hand Board” in the description and I’m having trouble getting that to happen. I’ve tried “is like”, “in” and everything else I can think of, but [...]
Answer Question
| April 20, 2012 7:19 PM
Crystal Reports 8, Crystal Reports Database
I want to pull data from Item Descriptions utilizing only certain words within the description; i.e., Vesuvio Beige Hand Board. I want to pull all records with the words “Hand Board” in the description and I’m having trouble getting that to happen. I’ve tried “is like”, “in” and everything else I can think of, but [...]
Answer Question
| April 20, 2012 7:19 PM
Crystal Reports 8, Crystal Reports Database
Creating Internet Backup on my W2K3 R2 DNS server
I have application running on the server , If for some reason if i shutdown the server , all my clients Internet will go down, I have an additional server which i just move 2K8 which i wanted to use and setup for internet so if my 2K3 server is down it won’t effect internet [...]
Answer Question
| April 20, 2012 5:53 PM
Windows Server 2003 R3, Windows Server 2008
I have application running on the server , If for some reason if i shutdown the server , all my clients Internet will go down, I have an additional server which i just move 2K8 which i wanted to use and setup for internet so if my 2K3 server is down it won’t effect internet [...]
Answer Question
| April 20, 2012 5:53 PM
Windows Server 2003 R3, Windows Server 2008
unable to see new folder in outlook when in cache mode
We have a mailbox which is shared and many users have access to this mailbox, the problem when the user has a cache mode in outlook and creates a folder in this mailbox it doesn’t appear and user have to unmount the mailbox and close the outlook and remount the mailbox and then you can [...]
Answer Question
| May 31, 2012 2:03 PM
Microsoft Exchange 2007, Microsoft Outlook 2007
We have a mailbox which is shared and many users have access to this mailbox, the problem when the user has a cache mode in outlook and creates a folder in this mailbox it doesn’t appear and user have to unmount the mailbox and close the outlook and remount the mailbox and then you can [...]
Answer Question
| May 31, 2012 2:03 PM
Microsoft Exchange 2007, Microsoft Outlook 2007
Want Query output into Spool file
Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the [...]
Answer Question
| April 23, 2012 12:29 PM
CLLE, RUNQRY, Spool file
Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the [...]
Answer Question
| April 23, 2012 12:29 PM
CLLE, RUNQRY, Spool file
Windows Server 2003 R2 restarts at/before logon
The Server was working fine but either due to some software installed it started giving problems removed all extra softwares and had just the os, msoffice and symantech end point installed still it gave problems, so uninstalled symantec end point security and the server started working fine again, on again installing and activating the antivirus [...]
Answer Question
| April 20, 2012 11:48 AM
Windows Server 2003 error messages, Windows Server 2003 R2
The Server was working fine but either due to some software installed it started giving problems removed all extra softwares and had just the os, msoffice and symantech end point installed still it gave problems, so uninstalled symantec end point security and the server started working fine again, on again installing and activating the antivirus [...]
Answer Question
| April 20, 2012 11:48 AM
Windows Server 2003 error messages, Windows Server 2003 R2
Can I change c0001copybook in RPG?
in rpg c0001 is a standard copybook.if i want to make a new program then can i use this copybook.and for my program some modification is necessary…so can i change this copybook program
Answer Question
| April 20, 2012 8:07 AM
AS400 - Copy Book, RPG
in rpg c0001 is a standard copybook.if i want to make a new program then can i use this copybook.and for my program some modification is necessary…so can i change this copybook program
Answer Question
| April 20, 2012 8:07 AM
AS400 - Copy Book, RPG
how to install Linux with Windows 7 ?
how to install Linux with windows 7. i have win 7 i want to install Linux what i have to do ?
Answer Question
| June 1, 2012 3:59 AM
Linux, Windows 7
how to install Linux with windows 7. i have win 7 i want to install Linux what i have to do ?
Answer Question
| June 1, 2012 3:59 AM
Linux, Windows 7
2 Dimensional Array in RPGLE
How do I define and use a 2 dimensional array in RPGLE? I have to add up to 10 contracts from one file and order sequence numbers for every item on an order that belongs to a one of those contracts and then write each of those contract/sequences to it’s own order. I am lost [...]
Answer Question
| May 1, 2012 6:37 PM
iSeries RPGLE, RPGLE array
How do I define and use a 2 dimensional array in RPGLE? I have to add up to 10 contracts from one file and order sequence numbers for every item on an order that belongs to a one of those contracts and then write each of those contract/sequences to it’s own order. I am lost [...]
Answer Question
| May 1, 2012 6:37 PM
iSeries RPGLE, RPGLE array
CPYFRMIMPF Issue
I am trying to copy data from a .txt file to a physical file and I keep receiving an error code 7. My text file is not delimited at all, but my physical file is composed of about 20 separate fields. Does my ‘from file’ have to be delimited to use this command? Is that [...]
Answer Question
| April 23, 2012 6:06 PM
AS/400, CL, CPYFRMIMPF
I am trying to copy data from a .txt file to a physical file and I keep receiving an error code 7. My text file is not delimited at all, but my physical file is composed of about 20 separate fields. Does my ‘from file’ have to be delimited to use this command? Is that [...]
Answer Question
| April 23, 2012 6:06 PM
AS/400, CL, CPYFRMIMPF
Archive folder for user
I created an archive .pst file for user. Something happened and all of the e-mails and subfolders did not get moved. I do not know how to get these e-mails back. Any suggestions. Is there a way to get them off of the exchange server?
Answer Question
| May 31, 2012 4:29 PM
.PST files, Microsoft Exchange 2007
I created an archive .pst file for user. Something happened and all of the e-mails and subfolders did not get moved. I do not know how to get these e-mails back. Any suggestions. Is there a way to get them off of the exchange server?
Answer Question
| May 31, 2012 4:29 PM
.PST files, Microsoft Exchange 2007
Error trying to call PRG
i was try to call a prg, but im getting the error which given as follows ( Job 352272/RPANNEER/QPADEV000R started on 19/04/12 at 17:06:00 in subsystem User library list not set properly. Press Enter or Help(review reason). im having all the authority to access all obj as a secoff and the object having public authority [...]
Answer Question
| April 22, 2012 3:27 PM
AS/400, as400 cllp, PRG
i was try to call a prg, but im getting the error which given as follows ( Job 352272/RPANNEER/QPADEV000R started on 19/04/12 at 17:06:00 in subsystem User library list not set properly. Press Enter or Help(review reason). im having all the authority to access all obj as a secoff and the object having public authority [...]
Answer Question
| April 22, 2012 3:27 PM
AS/400, as400 cllp, PRG
error in grid xml: each dimension must be used once and only once
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]
Answer Question
| April 19, 2012 1:52 PM
Hyperion, Microsoft Excel, XML
Hello, I’ve got problem on one workstation with installed Hyperion version 9.2.1.0.0.002 Add-in for Excel. When we run Refresh of sheet full of HsGetValue formulas we can’t get data. It shows #NAZEV? instead numbers and popups Error window ‘Hyperion Smartview for Office’ with message “Error in grid xml: each dimension must be used once and [...]
Answer Question
| April 19, 2012 1:52 PM
Hyperion, Microsoft Excel, XML
convert report to excel without convater
Is it possible to convert a 10g generated report to excel without excel convater?
Answer Question
| April 19, 2012 9:13 AM
Microsoft Excel, Oracle 10g
Is it possible to convert a 10g generated report to excel without excel convater?
Answer Question
| April 19, 2012 9:13 AM
Microsoft Excel, Oracle 10g
uninstall program
I downloaded a free version of Pc Performer from PerformerSoft.LLC. As a pensioner I do not want to purchase the full program. Its not for me. I have tried to uninstall theough Control Panel. (I know how to do this) I get this error message. C:ProgramFilesPC Performerinins.ooo.msg I have emaild the company but they have [...]
Answer Question
| April 19, 2012 8:22 AM
PC Performer, VMware
I downloaded a free version of Pc Performer from PerformerSoft.LLC. As a pensioner I do not want to purchase the full program. Its not for me. I have tried to uninstall theough Control Panel. (I know how to do this) I get this error message. C:ProgramFilesPC Performerinins.ooo.msg I have emaild the company but they have [...]
Answer Question
| April 19, 2012 8:22 AM
PC Performer, VMware
Transform rows to files in an SQL statement.
Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT from table CLIENTES (sql against qsys2/syscolumns). SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = ‘CLIENTES’ AND TABLE_SCHEMA = ‘MANEL’ Observe vertical orientation. Column 1 Column 2 xhrname Name xhrsurname Last Name Now I would like to join this [...]
Answer Question
| April 20, 2012 8:15 AM
AS/400, SQL, SQL statement
Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT from table CLIENTES (sql against qsys2/syscolumns). SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = ‘CLIENTES’ AND TABLE_SCHEMA = ‘MANEL’ Observe vertical orientation. Column 1 Column 2 xhrname Name xhrsurname Last Name Now I would like to join this [...]
Answer Question
| April 20, 2012 8:15 AM
AS/400, SQL, SQL statement
access restriction on my Linksys
Hi Dear Team members, i’m currently working as an IT and system administrator i have implement a windows 2003 server just for file and DHCP, i’m using a Linksys as my gateway, and 6 other Linksys router that i’m using as APs, i trying to set ACL on my gateway router but just when i [...]
Answer Question
| May 29, 2012 7:47 AM
ACL, Linksys Routers, Windows Server 2003
Hi Dear Team members, i’m currently working as an IT and system administrator i have implement a windows 2003 server just for file and DHCP, i’m using a Linksys as my gateway, and 6 other Linksys router that i’m using as APs, i trying to set ACL on my gateway router but just when i [...]
Answer Question
| May 29, 2012 7:47 AM
ACL, Linksys Routers, Windows Server 2003
As400 subdirectory
in as/400 we are using directory now i create one directory like ABC, later i create one more sub directory like XYZ It is looking Like ABC/XYZ i want to find XYZ sub directory is there are not , is there any comands to find subdirectory i use WRKLNK OBJ(ABC/XYZ) but i will open the [...]
Answer Question
| April 26, 2012 7:00 AM
AS/400, AS/400 Directory, WRKLNK
in as/400 we are using directory now i create one directory like ABC, later i create one more sub directory like XYZ It is looking Like ABC/XYZ i want to find XYZ sub directory is there are not , is there any comands to find subdirectory i use WRKLNK OBJ(ABC/XYZ) but i will open the [...]
Answer Question
| April 26, 2012 7:00 AM
AS/400, AS/400 Directory, WRKLNK
Receive Emails from ISP through Exchange Server 2007
How to configure Exchange 2007 to send and receive emails setup by ISP hosting my Email Domain.
Answer Question
| May 4, 2012 4:07 AM
Microsoft Exchange 200, SBS 2008
How to configure Exchange 2007 to send and receive emails setup by ISP hosting my Email Domain.
Answer Question
| May 4, 2012 4:07 AM
Microsoft Exchange 200, SBS 2008
Regarding message subfile
I have made a display file containing two subfiles.The first subfile is a load all scroll subfile and the second is a message subfile.The problem is that i am not able to display error message is message subfile while performing validations on data on first Load-all subfile.What could be the possible reasons.Thanks if you could [...]
Answer Question
| April 23, 2012 5:23 PM
AS/400, AS/400 Subfiles, IBM iSeries
I have made a display file containing two subfiles.The first subfile is a load all scroll subfile and the second is a message subfile.The problem is that i am not able to display error message is message subfile while performing validations on data on first Load-all subfile.What could be the possible reasons.Thanks if you could [...]
Answer Question
| April 23, 2012 5:23 PM
AS/400, AS/400 Subfiles, IBM iSeries
