Physical file
While compiling physical file, it is submitted to Batch. I don’t want to submit to Batch. Please give me a solution.
Answer Question
| January 24, 2013 6:37 AM
AS/400, Physical File
While compiling physical file, it is submitted to Batch. I don’t want to submit to Batch. Please give me a solution.
Answer Question
| January 24, 2013 6:37 AM
AS/400, Physical File
perform IPL at anytime, when a backup is running in cluster(v7R1)
How to perform IPL in iSeries server (Main server) when backup running in Cluster (backup server). I want to perform IPL at anytime, including when a backup is running in cluster. Is there any consequences if we perform IPL when backup is running in cluster? Please provide me the procedure and explain the situation in [...]
Answer Question
| January 24, 2013 7:12 PM
AS/400 administration, AS/400 IPL, iSeries administration
How to perform IPL in iSeries server (Main server) when backup running in Cluster (backup server). I want to perform IPL at anytime, including when a backup is running in cluster. Is there any consequences if we perform IPL when backup is running in cluster? Please provide me the procedure and explain the situation in [...]
Answer Question
| January 24, 2013 7:12 PM
AS/400 administration, AS/400 IPL, iSeries administration
Spool file too wide for PDF
I am creating a spool file as a PDF. The spool file has a width of 198, but when it is created as a PDF about 20 columns on the right hand side are truncated. When the spool file is sent directly to the printer the font is reduced correctly to fit the report on [...]
Answer Question
| January 23, 2013 1:00 PM
AS/400, iSeries printing
I am creating a spool file as a PDF. The spool file has a width of 198, but when it is created as a PDF about 20 columns on the right hand side are truncated. When the spool file is sent directly to the printer the font is reduced correctly to fit the report on [...]
Answer Question
| January 23, 2013 1:00 PM
AS/400, iSeries printing
How to download data from DB2/400 table
Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.
Answer Question
| January 23, 2013 11:50 AM
DB2/400, unload utility
Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.
Answer Question
| January 23, 2013 11:50 AM
DB2/400, unload utility
Query in AS/400
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
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
Script on AS/400 MAM Console
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
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
How to change a field description
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
AS/400, DDS
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
AS/400, DDS
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
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
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
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
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
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
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
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
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
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
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
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
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
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
