AS/400 Tag Directory

Featured AS/400 Questions

Convert time stamp to dd/mm/yy
How can I convert a timestamp field(declared with type ‘Z’ in database) to dd/mm/yy format in RPG?

Answer Question   |  May 16, 2013  11:39 AM
AS/400, AS/400 date format, RPG
asked by:
1,975 pts.

Using pointers
I need to update a lot of fields in a record testing on an internal array if that field is “updatable”. This should be: FILEFIELD001 = DSFIELD001  for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words, instead [...]

Answer Question   |  May 13, 2013  9:53 AM
AS/400, AS/400 Fields, Pointers
asked by:
15 pts.

CPYF alternative
Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this…are there any alternate solutions to copy [...]

Answer Question   |  May 13, 2013  6:26 AM
AS/400, AS/400 jobs, CPYF
asked by:
525 pts.

Deleting SAVED journal receivers
I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.

Answer Question   |  April 30, 2013  7:11 PM
AS/400, AS/400 journaling, CL Program
asked by:
145 pts.

Object is currently in use
We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?

Answer Question   |  April 29, 2013  10:22 AM
AS/400, AS/400 jobs
asked by:
450 pts.

AS/400 (8203-E4A): no display
AS/400 (8203-E4a) cannot display console. We were forced to IPL.  The AS/400 stops on code B150B10C.

Answer Question   |  April 29, 2013  11:08 PM
AS/400, AS/400 IPL
asked by:
25 pts.

How to find members of a group profile
How do I find members of a group profile in AS/400?

Answer Question   |  April 29, 2013  5:32 PM
AS/400, AS/400 administration, AS/400 group profiles
asked by:
265 pts.

Search for a data in the file in all the library
I have a file which has an ID field and description. The same file is present in many library. I am trying to create an utility which will ask for the ID and it should display all the library which has the file with that ID in it. How can I achieve this? How to [...]

Answer Question   |  April 25, 2013  7:06 AM
AS/400, AS/400 Library
asked by:
1,975 pts.

iSeries native job scheduler -QJOBSCD
I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It’s still active and the job scheduler is working fine.

Answer Question   |  April 22, 2013  1:41 PM
AS/400, AS/400 jobs, iSeries
asked by:
265 pts.

Display file level check identifier change
Hi all! I have a display file in LIB001 and its having many screen files and Window file, I just wanted to add one more screen file in this case. 1. Do I need to compile the Display file? 2. If compile the display file, its linked with many RPG, CL programs, so obviously I [...]

Answer Question   |  April 22, 2013  8:40 AM
AS/400, AS/400 Display File
asked by:
1,485 pts.

Date conversion
I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value ’20121001′ *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?

Answer Question   |  April 18, 2013  6:00 AM
AS/400, AS/400 Fields
asked by:
1,975 pts.

Field of type date(L)
I have a date field in my display file. When I enter an invalid date, it gets highlighted automatically. I want to show the user that the entered date is invalid through a message in the display file. How to do it?

Answer Question   |  April 11, 2013  2:10 PM
AS/400, AS/400 Display File
asked by:
380 pts.

Merging columns from 2 different files
I want to merg data from 2 different files.  1 column in both files has same type of data but the headers (Library and Libraries) are different and the fieldnames (ODLBNM & MLLIB).  Is there a way to merge both columns into 1 column?

Answer Question   |  April 5, 2013  10:17 PM
AS/400, as/400 files
asked by:
brl
20 pts.

How to read from flat file
How to read from flat file For eg: The data in one flat file is like this D|EMPN0001_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|IT|||||LC|100 D|EMPN0002_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|ECE|||||LC|100 The data in another flat file is like this: D|EMPN0001|N||.048448|.048448|100.0000|0.0000|100.0000|77.7782|EMP02|CME02|LM D|EMPN0002|N||1.000000|1.000000|100.0000|0.0000|100.0000|35.8566|EMP02|CME02| D|EMPN0003|N||.025600|.025600|100.0000|0.0000|100.0000|100.0000|EMP02|CME02|L I want to read these two files and stores these values in a separate Physical files. Main purpose is that to compare the values [...]

Answer Question   |  March 28, 2013  5:49 AM
AS/400, as/400 files
asked by:
135 pts.

Size of a save file in AS/400
Hi, I would like to know is there any way to find out the size of a save file in AS/400 in bytes.

Answer Question   |  March 27, 2013  3:34 PM
AS/400, as/400 files
asked by:
760 pts.

About EVAL OPCODE
I have a field which is declared as alphanumeric and the default value for the variable is blank. Now I have declared one more variable which is of zoned decimal type. Now I want to move the value in the alphanumeric variable which is blank into the field, which is declared as zoned decimal. Will [...]

Answer Question   |  March 21, 2013  11:01 AM
AS/400, AS/400 Fields
asked by:
290 pts.

About AS/400
I have an object library and my source code is in object library and the files which are opened in output/update mode in the PGM are in my object library and the file which is opened in input mode is in another object library. Now I included two object libraries to my library list and [...]

Answer Question   |  March 18, 2013  11:50 AM
AS/400, AS/400 error messages
asked by:
290 pts.

About library list in AS/400
Hi, there is a source library for me where I created a module and I binded it to a program with the command ‘CRTPGM’. Now I have created the object of that module in the object library. Now my question is how do I need to organize the library list when the things are as [...]

Answer Question   |  March 15, 2013  4:10 AM
AS/400, AS/400 Library
asked by:
290 pts.

AS/400 / CF DESC
Hello I am trying find a way to change the Customer Friendly Description in the SKU (SKN) DESC. 

Answer Question   |  March 13, 2013  9:21 AM
AS/400, AS/400 database
asked by:
10 pts.

ASCENTER scheduling question
Can a job be scheduled thru as/center to run on the 3rd BUSINESS day of the month and not just on the 3rd day of the month. If so, how?

Answer Question   |  March 6, 2013  4:26 PM
AS/400, AS/400 job scheduler
asked by:
5 pts.