I want to reterive all users list with last logon date inculuded(help me with the query)
Display User Profiles to an Outfile DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIB/USRPRFS) Create a Query to access MYLIB/USRPRFS and include the field UPPSOD, Previous Sign on Date. Should be pretty simple, Bill ============================================================== Be aware that you need to define “last logon date” before you can be certain. A user profile might “logon” through FTP on a [...]
View Answer
| August 10, 2010 1:59 AM
AS/400 queries, Query/400, V4R5
Display User Profiles to an Outfile DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIB/USRPRFS) Create a Query to access MYLIB/USRPRFS and include the field UPPSOD, Previous Sign on Date. Should be pretty simple, Bill ============================================================== Be aware that you need to define “last logon date” before you can be certain. A user profile might “logon” through FTP on a [...]
View Answer
| August 10, 2010 1:59 AM
AS/400 queries, Query/400, V4R5
Is there any way to get all the name of the Modules attached in a PGM?
did you try DSPPGMREF command? =========================================================== To get the list of modules that make up an ILE program, use the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/qbnlpgmi.htm”>List ILE Program Information (QBNLPGMI) API</a> and request format PGML0100 — ILE program module (*MODULE) information. The list will be created in a user space that you supply. Tom
View Answer
| August 10, 2010 1:38 AM
API, DSPPGM, RPGILE
did you try DSPPGMREF command? =========================================================== To get the list of modules that make up an ILE program, use the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/qbnlpgmi.htm”>List ILE Program Information (QBNLPGMI) API</a> and request format PGML0100 — ILE program module (*MODULE) information. The list will be created in a user space that you supply. Tom
View Answer
| August 10, 2010 1:38 AM
API, DSPPGM, RPGILE
ASP Increased over night; how do I get it back to a normal level?
The problem is that it might be temporary space in a job, e.g., a server job; and the space might be released when that server job ends or even recycles. It might be a big bunch of streamfiles in the IFS — someone might be storing their video collection in your system. It might be [...]
View Answer
| August 10, 2010 1:23 AM
AS/400, ASP, DASD
The problem is that it might be temporary space in a job, e.g., a server job; and the space might be released when that server job ends or even recycles. It might be a big bunch of streamfiles in the IFS — someone might be storing their video collection in your system. It might be [...]
View Answer
| August 10, 2010 1:23 AM
AS/400, ASP, DASD
AS/400 auditing user profiles
First, review the answer to: Is there any way to tell who added a record to the system reply list? That item describes a method of looking for a different kind of audit journal entry, but the method is the same. The differences are:<ol> <li>Start with model file QASYDOJ5 from QSYS and create the duplicate [...]
View Answer
| June 13, 2013 10:56 PM
AS/400, AS/400 audit, AS/400 user profiles
First, review the answer to: Is there any way to tell who added a record to the system reply list? That item describes a method of looking for a different kind of audit journal entry, but the method is the same. The differences are:<ol> <li>Start with model file QASYDOJ5 from QSYS and create the duplicate [...]
View Answer
| June 13, 2013 10:56 PM
AS/400, AS/400 audit, AS/400 user profiles
Is there any way to tell who added a record to the system reply list?
Yes, assuming that you have your system configured to track such things. These commands can obviously be put into a CL program and many parameter changes are possible. This sequence does the task from the QCMD command entry screen. Go into QCMD and press F11=Display full, to get more entry lines. Then copy/paste the commands [...]
View Answer
| August 9, 2010 10:08 PM
AS/400 Records, i5/OS, iSeries
Yes, assuming that you have your system configured to track such things. These commands can obviously be put into a CL program and many parameter changes are possible. This sequence does the task from the QCMD command entry screen. Go into QCMD and press F11=Display full, to get more entry lines. Then copy/paste the commands [...]
View Answer
| August 9, 2010 10:08 PM
AS/400 Records, i5/OS, iSeries
is data uploading on an HTTPS site as secure as using sFTP?
Both HTTPS and SFTP are secure regarding data uploading. What the last person said is exactly what the original post person Topmac already knows, that’s why they asked the question. I would just like to say to Topmac I use HTTPS and everyone I know that hosts’ a secure site uses HTTPS, I’m not an [...]
View Answer
| August 9, 2010 8:42 PM
File Transfer Protocols, ftp upload, HTTPS, SFTP
Both HTTPS and SFTP are secure regarding data uploading. What the last person said is exactly what the original post person Topmac already knows, that’s why they asked the question. I would just like to say to Topmac I use HTTPS and everyone I know that hosts’ a secure site uses HTTPS, I’m not an [...]
View Answer
| August 9, 2010 8:42 PM
File Transfer Protocols, ftp upload, HTTPS, SFTP
How to display audited user profiles in AS/400
The system value QAUDCTL controls turning auditing on and off. The auditing attributes of a user profile can be displayed with the Display User Profile (DSPUSRPRF) command.
View Answer
| June 13, 2013 8:00 PM
AS/400, AS/400 audit, AS/400 user profiles
The system value QAUDCTL controls turning auditing on and off. The auditing attributes of a user profile can be displayed with the Display User Profile (DSPUSRPRF) command.
View Answer
| June 13, 2013 8:00 PM
AS/400, AS/400 audit, AS/400 user profiles
as400 user id question
you can do this the old fashion way using the CRTUSRPRF command. or you can add users through the iSeries Access for Windows software (Operations Navigator) I tend to copy existing profiles once I’ve got a good template to work with. Of course you’ve got all kinds of questions to answer about security when setting [...]
View Answer
| August 9, 2010 1:17 PM
AS/400 administration, AS/400 user profiles
you can do this the old fashion way using the CRTUSRPRF command. or you can add users through the iSeries Access for Windows software (Operations Navigator) I tend to copy existing profiles once I’ve got a good template to work with. Of course you’ve got all kinds of questions to answer about security when setting [...]
View Answer
| August 9, 2010 1:17 PM
AS/400 administration, AS/400 user profiles
How do we find defective PTFs in the server, which are already installed?
You would compare the list of defective PTFs at the end of the <a href=”http://www-912.ibm.com/s_dir/sline003.nsf/2d3aff1c6b4d6ce086256453000d971e/b2122089a6a407da862576250055977b?OpenDocument”>Summary of HIPER and Defective PTFs</a> against a list of PTFs from your system. (The link is for V5R4.) Any PTFs that match and are either permanently or temporarily applied are defective PTFs that are installed on your system. Tom
View Answer
| August 8, 2010 7:09 AM
AS/400, PTFs
You would compare the list of defective PTFs at the end of the <a href=”http://www-912.ibm.com/s_dir/sline003.nsf/2d3aff1c6b4d6ce086256453000d971e/b2122089a6a407da862576250055977b?OpenDocument”>Summary of HIPER and Defective PTFs</a> against a list of PTFs from your system. (The link is for V5R4.) Any PTFs that match and are either permanently or temporarily applied are defective PTFs that are installed on your system. Tom
View Answer
| August 8, 2010 7:09 AM
AS/400, PTFs
Reading logical with different key fields scenario
Yes, to use native i/o you will need additional logical files. Phil ================================================= Phil is generally right. If you must use native I/O, you might need a number of additional logical files. This is one reason that SQL might be used instead of native I/O. You can use a dynamic statement to specify an ORDER [...]
View Answer
| August 8, 2010 6:54 AM
AS400 physical file, Logical Files, OS/400, Physical Files
Yes, to use native i/o you will need additional logical files. Phil ================================================= Phil is generally right. If you must use native I/O, you might need a number of additional logical files. This is one reason that SQL might be used instead of native I/O. You can use a dynamic statement to specify an ORDER [...]
View Answer
| August 8, 2010 6:54 AM
AS400 physical file, Logical Files, OS/400, Physical Files
what is the query to be used in openquery file to read records in reverse from a database file
Sounds like you need the keyfield keyword, list each field with descending ..check help it’s desc, or something like that. Phil
View Answer
| August 7, 2010 1:39 PM
AS/400, CL Commands, Open Query, V5R3
Sounds like you need the keyfield keyword, list each field with descending ..check help it’s desc, or something like that. Phil
View Answer
| August 7, 2010 1:39 PM
AS/400, CL Commands, Open Query, V5R3
convert physical file to spoolfile?
In the last stage you use CPYF from your dbf file to QSYSPRT. Phil However, as was noted previously, changing report dates is not a good thing.
View Answer
| August 7, 2010 1:35 PM
AS/400, AS/400 Spool Files, Physical Files
In the last stage you use CPYF from your dbf file to QSYSPRT. Phil However, as was noted previously, changing report dates is not a good thing.
View Answer
| August 7, 2010 1:35 PM
AS/400, AS/400 Spool Files, Physical Files
how to convert physical file to spool file?
Physical files don’t convert to spooled files. However, you can generate a spooled file from a physical file.<pre> RUNQRY QRYFILE(( mylib/myfile )) OUTTYPE(*PRINTER)</pre> The RUNQRY command can print records from a physical file with very little effort. There are other parameters that may help. If the Query/400 product is installed, record selection is also available [...]
View Answer
| August 7, 2010 4:26 AM
AS/400, AS/400 Spool Files, File conversion, Physical File
Physical files don’t convert to spooled files. However, you can generate a spooled file from a physical file.<pre> RUNQRY QRYFILE(( mylib/myfile )) OUTTYPE(*PRINTER)</pre> The RUNQRY command can print records from a physical file with very little effort. There are other parameters that may help. If the Query/400 product is installed, record selection is also available [...]
View Answer
| August 7, 2010 4:26 AM
AS/400, AS/400 Spool Files, File conversion, Physical File
AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.
Access to SQL Server from a different platform is done the same way almost all databases are accessed cross-platform. Download the driver from the vendor for the platform you’re running on. The only driver that I’m aware of that Microsoft currently makes available that will run on your AS/400 is the <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en”>Microsoft SQL Server [...]
View Answer
| August 7, 2010 4:03 AM
API, AS/400, COBOL, iSeries, SQL Server, V5R4
Access to SQL Server from a different platform is done the same way almost all databases are accessed cross-platform. Download the driver from the vendor for the platform you’re running on. The only driver that I’m aware of that Microsoft currently makes available that will run on your AS/400 is the <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en”>Microsoft SQL Server [...]
View Answer
| August 7, 2010 4:03 AM
API, AS/400, COBOL, iSeries, SQL Server, V5R4
Error using CPYFRMIMPF
The problem is with the raw data, something isn’t formated correctly. When you bring it into Excel and then save it, that error is corrected by Excel. Before you’ve used excel to “Fix” the record, inspect it with notepad (not wordpad) You will find something different at the end of the third record or in [...]
View Answer
| August 7, 2010 3:32 AM
AS/400, AS/400 administration, CPYFRMIMPF, CSV file format
The problem is with the raw data, something isn’t formated correctly. When you bring it into Excel and then save it, that error is corrected by Excel. Before you’ve used excel to “Fix” the record, inspect it with notepad (not wordpad) You will find something different at the end of the third record or in [...]
View Answer
| August 7, 2010 3:32 AM
AS/400, AS/400 administration, CPYFRMIMPF, CSV file format
Loading multiple subfields in RPGLE
You load two subfiles the same way you load one subfile except you will have two loops to write the subfile record formats instead of just one loop. And if you want to load three subfiles, you will code three loops, one loop for each subfile record format. If you want to load four subfiles, [...]
View Answer
| August 6, 2010 8:32 PM
RPGLE
You load two subfiles the same way you load one subfile except you will have two loops to write the subfile record formats instead of just one loop. And if you want to load three subfiles, you will code three loops, one loop for each subfile record format. If you want to load four subfiles, [...]
View Answer
| August 6, 2010 8:32 PM
RPGLE
as/400 how to display current date in spool file?
D DATE1 S D DATFMT(*DMY) D TIME1 S T TIMFMT(*HMS) D TIMESTAMP1 S Z C EVAL DATE1 = %DATE() C EVAL TIME1 = %TIME() C EVAL TIMESTAMP1 = %TIMESTAMP() C ‘DATE IS : ‘ DSPLY DATE1 C ‘TIME IS : ‘ DSPLY TIME1 C ‘TIMESTAMP : ‘DSPLY TIMESTAMP1 C EVAL *INLR=*ON ——————————————— Note that the [...]
View Answer
| July 9, 2012 6:48 PM
AS/400 Spool Files
D DATE1 S D DATFMT(*DMY) D TIME1 S T TIMFMT(*HMS) D TIMESTAMP1 S Z C EVAL DATE1 = %DATE() C EVAL TIME1 = %TIME() C EVAL TIMESTAMP1 = %TIMESTAMP() C ‘DATE IS : ‘ DSPLY DATE1 C ‘TIME IS : ‘ DSPLY TIME1 C ‘TIMESTAMP : ‘DSPLY TIMESTAMP1 C EVAL *INLR=*ON ——————————————— Note that the [...]
View Answer
| July 9, 2012 6:48 PM
AS/400 Spool Files
AS400 Printing and converting to PDF on the IFS
Perhaps there is a data queue attached to the output queue. If so, the data queue is probably being processed by a program which performs the conversion.
View Answer
| August 6, 2010 3:23 PM
AS/400 printing, IFS, PDF
Perhaps there is a data queue attached to the output queue. If so, the data queue is probably being processed by a program which performs the conversion.
View Answer
| August 6, 2010 3:23 PM
AS/400 printing, IFS, PDF
% system ASP used:
Hi, try this other way….. Use the cmd <go disktasks> select opt 1 (Collect disk space information) in the field “when to cllect….” choose 1=date/time in this option select *CURRENT to date and time. Now, the system send a batch job to collect data about your entire system (information about size, %, etc) When the [...]
View Answer
| August 6, 2010 6:59 AM
AS/400, ASP
Hi, try this other way….. Use the cmd <go disktasks> select opt 1 (Collect disk space information) in the field “when to cllect….” choose 1=date/time in this option select *CURRENT to date and time. Now, the system send a batch job to collect data about your entire system (information about size, %, etc) When the [...]
View Answer
| August 6, 2010 6:59 AM
AS/400, ASP
zebra printer on as/400
To provide a proper answer, we’d need to know what kind of Zebra printer it is, how it is connected to your network, how the spooled file is structured and possibly a number of other items. We don’t know yet if the specific printer is even capable of being controlled by anything but Windows. You [...]
View Answer
| August 6, 2010 6:06 AM
AS/400 printing
To provide a proper answer, we’d need to know what kind of Zebra printer it is, how it is connected to your network, how the spooled file is structured and possibly a number of other items. We don’t know yet if the specific printer is even capable of being controlled by anything but Windows. You [...]
View Answer
| August 6, 2010 6:06 AM
AS/400 printing
