• AS/400 Query Rows

    We have been running a series of queries that create a final report for years. All of a sudden when we run the report, it only has the first 100 rows. Where would I look to see if somehow we have put a limit in one of the queries?

    Tinamh25 pointsBadges:
  • Display fields and subfile side by side

    Hi all I am using V5R1. I have to design a screen where some fields should be on left side and a subfile on right side (both side by side). I have tried a lot but couldn't succeeded yet. I have made two separate record formats one for all fields on left side and the other one is subfile. but when I...

    hunshabbir7935 pointsBadges:
  • SQL to go From N Rows to 1 Row and N Columns

    I would like to ask for your help one more time, if you may. I work for an insurance company and am facing a challenge. I have two tables as such: policy_table Policy_number 12345 98765 45678 Policy_id (PK) 1 2 3 endorsement_table Endorsement flood quake theft hurricane freeze-pipe fire dog-bite...

    Esdras25 pointsBadges:
  • +12 V dc regulator fault in AS/400

    Hi everyone, I got a problem with the FC 5073 expansion unit. It has an error code of 10217403. It says that the AC module is the failing ITEM. So, I replaced the AC module (2x). The same error occurred. And I was thinking is the SPCN card in the system unit is the problem. What do you think is the...

    excellentrandy905 pointsBadges:
  • AS/400: A6NN0266, 1021A300

    Hi everyone, I have this big problem. One of our clients has 9406-730 machine. After a power outage, they got an SRC code: A6nn0266 where nn is continuously changing every 1 or 2 minutes. And another thing is it's 5073 expansion unit does have an error code in its panel 1021A300. I also can't log...

    excellentrandy905 pointsBadges:
  • Multiple Volumes in QP1A2RCY

    I ran a Full backup last night using BRMS (STRBKUBRM), i could see QP1A2RCY report has multiple volumes in it even though my backup took only one volume and this backup is not a parallel save or something. Can any body explain me whey this report got old full backup tapes in it ?Your quick response...

    QMASTERS5 pointsBadges:
  • Is iSeries FTP compatible?

    Is the iSeries secure FTP compatible with SFTP on other platforms

    RichK1151125 pointsBadges:
  • Acquiring MOCHASOFT TN3812 printer emulation software

    Does anyone know where I can acquire the Mochasoft TN3812 Printer Emulation Software for Mac? I am currently using TN5250 to remotely access an AS/400 and I would like to print some of my source listings.

    red1632720 pointsBadges:
  • AS/400 Error handling for multiple selection in subfile

    I want to throw error message, when user selects multiple options in a subfile field with '1' asĀ  valid selection. In this for all records in the subfile, I need to select only one record at time, but not multiple records. Suggest any DDS keyword/function which will validate only one selection,...

    poojaary85 pointsBadges:
  • Loading runtime array with PF files

    Can I load runtime array by getting records from pf file?

    abhi2106198815 pointsBadges:
  • Access i for Windows

    How do I setup printers in access?

    carljeffries5 pointsBadges:
  • QSYSOPR message monitoring through mail

    Hi, i have to fetch the messages in "QSYSOPR " which are messages needing reply part. and have to send mail regarding these messages to a particular user. how can i do this?? is their any code available for this ??

    poojaary85 pointsBadges:
  • Output Queue from user profile and Job Descruiption

    Different output queue are defined in Job Descipription and User Profile . However when the report is generated the spool is directed to the outq mentioned in Job Description. Can someone please explain me why is job description getting preference over user Id's outq?

    Atti123135 pointsBadges:
  • AS/400 error message: GET NOWAIT pending.

    Does anyone have any idea as to how to fix this error message: Message ID . . . . . . : CPF5023 Severity . . . . . . . : 30 Message type . . . . . : Notify Date sent . . . . . . : 03/03/03 Time sent . . . . . . : 14:41:39 Message . . . . : GET NOWAIT pending. Cause . . . . . : Specified record...

    GHENDER190 pointsBadges:
  • AS/400 user profiles: Is there a ‘run command at log-off’ option?

    I need to have a CL command run everytime a dedicated user ID logs off. This user ID is being used to allow the upload of data to the AS/400 from another system via FTP, and the data needs to be processed as soon as it is uploaded. I thought that if there was an option to automatically run a...

    BruceC5 pointsBadges:
  • AS/400: Create a file listing object locks on an object

    This there a way to create an out file listing all object locks on a specific object? Using WRKOBJLCK I can see the jobs that have a lock on an object. I need to end these locks using a CL program. We are using ShowCase and using the command ENDSCSVR will not work because there are numerous locks...

    northwoods180 pointsBadges:
  • What populates fields in APH

    I need to know what populates the following fields in APH, APRESN, PHDCSQ, PHCMTP, PHCMTG, PHCMTR

    tjrjcj5 pointsBadges:
  • Tools for testing environment comparison

    I'm looking for some tools that will enable us to quickly compare our live and development environments to ensure they are identical and that any testing done on dev will provide true results. Does such a tool/utility exist both natively and external to the eye?

    osullic20 pointsBadges:
  • Receiving CPP630C error message when trying to restore tape

    We are using 3592-J1A to restore client's back up tape. But when we are trying to restore the tape, we got CPP630C error ID and SRC63A09355 System reference code. What to do now? Thanks

    excellentrandy905 pointsBadges:
  • Printer Issue in AS/400

    Message . . . . : An output bin needs attention on device CSR202PY (C R). Cause . . . . . : An error was detected on device CSR202PY. This may have been caused by something like an output bin missing or an output bin full. Look at the printer to determine the cause of the problem. Possible choices...

    Anilpatel95 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following