AS/400 Tag Directory

Featured AS/400 Questions

  • data transfer to excel via client access

    with client access Version 5.00, I would like to upload a file to excel 2007 by using data transfer command

    Annieguibert5 pointsBadges:
  • Converting Julian date to Gregorian in WRKQRY

    I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

    Lady5515 pointsBadges:
  • DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • AS/400 BRMS

    Receiving a BRM1934 error on a DUPMEDBRM when the receiving tape drive is locked protected, the system is auto responding with "D" but I do not have an auto response for this error in my reply list so where does it come from? My operators are not catching the issue since there is no break message...

    HowIGetHere20 pointsBadges:
  • iSeries – DBCS

    Hi We have an application with front-end (Java in RS/6000) and the back-end (COBOL in iSeries). Currently, the front-end browser panels send the data through MQ to iSeries. But before sending data to iSeries, the Java will do conversion from ASCII to EBCDIC programmatically for character encoding...

    Pmr5 pointsBadges:
  • Is it possible to get an alert when database page faults exceeds a certain amount.

    Is it possible to get an alert when database page faults exceeds a certain amount. Iam referring to the page faults which appear when we give the WRKSYSSTS command.  Or write a pgm which could monitor the page faults and sent an alert. 

    JohnsonMumbai1,160 pointsBadges:
  • AS/400 FTP to Host: Getting 530 Error Msgs

    I'm having a problem when i try to reach a host server via AS400 FTP. I have configured the host, the TCP interface, TCP route and start the connecting. I can PING the remote host via the 400. when i start the FTP i get "connection established" when i try to log in i get the error message "530 log...

    Lacag100 pointsBadges:
  • DDS Keywords for AS/400 Windows screens

    I have an Interactive Maintenance Screen program that calls a program to display an AS/400 Windows. When I get to the first Screen and the call to the AS400 Window display is made, the background is blacked out and only the Window shows up. Is there any way that the background (first) Screen can be...

    Ppeier10 pointsBadges:
  • Please explain RPG “Bind by Copy” and “Bind by Reference”?

    Can you explain the terms with example BIND BY COPY BIND BY REFERENCE

    rajeshece1,215 pointsBadges:
  • Which files I need to run the file.dtt into the server?

    I make a wcf in visual studio this modify lines inside file.dtt. HostFile= HostName= FDFFile= PCFile= In my PC, there are a Client Access, and the WCF run fine. modify Data in AS/400. But if I publish the WCF in the server, doesn't run fine. The server doesn't know the file.dtt. Which files I need...

    JLH10 pointsBadges:
  • Iseries auto respond to error message

    Is there a way for the Iseries to respond to an error message without user intervention?

    AZL20 pointsBadges:
  • Connecting to more than one AS/400 DB2 Remote Databases using SQLRPGLE

    I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not...

    AS400DB2DBA5 pointsBadges:
  • Controlling C D I R options in the workstation message queue.

    Hello All, Could you please tell me how to control the C D I R options via programs. I mean that I do not want R to appear in screen and the functionality is automatically done. Can it be possible? If yes, please tell in detail and if not then what is the reason?

    Bigdumbo25 pointsBadges:
  • creating menus

    Hi anybody tell me how can we add the parameters to a new menu thru SDA. eg: for DSPUSRPRF i need to provide the user profile name. Instead i want to give &user1 and want to supply it by prompting. thanks

    ten20081,150 pointsBadges:
  • Replacing information in a field in AS/400

    I am trying to find out how to replace information in a field for multiple records. Example; field A is a name field for a salesman. Some of the names are no longer valid and need to be changed. How can I "drop" in a replacement name just for those records? This is an AS/400 4.2 system. Or is there...

    Scott32115 pointsBadges:
  • How to Add column (field) in ODBC to physical file?

    When I add a new field in ODBC, I can't find it in the physical file in the iSeries.

    afayek675 pointsBadges:
  • How to ignore Permanent I/O error on a Display

    AS400 screen: I have a display program that displays text on a screen. More frequently users receive "Permanent I/O error" because there's an invalid character inbedded in the text field caused most likely from cut-n-paste. In one instance the character is hex 15. How can ignore this error and...

    DHLSameday185 pointsBadges:
  • Email Format on AS/400 Fields

    Hi, I am trying to create a field on physical file, that has to store any email id such as xxxxxxyyyyzzzz@qqq.com.  Kindly let me know, how to go for this.What are the all definitions I need to specify for this field. Thanks!

    HABBIE820 pointsBadges:
  • How to run query in AS/400?

    New user, like to know in detail how to run query in AS/400 with snapshot will be better.

    Shreekant40 pointsBadges:
  • What will happen in AS/400 if I use H dump?

    H  DUMP     what will happen to the program

    chakramdhar65 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