AS/400 Full Back-up
hi, I have installed an iseries 9405-520 i5/OS V5R3M0 and the informatician have done all the aplication in B-boot mode. Has this any impact in the machine. Can i reboot in the A-boot mode???? And the last : i want to do a full back-up of the machine. Can you help me with some instructions……

Answer Question   |  May 6, 2012  4:58 PM
AS/400, Help Desk, Tech support

timestamp value
Hi, I am receiving TIMESTAMP value from the iSeries system as an unsigned 64 bit integer value. Is it possible to convert this timestamp into a readable format in windows machine? The iSeries timestamp value is an unsigned 64 bit integer value. All the time management routines which I can use on a windows machine [...]

Answer Question   |  July 21, 2005  9:39 AM
Backup & recovery, i5, iSeries, OS/400, tips and tricks, Tools

iSeries Access ODBC Driver Error
I’m trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider ‘MSDASQL’ reported an error. [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 – Error occurred in the OS/400 database server code.] OLE DB [...]

Answer Question   |  October 30, 2009  4:41 PM
AS/400, Data analysis, Data mining/analysis, DataCenter, Tech support

5733SC1; ability to sftp to a Unix box
I have a need to get information from an i5 to a Unix box. And it has to be unattended. Catch; Unix is allowing only SFTP (not i5′s definition of secure ftp, the Unix definition. Port 22). So, FTP isn’t an option. In all IBM & everyone else’s ‘documentation’ about all can find out is [...]

Answer Question   |  May 25, 2010  3:11 PM
i5, iSeries, OS/400

system date in RPG
We have a dataq job that runs constantly. There are trigger programs on some files that control what is sent to the dataq which in turn prints certain forms at the correct outq. is there a ‘date’ variable that will reflect NOW? Udate and *date gives the same thing – the job start date. i [...]

Answer Question   |  November 9, 2010  11:21 AM
RPG

STRDSKRGZ, TRCASPBAL, and STRASPBAL commands.
Are any of you familiar with using these commands, the amount of time it takes to perform these commands, the requirements (restricted system or not, etc.), or where I can obtain some documentation on these commands so I can read up on them? I appreciate the info and help.

Answer Question   |  October 25, 2010  9:17 AM
STRASPBAL, STRDSKRGZ, TRCASPBAL

Converting Float to packed
I am trying to convert a Float8 to a 17 6 Packed and I am loosing 1/100000th of the value of the decimal portion. The packed result is 1/100000th less than the Float value. How do I stop this from happening? I am calculating taxes.

Answer Question   |  October 29, 2009  2:36 PM
RPG

small doubt
Hi, I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions: - in the RJNE0200 format, there [...]

Answer Question   |  July 18, 2005  7:26 AM
Backup & recovery, DB2, Hardware, i5, iSeries, OS/400, Security, tips and tricks, Tools, UDB for iSeries/i5

Backup on V5R2 and Restore on V4R5
I have to Systems( one AS/400 running OS/400 V4R5 and An iSeries running i5/OS V5R2). Can I backup for example a file on the machine running V5R2 and restore on the one running V4R5?

Answer Question   |  October 25, 2010  10:40 AM
AS/400 backup, Backup, V4R5, V5R2

Printing Array in Set Order
I have an array that needs to hold 59 variable possibilities -3 chars each, except for 6 of them-they are only 2 each. On the last line of my RPGILE program…how can I do this to set the printing order of these elements? Not only do I get a size error, but also–the 2 char [...]

Answer Question   |  October 29, 2009  11:16 AM
RPG

File transfer to the iSeries problem.
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error cwbtf0023 – pc file description file was not specified or is empty The file is not empty. [...]

Answer Question   |  December 9, 2011  10:11 AM
AS/400, Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools

iSeries configuration for a DeskJet 940C
I’m trying to set up a networked DeskJet 940C using a *RMT (LPR/LPD) OUTQ. Per IBM doc, I’m using *HP500 for the MFRTYPMDL, but I can’t seem to get the remote outq right. I’ve tried ‘text’, ‘raw’, ‘prt1′, ‘pr1′, and ‘lpt1′ in both lower and upper case with no success. I would want to set [...]

Answer Question   |  October 25, 2010  10:30 AM
i5, iSeries, OS/400, Printing

Is *JOBCTL needed to view job logs?
I have read IBM’s Security manual and Work Management manual and I know that *JOBCTL is needed to change job priorities and other things for jobs on the system, but I do not see any statements that say *JOBCTL is needed to view the job logs of other user’s jobs on the system. Does anyone [...]

Answer Question   |  October 25, 2010  2:09 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools

Spooled files cannot be displayed
When I try to display the spooled files, I get the “File no longer in the system” prompt.I cannot move the file, etc…I know my CL and RPGLE have to be somewhat in sync or I would not be getting the spooled files to even show up in the queue. I only have 1 year [...]

Answer Question   |  July 12, 2005  8:55 AM
RPG

BRMS on iSeries Multiple LPARs
How do I get BRMS to perform backups from multiple LPARs to a single LTO3 tape, on the same day?

Answer Question   |  April 2, 2010  1:07 PM
AS/400, Backup & recovery, IBM

passing array as parameter
Hi all How can we pass a character array as parameter from one RPG program to another ? Regards Skapoor

Answer Question   |  October 28, 2009  9:28 AM
RPG

Reclaim System Storage
I was considering doing a reclaim system storage this weekend, but was just curiuos if anyone wanted to share how long their’s took to run in the past. We have a 820 model with about 78% of 510GB being used. it has 4GB of memory and processor speed is rated at 2350CP. I was planning [...]

Answer Question   |  October 28, 2009  1:02 PM
i5, iSeries, OS/400, Performance/Tuning

Check for active jobs in CL
How can I check for a active job in my CL?

Answer Question   |  October 25, 2010  9:47 AM
iSeries

Convert Excel file to AS400
I have ‘n’ number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files [...]

Answer Question   |  July 1, 2005  4:38 AM
RPG, Tech support, VBA

Printing a Signature Font
Has anyone programmed a font in a printer file that prints a signature? We have an HP4250 with a memory card containing this font. We were given by the vendor a control string to specify in the program. I think I need to customize a Work Station Customizing Object (WSCST) for the printer and for [...]

Answer Question   |  July 15, 2005  11:16 AM
Development, Graphical User Interfaces, RPG