Improve performance for SQL query reading file having milions of recods (AS/400 – SQLRPGLE program)
I am fetching only 14 records each time from a customer file(physical file) having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM CUSTOMER A WHERE A.CLINM1 LIKE ‘B%’ AND (CLINM1 <> ” OR CLIPR1 <> ”) ORDER BY A.CLINM1 ASC, A.CLIPR1 ASC [...]
Answer Question
| March 17, 2012 5:23 AM
AS/400, AS400 - SQL Queries, SQLRPGLE
I am fetching only 14 records each time from a customer file(physical file) having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM CUSTOMER A WHERE A.CLINM1 LIKE ‘B%’ AND (CLINM1 <> ” OR CLIPR1 <> ”) ORDER BY A.CLINM1 ASC, A.CLIPR1 ASC [...]
Answer Question
| March 17, 2012 5:23 AM
AS/400, AS400 - SQL Queries, SQLRPGLE
remote server
How can we restrict remote access of a user ?
Answer Question
| February 28, 2012 5:18 AM
as400 remote acess
How can we restrict remote access of a user ?
Answer Question
| February 28, 2012 5:18 AM
as400 remote acess
tmo network voice mo mobile off_vm
this is on my sons bill.when he sends a text or rings this number it says tmo network voice mo mobile off_vm.what does this mean.
Answer Question
| February 28, 2012 10:32 PM
Mobile devices, tmo network
this is on my sons bill.when he sends a text or rings this number it says tmo network voice mo mobile off_vm.what does this mean.
Answer Question
| February 28, 2012 10:32 PM
Mobile devices, tmo network
Lotus nsf problem
i had taken health check in lotus notes nsf it showing 90 and above percentage during system maintanance but after nextday it show only 60 to 70 % only this happening every week after maintanance pls help me in this problem
Answer Question
| March 17, 2012 10:11 PM
Lotus Notes, Lotus Notes NSF, Lotus System Maintenance
i had taken health check in lotus notes nsf it showing 90 and above percentage during system maintanance but after nextday it show only 60 to 70 % only this happening every week after maintanance pls help me in this problem
Answer Question
| March 17, 2012 10:11 PM
Lotus Notes, Lotus Notes NSF, Lotus System Maintenance
FI – General Ledger – When do we use the F-06 Incoming Payments transactions directly in GL?
When do you post the following Transactions directly in GL? F-06 – Incoming payments F-07 – Outgoing payments FBCJ – Cash Journal posting
Answer Question
| February 28, 2012 8:02 PM
F-06, F-07, FBCJ, GL, SAP, SAP FI
When do you post the following Transactions directly in GL? F-06 – Incoming payments F-07 – Outgoing payments FBCJ – Cash Journal posting
Answer Question
| February 28, 2012 8:02 PM
F-06, F-07, FBCJ, GL, SAP, SAP FI
Simple program of frame in advance java
Simple program of frame in advance java
Answer Question
| February 28, 2012 5:22 PM
Java, Java code
Simple program of frame in advance java
Answer Question
| February 28, 2012 5:22 PM
Java, Java code
Server hangs when adding a network adapter after a P-V
Did a P-V on a windows 2003 SP1 system. When adding a network card, the OS hangs and the only way to get it back is to reboot the system. Any idea what is preventing the system from adding the network driver?
Answer Question
| February 28, 2012 3:48 PM
Network Adapter, P-V, VMware
Did a P-V on a windows 2003 SP1 system. When adding a network card, the OS hangs and the only way to get it back is to reboot the system. Any idea what is preventing the system from adding the network driver?
Answer Question
| February 28, 2012 3:48 PM
Network Adapter, P-V, VMware
User Profile Creation Date
How can I get the User Profile Creation Date for all my user profiles in one report? I would be nice if this was in the same report as my DSPUSRPRF report which has all the other parameters I need, but Audit want to see when they were created . . . Don’t you [...]
Answer Question
| March 17, 2012 2:53 PM
AS/400 user profiles, V5R4
How can I get the User Profile Creation Date for all my user profiles in one report? I would be nice if this was in the same report as my DSPUSRPRF report which has all the other parameters I need, but Audit want to see when they were created . . . Don’t you [...]
Answer Question
| March 17, 2012 2:53 PM
AS/400 user profiles, V5R4
Disappearing email messages
Since installing iCloud, I have been experiencing the disappearance of email messages HELP!
Answer Question
| February 28, 2012 1:16 PM
icloud, Outlook
Since installing iCloud, I have been experiencing the disappearance of email messages HELP!
Answer Question
| February 28, 2012 1:16 PM
icloud, Outlook
DP90 created debit memo requests – cost assignment to CO-PA needed
When we do a run with DP90 we create debit memo requests from a contract position. Imagine one contract with one line item 10. DP90 breaks that down in to one debit memo request with several line items. Now, those line items point back to their originating contract position by SAP-default. I would like it [...]
Answer Question
| February 28, 2012 10:39 AM
CO-PA, cost assignment, DP90, Dynamic Item Processor, SAP
When we do a run with DP90 we create debit memo requests from a contract position. Imagine one contract with one line item 10. DP90 breaks that down in to one debit memo request with several line items. Now, those line items point back to their originating contract position by SAP-default. I would like it [...]
Answer Question
| February 28, 2012 10:39 AM
CO-PA, cost assignment, DP90, Dynamic Item Processor, SAP
SQLRPGLE
C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File Here actually i am getting 3 records as output. But i dont know how to write those 3 records into a printer file. Can anybody explain me how to write the output of a select [...]
Answer Question
| March 19, 2012 10:30 AM
AS/400, AS/400 output files, SQL commands, SQLRPGLE
C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File Here actually i am getting 3 records as output. But i dont know how to write those 3 records into a printer file. Can anybody explain me how to write the output of a select [...]
Answer Question
| March 19, 2012 10:30 AM
AS/400, AS/400 output files, SQL commands, SQLRPGLE
Data Structure Arrays
I have a “page at a time” subfile and in order to store multiple pages of options I have created arrays to store the options and the PF record RRN and Key Fields. This process Stores and reloads the options seamlessly. It all works beautifully except that the options are executed in the order they [...]
Answer Question
| March 19, 2012 9:36 AM
RPGLE Program
I have a “page at a time” subfile and in order to store multiple pages of options I have created arrays to store the options and the PF record RRN and Key Fields. This process Stores and reloads the options seamlessly. It all works beautifully except that the options are executed in the order they [...]
Answer Question
| March 19, 2012 9:36 AM
RPGLE Program
OUTQ
How does system pick the OUTQ when the job is executed ?
Answer Question
| March 17, 2012 8:53 AM
OUTQ, outqueue
How does system pick the OUTQ when the job is executed ?
Answer Question
| March 17, 2012 8:53 AM
OUTQ, outqueue
SFTP using port number 10022
Hi, Can someone please explain me the differene between port number 10022 and 22 for implementing SFTP transfer. Which port is preferrable and why?
Answer Question
| February 28, 2012 8:03 AM
Port 10022, Port 22, SFTP, SFTP Transfer
Hi, Can someone please explain me the differene between port number 10022 and 22 for implementing SFTP transfer. Which port is preferrable and why?
Answer Question
| February 28, 2012 8:03 AM
Port 10022, Port 22, SFTP, SFTP Transfer
FTP & SAVF
1.How to download a savf to pc from iseries: 2.How to upload a savf from pc to iseries: Hi Gurus, I have added all the files from my source physical file “QDDSSRC” to a save file “SAVF1″ in the library GOVIN using the folowing command. SAVOBJ OBJ(QDDSSRC) LIB(GOVIN) DEV(*SAVF) SAVF(GOVIN/SAVF1) Now How i will download [...]
Answer Question
| March 17, 2012 7:16 AM
AS/400, FTP, SAVF
1.How to download a savf to pc from iseries: 2.How to upload a savf from pc to iseries: Hi Gurus, I have added all the files from my source physical file “QDDSSRC” to a save file “SAVF1″ in the library GOVIN using the folowing command. SAVOBJ OBJ(QDDSSRC) LIB(GOVIN) DEV(*SAVF) SAVF(GOVIN/SAVF1) Now How i will download [...]
Answer Question
| March 17, 2012 7:16 AM
AS/400, FTP, SAVF
how to handle Cursor progression in a mixed display file
I have a mixed DSPF (a combination of RECORD & SFL) Diagram is like: ——————————- Customer screen——————— from date :____ Print: _(Y/N) to date :____ opt description … _ ___________ _ ___________ _ ___________ bottom ———————————————————————— My question is : I want that on tabbing,cursor should go from ‘from date [...]
Answer Question
| February 28, 2012 6:18 AM
DSPF, FLDCSPPRG, Subfile Control, Subfile Display
I have a mixed DSPF (a combination of RECORD & SFL) Diagram is like: ——————————- Customer screen——————— from date :____ Print: _(Y/N) to date :____ opt description … _ ___________ _ ___________ _ ___________ bottom ———————————————————————— My question is : I want that on tabbing,cursor should go from ‘from date [...]
Answer Question
| February 28, 2012 6:18 AM
DSPF, FLDCSPPRG, Subfile Control, Subfile Display
Windows 7 office
We purchased Office XP 3BE, but now need Office for operating system 7. Can we download Office for Windows 7 free, being we have purchased Office previously for XP?
Answer Question
| February 28, 2012 2:34 AM
Windows 7, Windows 7 Office, Windows 7 Office Installation, Windows XP
We purchased Office XP 3BE, but now need Office for operating system 7. Can we download Office for Windows 7 free, being we have purchased Office previously for XP?
Answer Question
| February 28, 2012 2:34 AM
Windows 7, Windows 7 Office, Windows 7 Office Installation, Windows XP
Server Abbreviations
What is the written word for FTPS, SFTPP, and FTPES
Answer Question
| February 28, 2012 9:31 PM
FTPES, FTPS, Servers, SFTPP
What is the written word for FTPS, SFTPP, and FTPES
Answer Question
| February 28, 2012 9:31 PM
FTPES, FTPS, Servers, SFTPP
turning off the wireless broadcast
Can I use my netgear 300n as a wired router without having the wireless function?
Answer Question
| May 13, 2012 9:20 PM
Netgear 300n, router, Routers, Wireless Network
Can I use my netgear 300n as a wired router without having the wireless function?
Answer Question
| May 13, 2012 9:20 PM
Netgear 300n, router, Routers, Wireless Network
