Reset Password of a UserProfile
Hi Group, How do we reset the password of a UserProfile in AS/400? Regards, M

Answer Question   |  January 22, 2013  11:02 AM
AS/400, AS/400 Profiles

Viewing stored procedure statements in AS/400
Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don’t know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

Answer Question   |  January 22, 2013  10:26 AM
AS/400, SQLRPGLE, STRSQL

iSeries query: Compare two fields in one file
Try to do a multiple select statement and then compare the results of that statement. See below: SELECT “T16.APAR”.P._PARCEL_NR FROM QS36F.”T16.APAR” WHERE “T16.APAR”.P_PARCEL_NR NE “T16.APAR”.P_PARCEL_NR (SELECT “T16.APAR”.P_PARCEL_NR FROM QS36F.”T16.APAR” AS “T16.APAR” WHERE “T16.APAR”.P_YEAR = 2012 AND “T16.APAR”.P_ROLL_TYPE = ‘R’ AND “T16.APAR”.P_EXCLUSION_VALUE > 1; (SELECT “T16.APAR”.P_PARCEL_NR FROM QS36F.”T16.APAR” AS “T16.APAR” WHERE “T16.APAR”.P_YEAR = 2013 AND “T16.APAR”.P_ROLL_TYPE [...]

Answer Question   |  January 21, 2013  3:11 PM
AS/400, AS/400 queries, iSeries

CL/400
I need to copy records from work link to our database file, so I am using CPYFRMIMPF command in the following way CPYFRMIMPF FROMSTMF(&LINK) TOFILE(SRINSOFT/EDI850WK) + MBROPT(*REPLACE) RCDDLM(*CRLF) + DTAFMT(*DLM) STRDLM(‘”‘) FLDDLM(‘,’) + FROMRCD(2 *END) My worklink has 5 records but it copies only the 2nd and 4th record to my database file. What is [...]

Answer Question   |  January 21, 2013  12:00 PM
CL command, CPYFRMIMPF

Problem with the READ from PF in RPGLE
Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program [...]

Answer Question   |  January 18, 2013  6:47 AM
AS400 RPGLE, reading Physical file

Deleting IFS files
Would anyone be able to help me with the following code? I modified it to delete entries in a folder older that 35 days from today’s date when the program is run. Thanks in advance for any assistance you can offer. PGM DCL &TODAY *CHAR 6 DCL &TODAY2 *CHAR 6 DCL &MBRDATE *CHAR 10 ADDLIBLE [...]

Answer Question   |  January 17, 2013  7:37 PM
IFS, IFS Folder

Job log spool file of a running job
Can I create a spool file of the job log of a currently running job on the system?

Answer Question   |  January 17, 2013  6:32 PM
OS/400, OS/400 spool file

How to implement MOUBTN using RPG III/RPG400
We are converting some code in a legacy application and, in its simplest form, want to know that a mouse has been used/clicked rather than ENTER pressed. We are not that familiar with the MOUBTN keyword, which we assume will tell us what we want, and are having trouble getting this to work. Though we’ve [...]

Answer Question   |  January 17, 2013  2:58 PM
AS/400, DSPF, MOUBTN, Mouse, RPG III, RPG/400

Expression to insert value to a table column in SQL
My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C – (13,5) D [...]

Answer Question   |  January 17, 2013  10:11 AM
AS/400, SQL

SQLRPGLE- Query Not fetching records in program
Hi I have below query in my program , when i executed it interactively thro strsql , its fetching records but the same query is not fetching records when i execute it in my program. Please provide your valuable answers as soon as possible.. as i need it very urgently… As si mentioned it has [...]

Answer Question   |  January 17, 2013  7:28 AM
AS/400, i series, IBM, SQLRPGLE

UserProfiles in AS/400
Hi Group, I am unable to access my UserProfile, I checked the status its in “ENABLED” state. What could be done to access it. What are the reasons for the UserProfile in AS/400 being disabled. Regards, MVRK

Answer Question   |  January 17, 2013  12:17 AM
AS/400, AS/400 administration, OS/400

moving file from ifs into qgpl
How is this accomplished ? thx.

Answer Question   |  January 16, 2013  8:30 PM
IFS Directory to iSeries Folder

Can’t print correct library list out with Java
We have several customers running on our hardware. For these customers we set up job descriptions to keep library list information since they all have their own database files. I have a Java program that runs as a batch program at a set time to update a database file for each customer. I create these [...]

Answer Question   |  January 16, 2013  5:24 PM
Java, SBMJOB, WRKJOBSCDE

Determine if a submitted job has completed
Hello ALL — I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted [...]

Answer Question   |  January 18, 2013  3:56 PM
CL Program, iSeries, QUSRJOBI

Is there a way to recover the source code from a program?
Hi, I lost the source code of a program with a couple of modules, but I have the *PGM and *MODULE which were compiled with *ALL in debug option. is there a way to dump the source code in a source physical file or in some place? Thanks.

Answer Question   |  January 14, 2013  3:00 PM
AS/400, AS/400 debugging

Data area in RPGLE
I want to create an id that is auto incrementing in RPGLE using data area.

Answer Question   |  January 14, 2013  10:27 AM
RPGLE, RPGLE code

Deleting IFS records after so many days
Can anyone provide CL code that would delete records within a date range? I would like to delete entries, say-that are 35 days old from the IFS.

Answer Question   |  January 14, 2013  7:32 PM
AS/400, CL Commands, IFS

Web servers
Having created a website, how does one load it onto an open source web server?

Answer Question   |  January 14, 2013  1:42 PM
Web Server, Web server administration

How to change fields from one type to another type in display file
I created one display file and declare numeric field as output i.e +6(10).please tell me how to change that field from output to input&output i.e +9(10).

Answer Question   |  January 14, 2013  10:30 AM
AS/400, AS/400 Fields

How to change display file text after compilation
I created one display file after compilation when I am trying to edit some text in that display file using option 2.when I type the new text, it displays only capital letters only. I am unable to type lower case letters. Please tell me how to type small case letters in that display file.

Answer Question   |  January 14, 2013  8:50 AM
AS/400, as/400 files