AS400
If i have a pf (pf1) R Rec account 10p00 name 10a dept 1a salary 5p00 k account After Updating, I given dept- A, S, D different account, different salary. NOW I AM TRYING TO ADD SALARY ON DEPT WISE {FOR EXAMPLE- IN SQL, SELECT SUM(SALARY) FROM PF1 WHERE DEPT=’A'} BUT I AM TRYING IN [...]
Answer Question
| August 21, 2012 4:54 PM
AS400 RPGLE
If i have a pf (pf1) R Rec account 10p00 name 10a dept 1a salary 5p00 k account After Updating, I given dept- A, S, D different account, different salary. NOW I AM TRYING TO ADD SALARY ON DEPT WISE {FOR EXAMPLE- IN SQL, SELECT SUM(SALARY) FROM PF1 WHERE DEPT=’A'} BUT I AM TRYING IN [...]
Answer Question
| August 21, 2012 4:54 PM
AS400 RPGLE
CL PGM for full system save from the HMC
System info: OS/6.1, 9117-MMB-770. Can you run a full system save from the HMC in a CL pgm? here is my code so far: PGM DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&TAPE) TYPE(*CHAR) VALUE(TAP02) CHGJOB RUNPTY(19) JOBQ(QSYS/QCTL) LOG(0 00 *SECLVL) + LOGCLPGM(*YES) BRKMSG(*NOTIFY) + TIMESLICE(99999) CHGMSGQ MSGQ(*USRPRF) DLVRY(*HOLD) MONMSG MSGID(CPF2451) CHGMSGQ MSGQ(*WRKSTN) DLVRY(*NOTIFY) RTVSYSVAL SYSVAL(QDATE) RTNVAR(&DATE) [...]
Answer Question
| August 21, 2012 4:29 PM
Administration, Backup, iSeries
System info: OS/6.1, 9117-MMB-770. Can you run a full system save from the HMC in a CL pgm? here is my code so far: PGM DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&TAPE) TYPE(*CHAR) VALUE(TAP02) CHGJOB RUNPTY(19) JOBQ(QSYS/QCTL) LOG(0 00 *SECLVL) + LOGCLPGM(*YES) BRKMSG(*NOTIFY) + TIMESLICE(99999) CHGMSGQ MSGQ(*USRPRF) DLVRY(*HOLD) MONMSG MSGID(CPF2451) CHGMSGQ MSGQ(*WRKSTN) DLVRY(*NOTIFY) RTVSYSVAL SYSVAL(QDATE) RTNVAR(&DATE) [...]
Answer Question
| August 21, 2012 4:29 PM
Administration, Backup, iSeries
VBscript to send email on service failure
VBscript to send email on service failure
Answer Question
| August 21, 2012 4:19 PM
Email, VBScript, windows 2003
VBscript to send email on service failure
Answer Question
| August 21, 2012 4:19 PM
Email, VBScript, windows 2003
Outlook 2010 administration
How do I enable the use of clicking on a link in an e-mail?
Answer Question
| August 21, 2012 4:11 PM
Microsoft Outlook 2010, Microsoft Outlook features
How do I enable the use of clicking on a link in an e-mail?
Answer Question
| August 21, 2012 4:11 PM
Microsoft Outlook 2010, Microsoft Outlook features
How do I delete page breaks in a resume
I am trying to update my resume. I am unable to delete the page breaks set in document.
Answer Question
| August 21, 2012 4:06 PM
Microsoft Word, Microsoft Word features
I am trying to update my resume. I am unable to delete the page breaks set in document.
Answer Question
| August 21, 2012 4:06 PM
Microsoft Word, Microsoft Word features
Array In oracle
I have made one buyer project i want to add various items in only one buyers list. I want that the name of the buyer is not repeated every time but it includes all items… how can i do that?
Answer Question
| August 21, 2012 3:25 PM
Array, declaration and use of it
I have made one buyer project i want to add various items in only one buyers list. I want that the name of the buyer is not repeated every time but it includes all items… how can i do that?
Answer Question
| August 21, 2012 3:25 PM
Array, declaration and use of it
PO Vendors in SAP
Is there a way to identify those vendors that require a PO when processing invoices for payment?
Answer Question
| August 21, 2012 3:02 PM
SAP, SAP invoice
Is there a way to identify those vendors that require a PO when processing invoices for payment?
Answer Question
| August 21, 2012 3:02 PM
SAP, SAP invoice
Remote Connection to SQL 2005 Express running on Windows 7
I have a Windows 7 machine running SQL 2005 Express. I am able to connect to the SQL from the local machine. However, I am not able to connect from other machines. This machine will connect to a SQL 2005 running on Windows XP but the Windows XP will not connect to the Windows 7 [...]
Answer Question
| August 21, 2012 2:47 PM
Remote connection, SQL 2005 Express, windows 7 32 bit
I have a Windows 7 machine running SQL 2005 Express. I am able to connect to the SQL from the local machine. However, I am not able to connect from other machines. This machine will connect to a SQL 2005 running on Windows XP but the Windows XP will not connect to the Windows 7 [...]
Answer Question
| August 21, 2012 2:47 PM
Remote connection, SQL 2005 Express, windows 7 32 bit
Remove a software
how to remove from perfect speed optimizer,from add remove programe,but it rolling back
Answer Question
| August 21, 2012 10:15 AM
Trying but it rolling back
how to remove from perfect speed optimizer,from add remove programe,but it rolling back
Answer Question
| August 21, 2012 10:15 AM
Trying but it rolling back
Can I ask my SSS STATIC?
Can I ask my SSS STATIC?
Answer Question
| August 21, 2012 8:27 AM
etc, sss, STATIC
Can I ask my SSS STATIC?
Answer Question
| August 21, 2012 8:27 AM
etc, sss, STATIC
poll a file on a remote FTP server and then transfer it
I have a customer who will put a text file many times a day in a pc directory, I need to open an FTP connection to this PC server (no problem), I need to poll the directory every few seconds check to see if the file exists ( can’t ask the customer to do more [...]
Answer Question
| August 21, 2012 7:29 AM
AS/400, ftp connection
I have a customer who will put a text file many times a day in a pc directory, I need to open an FTP connection to this PC server (no problem), I need to poll the directory every few seconds check to see if the file exists ( can’t ask the customer to do more [...]
Answer Question
| August 21, 2012 7:29 AM
AS/400, ftp connection
How to open attachments in outlook 2007 in PDF
My outlook is trying to open all attachments in word format and that means I cannot open them in PDF. How do I change this?
Answer Question
| August 21, 2012 3:52 AM
Microsoft Outlook 2007, PDF
My outlook is trying to open all attachments in word format and that means I cannot open them in PDF. How do I change this?
Answer Question
| August 21, 2012 3:52 AM
Microsoft Outlook 2007, PDF
upgrade from sp2 to sp3
my laptop already downloaded automatically windows xp sp3 for an upgrade but my laptop can not install it, is there a problem with my sp2 system preventing the upgrade to sp3?
Answer Question
| August 21, 2012 12:20 AM
xpsp2 to xpsp3
my laptop already downloaded automatically windows xp sp3 for an upgrade but my laptop can not install it, is there a problem with my sp2 system preventing the upgrade to sp3?
Answer Question
| August 21, 2012 12:20 AM
xpsp2 to xpsp3
Powershell, loop through two different arrays?
Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i’m trying to access a remote computer(s) (According to the text file 1) and access a [...]
Answer Question
| August 20, 2012 11:12 PM
Arrays, LOOP statement, PowerShell, PowerShell Scripts, Scripting
Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i’m trying to access a remote computer(s) (According to the text file 1) and access a [...]
Answer Question
| August 20, 2012 11:12 PM
Arrays, LOOP statement, PowerShell, PowerShell Scripts, Scripting
Clean Server Copy for fresh upload of contacts
The server copy of my lotus notes address book currently has extra contacts. I would like to “wipe it clean” and the sync my local copy which is good. Without wiping the server copy clean, the local address book gets many of the bad contacts
Answer Question
| August 20, 2012 11:07 PM
Clean install, Lotus Notes Address Book
The server copy of my lotus notes address book currently has extra contacts. I would like to “wipe it clean” and the sync my local copy which is good. Without wiping the server copy clean, the local address book gets many of the bad contacts
Answer Question
| August 20, 2012 11:07 PM
Clean install, Lotus Notes Address Book
AS400 outsourcing
We are outsouring our AS400 to an offsite company. What vlan design should be implemented at the new site
Answer Question
| August 20, 2012 8:58 PM
Design
We are outsouring our AS400 to an offsite company. What vlan design should be implemented at the new site
Answer Question
| August 20, 2012 8:58 PM
Design
Kanban Stock Location
SAP – Kanban. The control cycle set to a supply area correctly to deliver it to a specific storage location. When the production order is confirmed, it is not putting the stock in the correct storage location.
Answer Question
| August 20, 2012 7:02 PM
SAP, SAP Kanban
SAP – Kanban. The control cycle set to a supply area correctly to deliver it to a specific storage location. When the production order is confirmed, it is not putting the stock in the correct storage location.
Answer Question
| August 20, 2012 7:02 PM
SAP, SAP Kanban
Open IT Forum: What job management software do you use?
One of our LinkedIn members, Michael Hyndman, would like to find a good job management software an IT department can use. What do you use? ConnectWise?
Answer Question
| August 20, 2012 6:53 PM
ConnectWise, Software
One of our LinkedIn members, Michael Hyndman, would like to find a good job management software an IT department can use. What do you use? ConnectWise?
Answer Question
| August 20, 2012 6:53 PM
ConnectWise, Software
Configuring wireless ethernet router to access PCs across router
A server controlled networked having wifi router. Router’s WAN socket connects to server & some computers connect the LAN & Wi-fi of router. I need proper config details for the router and network to share all PCs (files and printers) across the complete network.
Answer Question
| August 20, 2012 6:45 PM
LAN, router, WAN
A server controlled networked having wifi router. Router’s WAN socket connects to server & some computers connect the LAN & Wi-fi of router. I need proper config details for the router and network to share all PCs (files and printers) across the complete network.
Answer Question
| August 20, 2012 6:45 PM
LAN, router, WAN
Formula question
Hi I have a question about a short formula: IF {ado.UOM}=”LB” THEN crNoColor ELSE IF {ado.UOM}=”KG” THEN “{ado.Pieces}x{ado.Size1}” When I check this formula,there is an error. it always shows that there is some number required. Thank you for help
Answer Question
| August 20, 2012 4:35 PM
Crystal Report formula
Hi I have a question about a short formula: IF {ado.UOM}=”LB” THEN crNoColor ELSE IF {ado.UOM}=”KG” THEN “{ado.Pieces}x{ado.Size1}” When I check this formula,there is an error. it always shows that there is some number required. Thank you for help
Answer Question
| August 20, 2012 4:35 PM
Crystal Report formula
