Hi there, I have query regarding a wireless router. My internet connection setup consists of an ADSL modem (D-link DSL-320T) connected via an Ethernet cable to a wireless router (D-link DIR-615). My network appliances in turn connect to the router wirelessly. Originally, I had the modem connected to the DIR-615 wireless router (***model = H/W [...]
Answer Question | February 9, 2011 5:39 PM
D-Link, D-Link routers, HTTP, Network, Web Server, Wireless router
I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100 WHERE SHListNo = ALL ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join DVMURRAY/INSRP200 on SHListNo = SDListNo WHERE SDListNo is Null ) Row not found for DELETE. [...]
Answer Question | November 24, 2010 5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4
I am trying to define the LDA with an external definition in RPG /free. Any help?
Answer Question | December 1, 2010 3:11 PM
ILE RPG, iSeries, RPGLE, V5R4
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf I would need the query in figure 20 and the result in figure 21 which do not show up in the article. I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]
Answer Question | November 29, 2010 1:36 PM
Recursion, SQL Query, T-SQL, V5R4
Ouside of the JBA Explorer build 6.3.1 (iSeries OS V5R3) I can launch a browser window via a CL on a commandline. Inside the JBA Explorer I cannot. Ideas anyone???
Answer Question | November 24, 2010 9:53 PM
CL Commands, JBA, JBA AS/400 STRPCCMD, OS V5R3M0
I have problems trying to execute a program Windows from Iseries through the RUNRMTCMD, the message appears me is “command was not exceuted properly”, these are the sentences I’m using CMS (‘ls’) RMTLOCNAME (’142.15.2..210′ *IP) RMTUSER (USERID) RMTPWD (‘PASSWORD’)
Answer Question | November 26, 2010 6:26 PM
Execute Format, iSeries, iSeries error messages, RUNRMTCMD
how i can find iSeries navigator users. is there any EXIT programe or can use any CL for this.
Answer Question | November 26, 2010 11:58 AM
AS400 iSeries Navigator, CL Program, CL programming, iSeries Navigator
How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with decimals, [...]
Answer Question | December 8, 2010 11:18 AM
AS/400, DB2/400, OS/400, RPG/400
Does anyone have any experience of this? Specifically passing the System i owner of the spool file to equitrac software for secure printing?
Answer Question | November 23, 2010 10:55 AM
iSeries printing, Nashuatec, System i
Printing reports from an AS400 to a Xerox printer. If the printer fails no one knows until the next day. Trying to find the file the next day is horrid. Is there anyway to confirm and hold the file if it failed?
Answer Question | November 26, 2010 10:24 PM
AS/400, AS/400 print errors, AS/400 Spool Files, iSeries, RPG, Spool files
Hi Is there a way to invoke a program when pressing the F1 key, without adding the Call statement to the program that is doing the calling ? I would also need to pass parameters, or LDA to the program that I would be calling. Thanks, Nick
Answer Question | December 9, 2010 10:02 PM
AS/400 Parameters, LDA, RPGLE
I would like know how to to use the Dataq. Please send me examples in RPG ILE/400 as possible. Thanks
Answer Question | November 24, 2010 9:31 PM
AS/400 administration, AS/400 Data Queue, Data Queue, RPG ILE
My users need to have the ability to use the AS/400 in English or French. I plan to allow users to select the language when they sign on. I will use message files to display text in displays, etc. based on the selected language. What I really need is a way to convert the text [...]
Answer Question | November 22, 2010 6:51 PM
AS/400, AS/400 Languages, iSeries
Where can I find the latest ADM-File for Skype to manage my Group Policy?
Answer Question | November 26, 2010 1:26 PM
ADM, Group Policy, Skype, VoIP, Windows Server 2003, Windows Server 2003 Group Policy
I have setup my AS400 to run weekly backups. But all that happens is the job gets queued and is subsequently never run. I have backup jobs on queue for last couple months. I have even changed the backup setting so that I am sure the selected library is not in use, but still the [...]
Answer Question | December 2, 2010 1:03 PM
AS/400, AS/400 backup, AS/400 job scheduler, Backup, DSPLOG
Hi Friends, We have info print installed on our iseries box. When we are generating PDF files under email using info print server, we can customize the following two messages under email:- 1. Subject line 2. Message/Body text (MSGTEXT) under the mail. My query is that I need to break the lines under body text [...]
Answer Question | November 23, 2010 8:19 AM
AS/400, AS/400 email, AS/400 Languages, InfoPrint Mapping Exit Program, RPGLE
How to sort by Date/Time in WRKJOBSCDE.
Answer Question | November 24, 2010 7:41 AM
AS/400, AS/400 administration, WRKJOBSCDE, WRKJOBSCDE AS/400
I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion. I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the [...]
Answer Question | November 29, 2010 9:43 PM
iSeries, Query Management Query, Query Manager, V5R2
When the AS/400 calls home for support, it dials a number. Where can I find out what that number is?
Answer Question | November 24, 2010 8:36 PM
AS/400, AS/400 administration, AS/400 Service Agent
I have many menu options that simply execute a *CMD with various parms. If I key the command on the *CMD line, I can use F9 to retieve previous commands I ran. But it does not show the *CMD and parms I ran from menu options. Is there something I can do so that my [...]
Answer Question | February 22, 2011 8:12 PM
CMD, CMD Restriction, CMD Source, COMMANDS, F9 Previous commands *RQS