using SQL in RPG
I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from WFILES.RNSORDP WHERE RNSREGN > [...]
Answer Question
| September 21, 2012 3:30 PM
AS/400, RPG, SQL
I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from WFILES.RNSORDP WHERE RNSREGN > [...]
Answer Question
| September 21, 2012 3:30 PM
AS/400, RPG, SQL
Open IT Forum: How do you maintain your code?
Programmer Steve Poling offered an interesting take on what needs to be done to avoid bad code. What steps do you take to make sure things are up to date?
Answer Question
| September 21, 2012 2:31 PM
Codebase, Coding
Programmer Steve Poling offered an interesting take on what needs to be done to avoid bad code. What steps do you take to make sure things are up to date?
Answer Question
| September 21, 2012 2:31 PM
Codebase, Coding
Outlook 2003 email still in outbox (but it does send) only when in cached mode
This is happening to over a dozen users now. The emails send, but they don’t move to Sent Items, they sit in the Outbox. The user can’t tell if they sent for sure until / unless they get a reply. If I turn off Cached Mode the items disappear from the Outbox and if I [...]
Answer Question
| September 21, 2012 2:16 PM
Microsoft Outlook 2003, Microsoft Outlook emails
This is happening to over a dozen users now. The emails send, but they don’t move to Sent Items, they sit in the Outbox. The user can’t tell if they sent for sure until / unless they get a reply. If I turn off Cached Mode the items disappear from the Outbox and if I [...]
Answer Question
| September 21, 2012 2:16 PM
Microsoft Outlook 2003, Microsoft Outlook emails
operating system
if multiprograming is an oprating system , then how it is differ from multitasking.
Answer Question
| September 21, 2012 2:14 PM
qwwew
if multiprograming is an oprating system , then how it is differ from multitasking.
Answer Question
| September 21, 2012 2:14 PM
qwwew
Signs
When im typing a document a full stop appears after every word and a symbol appears after every sentence. i would like to know how to switch this off.
Answer Question
| September 21, 2012 1:35 PM
symbols
When im typing a document a full stop appears after every word and a symbol appears after every sentence. i would like to know how to switch this off.
Answer Question
| September 21, 2012 1:35 PM
symbols
SAP project system
I need the list of all transaction codes of the SAP project system.
Answer Question
| September 21, 2012 12:09 PM
SAP, SAP Project System
I need the list of all transaction codes of the SAP project system.
Answer Question
| September 21, 2012 12:09 PM
SAP, SAP Project System
Antivirus
Is it possible to automatically scan my computer, say every hour? I wanted to create a tool that can automatically scan all computers on a LAN in a given interval. IT is my research area so I was just wondering if its already done.
Answer Question
| September 21, 2012 12:07 PM
Network Scanners, Scanning
Is it possible to automatically scan my computer, say every hour? I wanted to create a tool that can automatically scan all computers on a LAN in a given interval. IT is my research area so I was just wondering if its already done.
Answer Question
| September 21, 2012 12:07 PM
Network Scanners, Scanning
My EDB File Currupted in Exchange server 2007 .
Few Days ago i faced a very difficult situation when my EDB File of Exchange server 2007 Corrupted and unfortunately i have no backup. now just want to repair it but all the effort done by my it staff is not work . What to do now can anybody give me some suggestion. Thanks in [...]
Answer Question
| September 21, 2012 11:17 AM
Exchange Server 2007
Few Days ago i faced a very difficult situation when my EDB File of Exchange server 2007 Corrupted and unfortunately i have no backup. now just want to repair it but all the effort done by my it staff is not work . What to do now can anybody give me some suggestion. Thanks in [...]
Answer Question
| September 21, 2012 11:17 AM
Exchange Server 2007
SAP support pack upgrade
Is anyone familiar with the upgrade of the SAP support pack?
Answer Question
| September 21, 2012 10:45 AM
SAP, SAP Upgrade
Is anyone familiar with the upgrade of the SAP support pack?
Answer Question
| September 21, 2012 10:45 AM
SAP, SAP Upgrade
Oracle 10g in Windows 7
Can we be able to install Oracle 10g Express edition in Windows 7 Home Basic of 64 bit Intel i5 processor?
Answer Question
| September 21, 2012 10:35 AM
Oracle 10g, Windows 7 Home Basic
Can we be able to install Oracle 10g Express edition in Windows 7 Home Basic of 64 bit Intel i5 processor?
Answer Question
| September 21, 2012 10:35 AM
Oracle 10g, Windows 7 Home Basic
sap implementation methodology
What are the different sap implementation methodologies? How many are there?
Answer Question
| September 21, 2012 9:47 AM
Implementation, methodology, SAP
What are the different sap implementation methodologies? How many are there?
Answer Question
| September 21, 2012 9:47 AM
Implementation, methodology, SAP
Trigger
What is the use of the trigger?
Answer Question
| September 21, 2012 9:02 AM
SQL Trigger, Triggers
What is the use of the trigger?
Answer Question
| September 21, 2012 9:02 AM
SQL Trigger, Triggers
Oracle r12′s new features
Does anyone know: What are Oracle R12′s new features?
Answer Question
| September 21, 2012 9:01 AM
Oracle, Oracle features
Does anyone know: What are Oracle R12′s new features?
Answer Question
| September 21, 2012 9:01 AM
Oracle, Oracle features
Oracle Forms 4.5 installation software
While we are converting to newer version of forms, we need to have a second backup site to support the current 4.5 production environment. So we are looking for a download site to have this backup site running on Windows 2000 server, just like it is now.
Answer Question
| September 21, 2012 2:18 AM
Oracle Forms 4.5
While we are converting to newer version of forms, we need to have a second backup site to support the current 4.5 production environment. So we are looking for a download site to have this backup site running on Windows 2000 server, just like it is now.
Answer Question
| September 21, 2012 2:18 AM
Oracle Forms 4.5
Windows cannot connect to the printer operation failed with error 0×00000002
I have 2 HP printers connected to a Gatewya laptop sering as my print server. From my HP laptop I can print to one of the two HP printers – an old HP Laserjet 5M – but not to the HP OfficeJet J3600 Series. All laptops run Win7. When I try to add the printer [...]
Answer Question
| September 21, 2012 12:39 AM
Windows 7, Windows 7 Printing
I have 2 HP printers connected to a Gatewya laptop sering as my print server. From my HP laptop I can print to one of the two HP printers – an old HP Laserjet 5M – but not to the HP OfficeJet J3600 Series. All laptops run Win7. When I try to add the printer [...]
Answer Question
| September 21, 2012 12:39 AM
Windows 7, Windows 7 Printing
VPN Network
Name one difference between a SSL VPN and PPTP VPN?
Answer Question
| September 21, 2012 10:12 PM
PPTP VPN, Ssl vpn, VPN network
Name one difference between a SSL VPN and PPTP VPN?
Answer Question
| September 21, 2012 10:12 PM
PPTP VPN, Ssl vpn, VPN network
looking for a document template for data elements, app functions
unexperienced tester needs help determining a document template for ensuring that all pieces of an application are being tested – there currently is no documentation – my superior is looking for something that shows data elements, functions, screen prints but yet he doesn’t want a procedure manual – I’m not sure what he is looking [...]
Answer Question
| September 20, 2012 9:27 PM
MVC
unexperienced tester needs help determining a document template for ensuring that all pieces of an application are being tested – there currently is no documentation – my superior is looking for something that shows data elements, functions, screen prints but yet he doesn’t want a procedure manual – I’m not sure what he is looking [...]
Answer Question
| September 20, 2012 9:27 PM
MVC
ME21N Adoption of PO error message
I am attempting to adopt a PO using ME21N. The system is not allowing it and giving the message “Updates to Material group not allowed”. How can I correct this?
Answer Question
| September 20, 2012 6:00 PM
SAP, SAP error messages
I am attempting to adopt a PO using ME21N. The system is not allowing it and giving the message “Updates to Material group not allowed”. How can I correct this?
Answer Question
| September 20, 2012 6:00 PM
SAP, SAP error messages
PF usage high
HI everyone, I have 2 GB of RAM in my machine and 4092 mb of pagefile.around 1 GB of memory is being used by SQL server,rest services are using around 600 MB of memory. But my PF usage is showing 3.85 GB of utilization.Why is it showing such high utilization and how to resolve it [...]
Answer Question
| September 20, 2012 3:11 PM
Page Files, windows 2003
HI everyone, I have 2 GB of RAM in my machine and 4092 mb of pagefile.around 1 GB of memory is being used by SQL server,rest services are using around 600 MB of memory. But my PF usage is showing 3.85 GB of utilization.Why is it showing such high utilization and how to resolve it [...]
Answer Question
| September 20, 2012 3:11 PM
Page Files, windows 2003
How to obtain Database on Network Drive
Hello. I moved a lotus notes database to a network drive to allow for more space. What is the formula in lotus notes to access this network drive as a shortcut? I have been trying all different sorts of formulas and they aren’t working. I know it’s something simple, but I just can’t figure it [...]
Answer Question
| September 20, 2012 2:53 PM
Lotus Notes 6.5.1
Hello. I moved a lotus notes database to a network drive to allow for more space. What is the formula in lotus notes to access this network drive as a shortcut? I have been trying all different sorts of formulas and they aren’t working. I know it’s something simple, but I just can’t figure it [...]
Answer Question
| September 20, 2012 2:53 PM
Lotus Notes 6.5.1
