Copying records
Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.
Answer Question
| February 5, 2013 12:55 PM
AS/400, AS/400 Records
Hi, I need to copy records from one file (SERVER1) to another file (SERVER2) with same field definitions. It has to be run as a daily job. Please guide me.
Answer Question
| February 5, 2013 12:55 PM
AS/400, AS/400 Records
Date minus 1 month in January
AS/400 query, when I have TODAY = current(date), then when today – 1 month, If the current date is Jan 1, 2013, will it be Dec 1, 2013 or Dec 1, 2012? I assume Dec 1, 2012, but want to be sure. Likewise, on Mar 1, 2013 current, it would give Feb 1, 2013, correct [...]
Answer Question
| February 5, 2013 11:49 AM
AS/400, AS/400 Query
AS/400 query, when I have TODAY = current(date), then when today – 1 month, If the current date is Jan 1, 2013, will it be Dec 1, 2013 or Dec 1, 2012? I assume Dec 1, 2012, but want to be sure. Likewise, on Mar 1, 2013 current, it would give Feb 1, 2013, correct [...]
Answer Question
| February 5, 2013 11:49 AM
AS/400, AS/400 Query
FTP from AS/400 to Windows 2003 Server
How to transfer(FTP) through a file from AS/400 green screen to Windows Server 2003? *********************** from AS/400 green screen FTP ” windows server IP ” user id passwd bin lcd mylib pwd “/” is current directory ???? // { I didn’t get any path from Windows Server } put mylib/itms 227 Entering Passive Mode (172,20,160,25,9,152) [...]
Answer Question
| February 5, 2013 7:09 AM
AS/400, FTP, Windows Server 2003
How to transfer(FTP) through a file from AS/400 green screen to Windows Server 2003? *********************** from AS/400 green screen FTP ” windows server IP ” user id passwd bin lcd mylib pwd “/” is current directory ???? // { I didn’t get any path from Windows Server } put mylib/itms 227 Entering Passive Mode (172,20,160,25,9,152) [...]
Answer Question
| February 5, 2013 7:09 AM
AS/400, FTP, Windows Server 2003
Unreadable spool file
Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an [...]
Answer Question
| February 4, 2013 11:48 AM
AS/400, AS/400 Spool Files, iSeries Navigator
Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an [...]
Answer Question
| February 4, 2013 11:48 AM
AS/400, AS/400 Spool Files, iSeries Navigator
Delete 72 hours old record from a file using SQLRPGLE
I have a file containing two fields…First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.
Answer Question
| February 4, 2013 11:09 AM
AS/400, SQLRPGLE
I have a file containing two fields…First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.
Answer Question
| February 4, 2013 11:09 AM
AS/400, SQLRPGLE
See save file in a library
How to see only save file in a library?
Answer Question
| February 4, 2013 10:55 AM
AS/400, AS/400 administration
How to see only save file in a library?
Answer Question
| February 4, 2013 10:55 AM
AS/400, AS/400 administration
Duplicate records in a keyed physical file
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
Cursor is returning previous values in SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check [...]
Answer Question
| February 1, 2013 5:10 AM
AS/400, SQLRPGLE
Outfile for WRKJOB command.
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now [...]
Answer Question
| February 1, 2013 9:30 PM
AS/400, AS/400 commands, AS/400 jobs
Validate date in COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400…. Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.
Answer Question
| January 31, 2013 7:22 PM
COBOL, COBOL/400
Examples of AS/400 create alias in Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
QTEMP file not removed
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question
| January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
Certification RPG
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
Hi, I am planning to do certification in AS/400. I don’t have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi
Answer Question
| January 31, 2013 10:01 AM
AS/400, AS/400 certification
New record can not be added
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?
Answer Question
| January 31, 2013 12:30 AM
iSeries, Norwat system
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?
Answer Question
| January 31, 2013 12:30 AM
iSeries, Norwat system
AS/400 administration
How to know disk space on AS/400?
Answer Question
| January 30, 2013 10:52 AM
AS/400, AS/400 administration
How to know disk space on AS/400?
Answer Question
| January 30, 2013 10:52 AM
AS/400, AS/400 administration
AS/400 administration
how less % system ASP used . . : 90.6553 30/01/13 12:04:42 % CPU used . . . . . . . : 16.5 Auxiliary storage: % DB capability . . . . : 10.2 System ASP . . . . . . : 181.1 G Elapsed time . . . . . . : [...]
Answer Question
| January 30, 2013 10:05 AM
AS/400, AS/400 administration
how less % system ASP used . . : 90.6553 30/01/13 12:04:42 % CPU used . . . . . . . : 16.5 Auxiliary storage: % DB capability . . . . : 10.2 System ASP . . . . . . : 181.1 G Elapsed time . . . . . . : [...]
Answer Question
| January 30, 2013 10:05 AM
AS/400, AS/400 administration
Panasonic CF-H2 Toughbook
I am running Client Access Ver5.5 on a Panasonic CF-H2 Toughbook. When I initiate the built-in scanner on the Toughbook to scan a barcode, the device beeps signifying a good scan, but the Client Access session is not displaying the data. If I initiate the scan on a barcode in note pad, it displays the [...]
Answer Question
| January 30, 2013 9:17 PM
AS/400 Client Access, Client Access
I am running Client Access Ver5.5 on a Panasonic CF-H2 Toughbook. When I initiate the built-in scanner on the Toughbook to scan a barcode, the device beeps signifying a good scan, but the Client Access session is not displaying the data. If I initiate the scan on a barcode in note pad, it displays the [...]
Answer Question
| January 30, 2013 9:17 PM
AS/400 Client Access, Client Access
User profile being disabled
We have one user that is having issues with her profile being disabled. This only happens on Mondays, she signs in once, and it tells her she is disabled. I enable her, only to have this happen again the next Monday. I am not sure how to track this or where to look to correct. [...]
Answer Question
| January 29, 2013 5:02 PM
AS/400, AS/400 user profiles
We have one user that is having issues with her profile being disabled. This only happens on Mondays, she signs in once, and it tells her she is disabled. I enable her, only to have this happen again the next Monday. I am not sure how to track this or where to look to correct. [...]
Answer Question
| January 29, 2013 5:02 PM
AS/400, AS/400 user profiles
RPGLE
I need to change primary and secondary file into full procedure file. Can anybody help me?
Answer Question
| January 29, 2013 2:21 PM
RPGLE, RPGLE files
I need to change primary and secondary file into full procedure file. Can anybody help me?
Answer Question
| January 29, 2013 2:21 PM
RPGLE, RPGLE files
