Ask the Experts
Ask the Experts
-
Where is user password information stored on AS/400?
System i security expert Carol Woodbury briefly discusses user password information on AS/400. Continue Reading
-
Error while connecting Client Access v4r5 to to an AS/400 on v4r5
Expert Shahar Mor explains why a user receives an error message while trying to connect Client Access v4r5 to to an AS/400 on v4r5. Continue Reading
-
Viewing AS/400 directories and folders in Windows
Expert Shahar Mor explains how to access AS/400 folders though Windows. Continue Reading
-
AS/400 SQL transaction file help
Iseries database expert Kent Milligan offers an index for an efficient way of selecting the last transactions in a transaction file. Continue Reading
-
SQL packages on remote servers
ISeries expert Kent Milligan offers AS/400 advice on SQL packages to remote servers. Continue Reading
-
Working with nulls in RPGLE
ISeries expert Kent Milligan offers help for working with nulls in RPGLE. Continue Reading
-
Storing XML data in a CLOB field
-
Saving and restoring job scheduler jobs on AS400
AS400 backup and recovery expert Kenneth Graap offers some advice about saving and restoring job scheduler jobs. Continue Reading
-
An example of using COUNT() in a STRSQL statement
iSeries expert Kenneth Graap gives an example of using COUNT() in a STRSQL statement. Continue Reading
-
Advanced Job Scheduler help
iSeries expert Ken Graap helps a reader build a CL Program to monitor for job completion using Advanced Job Scheduler on iSeries. Continue Reading
-
Force AS/400 passwords to have uppercase and lowercase letters
One Search400.com member asked, "Is there a way to force passwords in the AS/400 to have uppercase and lowercase letters? Continue Reading
-
Passing parameters in an ILE RPG module
iSeries application development expert John Blenkinsop explains about passing parameters in an ILE RPG module. Continue Reading
-
Importing iSeries data directly into an Excel spreadsheet
Kent Milligan, DB2 UDB expert helps a Search400.com member t import iSeries data directly into an Excel spreadsheet . Continue Reading
-
How do I automate a full system backup on my i5 server?
Backup and recovery expert Ken Graap explains how to automate a full system backup on the i5 server. Continue Reading
-
How can I save and restore spool file data as part of my backup/recovery process?
Search400.com expert Ken Graap explains how to save and restore spool file data as part of a backup/recovery process. Continue Reading
-
Print PDF documents that are stored in IFS
One Search400.com member writes, "How can I print PDF documents that are stored in IFS? The PDF's contain images and text; I want to print them on Laser printers with CL code." Continue Reading
-
Answering and deleting messages in QSYSOPR message queue
One Serch400.com member writes, "What controls a user's ability to be allowed to answer and (especially) delete messages in the QSYSOPR message queue? How can we restrict them?" Continue Reading
-
What does the QDBSRVnn job do?
One Search400.com member writes, "What does the QDBSRVnn job do?" Continue Reading
-
Printers remain in a PND status
One Search400.com member writes, "We have three *IPDS printers attached to one e-Twinax controller -- all sharing the same IP. All spool files sent to these three printers remain in a PND status, forever. What can be done to clear this?" Backup and... Continue Reading
-
Finding the value for the 'message key' parameter
One Search400.com member writes, "I am trying to set up a reply to a message that I am monitoring for. How do I find the value for the 'message key' parameter for the sndrpy command?" Continue Reading
-
What is a Decimal Data Error?
One Search400.com member writes, "Can you please tell me what a Decimal Data error is, and what is the scenario in which it is received?" Search400.com's application development expert John Blenkinsop explains. Continue Reading
-
Print a PDF file from the iSeries
One user writes, "I'm having trouble with embedded spaces with the STRPCCMD command. The following works when I type it into the Windows start, run box: "C:Program FilesAdobeAcrobat 6.0acrobat.exe /p M:Blueprintssample.pdf" Thanksfully, Shahar Mor... Continue Reading
-
Resetting SST user passwords
One Search400.com member wrote, "How can I reset SST user passwords?" Security expert Carol Woodbury was on hand to offer some advice. Continue Reading
-
Full system save with IBM's Advanced Job Scheduler
One Search400.com member writes, "Does IBM's Advanced Job Scheduler allow one to schedule a full system backup on specific dates? If so, how would this be accomplished?" Backup and recovery expert Ken Graap explains. Continue Reading
-
How to permanently apply PTFs
One Search400.com member writes, "I have an iSeries 620 box running V5R1. I temporarily applied PTF (TL03175) on this box and then IPL it on the B side. The next day I did an IPL on A side and still find that the PTL is temporarily applied. I again ... Continue Reading
-
Connecting an HP LaserJet to the iSeries
One user writes, "I'm using a HP LaserJet 3030. I would like to use the printer to my iSeries. What's the best method to follow?" Printing and output expert Chip Milosch responds. Continue Reading
-
Import a text file
One user writes, " I need to 'import' a text file located in the user computer to a DB2 table in the database. What's the best way to do this?" DB2 expert Kent Milligan offers some advice. Continue Reading
-
Verifying a backup is complete
-
Determining the speed of an Ethernet card
One Search400.com user writes, "How can I determine the speed of an Ethernet card on the iSeries?" Systems management expert Rich Belles shares his method. Continue Reading
-
Using the Print user profile command
This iSeries user wonders if there Is a way to generate a report/file to display users, password expiration levels and date password expires. Security expert Carol Woodbury responds. Continue Reading
-
Running multiple SQL commands within a CL/QMQRY
Running multiple SQL commands within a CL/QMQRY does not recognize the semicolon (;) separator. Is there a PTF that is required? Continue Reading
-
Getting authority for STRDBG
One user writes, "What is the command to get authority for STRDBG?" Systems management expert Scott Ingvaldson was on hand to offer some advice. Continue Reading
-
Invoking a stored procedure from a COBOL program
One user writes, "I am attempting to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the last (meaningful) statement in the stored procedure is OPEN cursor name. Once I issue the CALL in the ... Continue Reading
-
How to find out if there is a binding directory available
One user writes, "Our company has many ILE programs that may or may not be created by using a binding directory. When I have changed a module within a program, how can I find out if there is a binding directory available to rebind (CRTPGM) for this ... Continue Reading
-
Changing a default printer
One user writes, "I'd like to change the printer a usrprf has assigned. Can you tell me the best way to go about that?" Printing an output expert Chip Milosch offer some advice. Continue Reading
-
Setting the font size for reports
I need to set the font size to Arial 13 in my reports (PRTF). How can I do this? Continue Reading
-
Enabling FTP on your iSeries
FTP is not configured on this user's server, so when he uses STRTCPFTP he's getting an error. What's going on and how can this be fixed? Search400.com expert Shahar Mor has some advice. Continue Reading
-
Error message of null values
One user wrties, "In V5R3 I got the error message of null values not allowed in column or variable ZORD#T for SQL update." DB2 expert Kent Milligan offers some advice. Continue Reading
-
Import a text file to a DB2 table
One user writes, "I need to "import" a text file located in the user computer to a DB2 table in the database, what's the best way to do this?" DB2 expert Kent Milligan offers some advice. Continue Reading
-
RPG-free routine to calculate dates
One user writes, "I thought that I saw somewhere an RPG-free routine using %DATE (bif) to calculate the day of the week. For example, MON, TUE, etc.? I need to place the day on a screen." Development expert John Blenkinsop responds. Continue Reading
-
Manipulating a file
One user writes, "How would I go about taking a list of users and making it a file that I can manipulate? For example, "wrkusrprf *all"." Thankfully, development expert John Blenkinsop was one hand to offer some advice. Continue Reading
-
Bringing a system out of restricted state
-
Why are users getting the "not authorized" message?
One user writes, "My users are getting "not authorized" messages when they run queries. They have run these queries for years. The PUBLIC authority on the queries and the library objects is *CHANGE. What can I look at to figure that out? I am being ... Continue Reading
-
Changing default message replies
One user writes, "I've changed the default answer (C) from cpf4101 to (D) with CHGMSGD MSGID (CPf4101) MSGF(QCPFMSG) DFT('D'). I've also put an entry in the SYSRPLY: ADDRPYLE SEQNBR (12) MSGID(CPF4101) with reply *dft (which is now actually D, so ... Continue Reading
-
Why am I receiving the error SQL7008?
This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice. Continue Reading
-
Why are the user passwords getting disabled?
Security expert Carol Woodbury explains the differences between the error messages CPF2234 and CPF1393. She also explains how these errors can be avoided. Continue Reading
-
Problems printing from the iSeries
This Search400.com member has questions concern ng printing from an iSeries 820 V5R2 to a network ASCII printer attached to a Windows print server. Printing expert Chip Milosch is on hand to help him out. Continue Reading
-
Understanding the user class of a profile
Security expert Carol Woodbury tries to clarify user's confusion on the user class of a profile. Continue Reading
-
Monitoring QSECOFR
Security expert Carol Woodbury explains the best method for tracking activity QSECOFR has on V4 OS/400s. Continue Reading
-
My backup is taking forever
This user wonders why his backup is taking so long to complete. Search400.com expert Ken Graap advises. Continue Reading
-
Enable the QSECOFR user profile
This user has questions about enabling the QSECOFR user profile. Continue Reading
-
Using subsystems to run job queues
-
Error occurs during debugging
-
How do you read a formatted dump of an SQL RPGLE program?
-
FTPing from one iSeries IFS to another iSeries IFS
-
Create separate ASP on an iSeries server
-
Error during printer emulation
-
Load single page subfile
-
Read records sequentially from a subfile
-
Making sense of temporary addresses usage
-
Using NetServer without entering a password
-
How to log use of STRSQL
-
Does OS/400 have encryption/decryption capability?
-
Controlling time out for a socket connection
-
How to detect or log all commands typed
-
What is eating up my CPU?
-
How to get the source file information of a module in an RPGLE program
-
Can commit and rollback be used on the iSeries?
-
Is the CPYTOIMPF command the best option?
-
Good descriptions of field names
-
Creating SQL views
-
Why is my job going into the status of EVTW?
-
Which is preferred: logical file or embedded SQL?
-
Calling an RPG LE program from a SQL trigger procedure
-
Lines of code in an RPG program
-
Using a self-extending subfile
-
How can I display a variable?
-
Create a subfile display as a window records
-
Getting member information into a database file
-
Unlocking or deleting IFS objects
-
Difference between Access path and Open data path
-
Using RUNSQLSTM in a CL program
-
Removing stored procedures
-
Command to display CD contents
-
How to create a message subfile
-
Powering up a model 720 iSeries
-
Creating a library with a *test vs. *prod parameters
-
Understanding the WRKACTJOB command
-
Setting up a default library in DB2
-
iSeries on the mobile phone
-
Working with subfile lines
-
Deleting a logical file
-
How can I get the odd and even number of rows from a DB2 table?
-
Can I turn a 'generated by default' identity column into a 'generated always' column with DB2 V8.1?
-
Restoring procedure after using "SAVCHGOBJ"
-
Backing up spool files on the iSeries using BRMS
-
Working with the Auto Refresh functionality
-
Clearing subfiles
-
CHAR fields vs. VARCHAR
-
Run multiple SQL statements