How to retrieve system name on which I am working in as/400??
how to retrieve system name on which I am working in as/400??

Answer Question   |  November 29, 2010  12:06 PM
AS/400 administration, AS/400 system administration, CL programming, CL programs

Not able to restore Logical File after it was damaged and deleted
We have deleted a Logical File from our system, since it was damaged. But now when we are restoring it from the Entire System using RSTOBJ, the Job is Failing and upon viewing the Joblog below messages are displayed. RSTOBJ OBJ(ZUNS) SAVLIB(PRTDEVDTA) DEV(TAP02) OBJTYPE(*FILE) SEQNBR(344) New format ZUNSREC created for file ZUNS.                                Member ZUNS already [...]

Answer Question   |  November 29, 2010  8:10 AM
AS/400 administration, IBM System i 550, Logical Files, Restore files, RSTOBJ

Example of Cobol call to an SQL stored procedure
I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName [...]

Answer Question   |  December 3, 2010  6:05 PM
COBOL, iSeries, iSeries Cobol programming, SQL stored procedures, Stored Procedures

Problem Accessing Web Server via HTTP After Changing Wireless router
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

Deleting unmatched records from a file in iseries SQL
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

RPG /Free Local Data Area definitions
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

T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)
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

Launching a browser window from JBA Explorer 6.3.1
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

Error msg when trying to execute a program Windows from Iseries through the RUNRMTCMD.
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

iSeries Navigator
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 an AS/400 numeric field to an alphanumeric field without disturbing the value in it?
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

System i printing on Nashuatec MP/C5000 with equitrac
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

Need to hold/resend AS/400 spool file on print failure
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

On Line Help Program – RPGLE
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

Examples of data queue in IBM AS/400
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

Converting English to French in AS/400
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

Skype ADM-File for Windows Server 2003 group policy
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

AS400 Backup Job Submitted but not run
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

How to break text under EMAIL body received from Iseries Infoprint PDF mapping program
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

Sort Date/Time in WRKJOBSCDE in AS/400
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