how create a printer file in AS400
HI, The message shows “Mistakes in the DDS not allowed with the specified GENLVL, one has not found the device of printer PRT01. File PRTF1 has not been created in the library HIPTSTMAP1″   Obviously use CRTPRTF. Probably another way exists to create the file of printer. THANKS.

Answer Question   |  November 10, 2009  5:41 PM
AS/400 Printer File, AS/400 printing, CRTPRTF
asked by:
185 pts.

Member Level ID
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and Views. The issue is that [...]

Answer Question   |  October 26, 2009  3:43 PM
AS/400 database, AS/400 development, iSeries database
asked by:
2,480 pts.

Need to find everyplace a file is being used.
I have a file that we are adding a field. Need to find every program the file is being used to know which ones need to be recompiler. Would be nice to do one big search of the entire library. 

Answer Question   |  January 12, 2010  3:37 PM
DDS, RPG, RPGLE
asked by:
385 pts.

RPGLE. cpytopcd
I have tried to create a file where every record is 80 characters long. Every record should be filled with spaces if the record is shorter than 80 char. In my program I use cpytopcd and this command seems to cut every record if there aren’t any more characters. If you look at it in hexadec there are no values. [...]

Answer Question   |  October 25, 2009  3:24 PM
CPYTOPCD, RPGLE, RPGLE Program
asked by:
15 pts.

AS/400 file transfer window disappears
as400 file transfer window drops to the bottom never to return.

Answer Question   |  October 22, 2009  3:21 PM
AS/400 File Transfer, DB2
asked by:
15 pts.

data encryption
I am working on a project where I need to be able to pass a string through a SHA-2 encryption and then use the result as part of a call to open a URL.  The URL call is a breeze.., If there source code out there that has the SHA-2 algorithm that can run on the [...]

Answer Question   |  October 23, 2009  2:53 PM
AS/400 programming, Data Encryption, Java programming, SHA-2
asked by:
75 pts.

Change of IP address on MIMIx dr server
Hi, I want to change IP address of my AS/400 which is also the DR server (it has MIMIX on it), kindly tell what measure should i take for Mimix before changing the IP address. Please advice ,its urgent.

Answer Question   |  October 22, 2009  2:50 PM
MIMIX, MIMIX for AS/400
asked by:
325 pts.

Analyzing Security Audit Journal
Hello, could you please tell me where can I find a book, guide or course about Tracking and Analizing Security Audit Journal on iSeries?  I have tried Appendix F on Security Guide but there are not all entries and it does not explain how to analize records in journal.  Thanks a lot

Answer Question   |  November 5, 2009  2:46 PM
AS/400 audit, AS/400 journaling, AS/400 security, Security audits, V5R4
asked by:
15 pts.

OVRDBF
DCLF FILE(EMP001P)                                                                                                    RCvF RcdFmt(EMPREC)                                                                                                   OVRDBF FILE(EMP001P) TOFILE(EMP001P) MBR(SECOND) + SHARE(*YES)                                 MONMSG MSGID(CPF0000)  EXEC(SNDUSRMSG  MSG(“ERROR”) )                                                                 RCvF RcdFmt(EMPREC)                                        Here, I’m unable to overwrite the EMP001P file with second record. pls suggest correct way to do it.

Answer Question   |  October 22, 2009  2:18 PM
CLPROGRAM, OVRDBF
asked by:
Kar
425 pts.

Using prototypes and data structures
How do I convert the following into using prototypes (including the *ENTRY) and /free?? D RDCTL         E DS  EXTNAME(RDCTL)    

Answer Question   |  October 22, 2009  12:06 PM
RPG, V5R4
asked by:
90 pts.

How to copy source code of Pgm into Flatfile in COBOL
I want to read the one of the pgm’s source code through my another program. So anyone plz suggest me how can i read the source code?

Answer Question   |  October 23, 2009  8:55 AM
AS/400, CL/400, COBOL, COBOL/400
asked by:
50 pts.

AS/400 Software Migration Tool
Which AS/400 Software Migration Tool would you recommend with the most features at an exceptional value?

Answer Question   |  June 10, 2010  7:37 PM
AS/400 migration, AS/400 Software Migration Tool
asked by:
40 pts.

How to handle deletion in RPG
I have a file(A) that needs to have records deleted from it based off information in another file(B). I think the logic should be… Read A Chain to B if criteria met delete record. Is there a better/cleaner way to do this? I do not have much experience with RPG.

Answer Question   |  October 21, 2009  2:35 PM
RPG, RPG Record Deletion
asked by:
20 pts.

Is the new WRKDBF out yet?
Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

Answer Question   |  December 12, 2011  1:51 PM
AS/400, DB2, DB2UDB, i5, iSeries, WRKDBF
asked by:
5,505 pts.

decimal data error
I declare time field in RPG as D btime    4  0 eval btime = 2400 this one i pass to a CL program with var type var(&tim) type(*dec) len(4,0) and this in turn passed to another RPG program D stime    4  0 when it comes to third program it has some hex char shown in [...]

Answer Question   |  October 21, 2009  10:29 PM
Decimal Data Error, RPG, RPGLE
asked by:
895 pts.

Upload Spreadsheet to AS400 using Excel addin – creates graphic fields for alpha fields
I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is ‘Graphic’ when I display the file field definitions.  I cannot read these fields in my RPG program – they are only [...]

Answer Question   |  October 23, 2009  7:21 PM
AS/400, Excel 2007, Transfer Data To iSeries
asked by:
25 pts.

The most-watched IT questions this week: Oct. 20, 2009
Here are the 5 most watched questions on ITKE: There’s some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, [...]

Answer Question   |  October 21, 2009  6:20 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
asked by:
6,893 pts.

Suppress FTP messages
I’ve got a program that FTP’s (put) files to another system. I always used the program in batch mode. Now I’m trying to ref the program interactively. But message ‘Press ENTER to end terminal session.’ requires user intervention. Does any know how I can suppress FTP messages while running in interactive mode?

Answer Question   |  October 20, 2009  5:02 PM
AS/400 FTP, FTP Automation, FTP Send Notifications
asked by:
45 pts.

Tracking data changes on IBM i with triggers
Hi I like to implemnet this tip can you share the sources files of this tip

Answer Question   |  December 15, 2009  3:00 PM
AS/400 triggers, iSeries
asked by:
5 pts.

Domino on the iSeries and MS Excel
We have a LotusScript agent running on a Domino Windows server that opens an Excel spreadsheet and then processes each line of the file against data in the Domino DB. If we move our Domino platform from Windows to IBM iSeries, what additional considerations do we need in order for this process to function on [...]

Answer Question   |  October 26, 2009  1:46 PM
IBM i, Lotus Domino, LotusScript
asked by:
5 pts.