I want to know how I can use the query in the AS/400?
Answer Question | January 23, 2013 9:36 AM
AS/400, AS/400 Query
Could you help me create script for AS/400 MAM console? Script should check first line in console (every minute) and delete it IF the same text exist in other text file.
Answer Question | January 23, 2013 10:37 PM
AS/400, AS/400 scripts
I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is … how to do this without re-creating the PF? I did this once (4 years ago) but I don’t remember what command I used to make it “take” (just changing the source [...]
Answer Question | January 22, 2013 7:34 PM
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
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
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
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
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
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
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
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
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
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
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
How is this accomplished ? thx.
Answer Question | January 16, 2013 8:30 PM
IFS Directory to iSeries Folder
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
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
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
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
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