WRKJOBSCDE every *other* week
Does anyone know how to use the IBM scheduler to submit something every *other* week or every third week, etc? Thanks, Kevin

Answer Question   |  December 14, 2009  1:19 PM
AS/400, DataCenter

SNDDST TYPE(*DOC) not working for big files
We are using SNDDST to send reports via internet e-mail. It works for small reports (text files) but not for larger ones. No error is shown when issuing the command. QSYS/SNDDST TYPE(*DOC) + TOINTNET((sbchenry@hotmail.com *PRI)) + DSTD(‘Sending a Text’) + MSG(‘Find the report attached.’)+ SNDFMT(*NOCHG) DOC(Report.TXT) FLR(‘TEMP’) If Report.TXT is small, it is received as [...]

Answer Question   |  December 14, 2009  12:17 PM
AS/400, Email

Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]

Answer Question   |  December 14, 2009  10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio

runrmtcmd on WinXP
I can’t seem to get mapped drive operations to work from batch pgms on WinXP called using runrmtcmd. For instance, I have a .bat file that does a “dir c:”. This works if I run the batch file from a command window on XP and it also works if I invoke it using runrmtcmd from [...]

Answer Question   |  November 24, 2010  10:25 PM
AS/400, DataCenter, Microsoft Windows, PC/Windows Connectivity

Retrieval of Extended Source Library Information
Is there a way via FTP to retrieve additional source code line-level details (sequence #, date line of code was changed) from iSeries RPG/CL source libraries? If not via FTP, is there another way to extract and transfer this information?

Answer Question   |  December 14, 2009  3:58 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity

performances of Java when acces to IFS files
hello to all Are there any specific parameters to set on the iseries to increase the access speed of java / jsp programs execution especially when they use IFS files.

Answer Question   |  August 4, 2006  12:02 PM
AS/400, DataCenter, Web development

Help with converting Mainframe file on iSeries
Hi there, I’m looking for some advice/help on a file that I’m having some trouble with. The file originates from a mainframe, and is sent over to our iSeries (V5R2M0) via Connect:Direct. The file is 3680 Bytes long, comprising of string and compressed numeric data. I have the layout of the file, although it’s in [...]

Answer Question   |  December 13, 2009  7:38 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity

Source highlighting using NetManage Rumba
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA…Chuck

Answer Question   |  December 18, 2009  8:52 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE

AS400 name not resolving in DNS
On Sunday I restarted my AS400 prior to doing my monthly full system back up. When it came on line, none of my PC’s could resolve the system name (s10a####) to the internal ip address. I entered a DNS entry manually on my internal Windows 2003 DNS server, and all the PC’s running XP pro [...]

Answer Question   |  December 13, 2009  11:56 AM
AS/400, PC/Windows Connectivity

Read excel file to iSeries using RPGLE and JAVA
I am trying to read an excel file to iSeries platform using combination of RPGLE and JAVA. Is anyone done this before and get it to work? Please advise.

Answer Question   |  July 31, 2006  9:51 AM
RPGLE

Highlight source text
How do I highlight or change color of source text when using a PC with immulator instead of a green screen terminal?

Answer Question   |  December 15, 2009  2:37 PM
AS/400

Job Schedule Entries Migration
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info [...]

Answer Question   |  December 13, 2009  9:18 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE

V4R5 console prooblem
Hello there, I have a V4R5 that I want to upgrade to V5R1. Unfortunately, the operation console is not working (even in V4R5). In an effort to set the console type using control panel function 65 and 21, the function 65 return D1008065, while the function 21 return FF. I want to know why function [...]

Answer Question   |  August 4, 2006  4:52 AM
AS/400

Multi-Member Files
We have a file that has multiple members in it. More members can be added through-out the day by one of our applications. The file is being journaled. The file became corrupted. The file was restored using *ALL on the MBROPT command. When attempting to run APYJRNCHG, we received various errors because of the newly [...]

Answer Question   |  July 28, 2006  4:18 PM
AS/400, Backup & recovery, DataCenter

Will I have problems restoring our system from an iSeries 550 to an 840?
My company is participating in a Disaster Recovery workshop at the IBM office in Toronto. The issue is that we currently have our system installed on an iSeries model 550, but the machine that IBM is supplying us with for the workshop is an 840. Will we have any problems restoring our V5R3M0 system on [...]

Answer Question   |  November 23, 2010  3:12 PM
AS/400, Backup & recovery

HP LJ1022n printer configuration
Running a 270 V5R2. I have several barcode printers set up using remote writers, working fine. I have several IBM infoprint printers set up regularly working fine. I now have an HP LJ1022n that will print nothing but garbage when I set up like my Infoprint printers. Help? Device description > PRT20 Advanced function printing [...]

Answer Question   |  July 21, 2006  11:25 AM
AS/400, DataCenter, PC/Windows Connectivity

Retreiving host name
Currently we have 2 iSeries systems on our network. We run the same CL’s on both boxes, we need to determine which iSeries is currently running the CL procedure. How can I retrieve the host name in a CL program?

Answer Question   |  November 27, 2010  11:56 AM
AS/400

Implementing RUP in Retail business which runs on i-Series
A retail company is planning to implement IBM Rational Unified Process for its business which runs on i-Series. Please let me know how well RUP can be implemented here. How well RUP works for i-Series software development? What are the tailoring to be done to this process for i-Series? Also, please comment on the RUP [...]

Answer Question   |  July 24, 2006  7:21 AM
Application development, AS/400, Automated, Budgeting, Business/IT alignment, Career development, Compliance, DataCenter, Development, Functional, Laws, Lifecycle development, Performance/Load, Project management, Regulations, ROI & cost justification, RPG, RPGLE, Software Quality Assurance, Software testing, Software testing tools, standards, Vendors

Synon Resources
I have been having trouble finding Synon expereinced people. Can anyone suggest any resources. Your help would be greatly appreciated. sallyjo.scavone@vtcons.com

Answer Question   |  July 24, 2006  5:39 PM
AS/400

Cannot FTP from AS/400
Hi, When I FTP from my PC, it goes OK but when I tried from AS/400 to my PC, screen is frozen and does not go anywhere. My PC is running on XP and my FTF is on on the PC side and FTP server in AS/400 is running. I can ping from AS/400 to [...]

Answer Question   |  July 18, 2006  4:52 PM
AS/400, DataCenter, Networking