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
How can we restrict remote access of a user ?
Answer Question | February 28, 2012 5:18 AM
as400 remote acess
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
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
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
Answer Question | February 28, 2012 5:22 PM
Java, Java code
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
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
Since installing iCloud, I have been experiencing the disappearance of email messages HELP!
Answer Question | February 28, 2012 1:16 PM
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
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
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
How does system pick the OUTQ when the job is executed ?
Answer Question | March 17, 2012 8:53 AM
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
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
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
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
What is the written word for FTPS, SFTPP, and FTPES
Answer Question | February 28, 2012 9:31 PM
FTPES, FTPS, Servers, SFTPP
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