Free IT Book: The RAILS 3 Way
Don’t know, link won’t open

View Answer   |  May 12, 2011  5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

use Data connection wizard / Microsoft query to get data from as400 to excel 2007
If you have Client Access why not use Excel Addins that setup Icons in Excel to bring up a wizard in Excel to download to or from the Iseries. Can be saved fo subsequent downloads. With Excel 2007 need PTF SI26879 for 5722XE1 IF ON v5r4

View Answer   |  May 11, 2011  3:28 PM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC

Can we change length of CSV File
Actually I donot have a Source for this CSV file. its program described PF. I have created the new file and copied the data. Thanks, Pradeep

View Answer   |  May 11, 2011  5:47 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format

Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields. I may have [...]

View Answer   |  May 10, 2011  6:29 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE

Process Execution error – CD
This is not an IBM message file, so it belongs with some software package you have on your system. You need to determine what that is and then look into their manuals or contact their help desk to get more information. I’m guessing NDM is Network Data Movers. Good luck

View Answer   |  May 10, 2011  12:53 PM
Business Process Execution Language, Process Manager, V6R1

SAPMMC All Settings Gone after running CCCleaner , How to get all settings
You are boned. Either you can do a system restore or you must re-enter everything. Make sure when you run CCleaner you check the settings and double-check which boxes you have enabled. You most likely had the prefetch data and/or one of the other boxes checked that store program information temp files.

View Answer   |  May 9, 2011  7:35 PM
CCSID, SAPMMC, SID, Windows Server 2003

Certificate not signed by trusted authority
Finally got an answer. IBM ran a trace that determined we needed a specific Certificate Authority, which they sent. It was a 1K text file, which we imported into the IBM i using Digital Certificate Manager. Once the certificate authority was installed the software started working right away.

View Answer   |  May 6, 2011  11:00 PM
Certificate authorities, Certificate authority, Digital certificates, iSeries, iSeries communication, twitter

Error Msg Clean Tape in AS/400 backup
I would clean it up one more time and try one more tape. If error is the same, I would start to suspect a hardware error.

View Answer   |  May 6, 2011  8:08 PM
AS/400 backup, AS/400 backup and recovery, Backup, Tape Backups

Can CL Programming language can have level check error
Yes If you are doing a RCVF instruction, you are accessing a DB file so it would be the same as an RPG/COBOL program.

View Answer   |  May 6, 2011  5:50 PM
AS/400 Parameters, CL Procedure, CL programming, CLLE, CLP, Level Check

Writing command WJ that will do the same thing as WRKACTJOB?
Are you asking to have a commad WJ that will do the same thing as WRKACTJOB?* If you want to do it without any programming. CRTDUPOBJ OBJ(savlibl) FROMLIB(*LIBL) OBJTYPE(*CMD) TOLIB(QGPL) NEWOBJ(WJ) my purpose is to start programming, so i think this is a fine way of training.

View Answer   |  May 6, 2011  5:07 PM
CL Commands, CL Program, CLPROGRAM, WRKACTJOB

Cmd options text missing in IBM-supplied commands
Problem solved: As a home-worker I sit alone in the office, working on myThinkpad with ClientAccess-5250 emulation connected etc.. Today one of my collegues visited my office, and he connected his Portable, and to my surprise, he could see all the option-texts on IBM-commands. This made us investigate my 5250-emulation setup, and it showed up [...]

View Answer   |  May 6, 2011  12:16 PM
AS/400, Command Prompt screen, IBM, iSeries Commands, Messagefile, V6R1

AS400 and connecting via ssh or using sftp to retrieve files.
Yes, it does. Easily? Hmm. I’ve seen this topic come up on occasion in other AS400-related groups. I’ve never needed it myself, but I have noticed that others seem to struggle greatly with it. I poked around a bit, and found these references for you. Happy sftp hunting! <a href=”http://www.ibmsystemsmag.com/ibmi/administrator/systemsmanagement/sFTP-Tips/”>IBM Systems Magazine</a> <a href=”http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037e/17c2d734a7a40463862576440045c22e?OpenDocument&Highlight=2,538212497″>IBM i [...]

View Answer   |  May 5, 2011  10:04 PM
AS/400, AS/400 SFTP, Connection Issues, SFTP, SSH

RGZPFM with ALWCANCEL(*YES)
IT depends on how long you keep your receivers on the system. If at the end of the REORG, you have the same amount of disk space used, but in a few days, you copy the receivers off the system and then remove them, you will get the space back taht you want. Are you [...]

View Answer   |  May 5, 2011  8:12 PM
IBM i, Journaling, RGZPFM, V7R1

IFS/Folder size
Quickest way I know at command line edtf ‘/’ Put a 6 (path Size) next to a directory you will then see the display show size number of Directories and number of files. When you drill down on the directory file size will show. On larger directories it may take awhile for display to change [...]

View Answer   |  May 5, 2011  6:22 PM
IFS, IFS Folder, IFS record size, V5R4M5

IBM iSeries V5R2 and Windows 7
According to IBM Client Access needs V6R1 of Client Access. If you are just needing TN5250 try mochasoft at www.mochasoft.dk there are 2 versions both have 30 day trial, Try TN5250 for Windows first – I have tried on Windows 7 and it works. That way will work on both XP and Windows 7. If [...]

View Answer   |  May 5, 2011  6:13 PM
iSeries Access, V5R2, V5R2M0, Windows 7

AS/400 job not found with SBMJOB command
Hi, You should set the following option to Yes when you are using SBMJOB command. “Allow display by WRKSBMJOB . . . ” You must set this to ‘*YES’ You will get this option by giving F10(Additional Parameters) Have verified this option before submitting.? Try the below command. SBMJOB CMD(CALL PGM(XYZ) PARM(‘A’ ‘B’)) DSPSBMJOB(*YES) Also, [...]

View Answer   |  May 5, 2011  3:34 PM
AS/400, AS/400 jobs, QCMDEXC, RPG Program, SBMJOB

Open IT Forum: Share networking resources, earn knowledge points!
A little more information: We’re looking to do a roundup of recommended reading for networking professionals. If you have books or other resources you’ve found helpful, either as a general “cookbook,” getting up to speed on a particular topic, or even prepping for a certification exam, it would be great if you could share the [...]

View Answer   |  May 5, 2011  3:16 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

V5R4 upgrade to V6R1
This site gives you the answer. http://www-947.ibm.com/systems/support/i/planning/upgrade/osmapping.html DanF

View Answer   |  May 5, 2011  1:42 PM
iSeries Upgrades, System i, V5R4, V6R1

Power Down
PWRDWNSYS RESTART(*YES) Depending on the OS you can also use the SHUTDOWN command with various parameters (depending on the OS). It is helpful to say what Operating System you are dealing with to get answers which apply to your situation.it also determine the type of power supply or the power voltage.

View Answer   |  May 5, 2011  7:44 AM
COMMANDS

V4Rx – Cache battery status
UseSystem Service tools. By the way, release 7.1 now has a program you can call to display the cache battery info. No more need for SST.

View Answer   |  May 3, 2011  7:09 PM
AS/400, Cache battery, Cache Battery Failure, V4R2