AS/400 Tag Directory

Featured AS/400 Questions

  • AS/400 Barcode

    I am in search of information for barcoding onthe AS/400. We would prefer not to purchase new printers. Can printing barcodes be done without using a graphical interface software package?

    NMK5 pointsBadges:
  • AS/400 Query file

    We have updated a couple of fields in our system, which are contained in many files. We also have batch jobs that run queries. Is there anyway around having to change each query individually so they don't stop processing because of errors?

    gdrehfal5 pointsBadges:
  • Fetching multiple rows in SQLRPGLE

    Hi, When I try to fetch more records, I couldn't do it. Please see my code below and explain. Thanks.

    as400dev585 pointsBadges:
  • IPDS printer prints 2 copies of barcode page

    We have a homegrown program that prints a barcoded (6 0f 9) page. I have ran tests and the spool file has only one page of data and is set to 1 copy. When we send the report to an IPDS printer (HP-4050) it prints two copies. Why should it do this? All other reports sent to this printer are normal....

    azohawk2,110 pointsBadges:
  • AS400 spool file printing twice

    AS400 - 820 - V5R3V0 - I have a couple of printers, Genicom line printers, when a request is sent to print a report about 5 minutes later the same report is printed again. These are interactive jobs requesting this report. I have checked everywhere I can think of and can not find a reason for this....

    Dlc21140010 pointsBadges:
  • Overlay and ‘print’ as pdf. Overlay not included !

    This statement OVRPRTF   FILE(MYPRTF)  DEVTYPE(*AFPDS) TOSTMF('/myapp/mypdfs')  WSCST(*PDF) beatifully generates a .pdf file and places it in the IFS-folder '/myapp/mypdfs'. ( ref:  http://www-01.ibm.com/support/docview.wss?uid=nas12bd8020c496ae912862575f400640da6  ) I have an overlay which I...

    DanTheDane2,555 pointsBadges:
  • Difference between Module and a Program in AS/400

    Can someone please tell me how to differentiate between Module and Program in As400 just by looking at it?

    Sangay635 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • Re-generate report in AS/400

    How do I re-generate a report in AS/400? What are the steps? Please advise.

    kekuchi20 pointsBadges:
  • SQLRPGLE – problem with the like while using the wild card

    Hi all, I need your help in the Wild card search in SQLRPGLE. I'm entering the %XAS% in the display file screen field  and now based on the scan if I come across the field is with Wild card, I will use the like :Searchname in the SQLRPGLE code.

    ravula755 pointsBadges:
  • AS/400 query: Extract character between two characters

    Is there a way to extract the number of character between 2 chars? I need to extract email addresses that are between <....@...> in a field that is 228 bytes long.

    nsmartello5 pointsBadges:
  • IF statement in AS/400 query

    Can I use an if-type statement to return a different value? For example, i thought i would use define results fields to say if(lnt03=34,"advance","payoff") liek I would in excel. of course this doesn't work...

    KPSTL5 pointsBadges:
  • AS/400 Group Jobs being held after the first empty job is run

    I am using STRGRPJS JOB to submit a group job but after the first job is run which is a empty job the remaining jobs are being held. Can anyone tell what should i do so that they don't go in held state? Thanks.

    aceamar25 pointsBadges:
  • AS/400 print files stuck at RDY

    I am managing, but very unfamiliar with AS/400. I have a user who does not receive the printouts for her job. It looks as though the printouts are all stuck in RDY status on the Output Queue. If I look at our printers, there is a printer of the same name as the Output Queue. That printer is in END...

    HeyLeonardo5 pointsBadges:
  • Running AS/400 query in Specific job queue

    Is there a way to restrict user(s) to submit their queries to a specific job queue instead of going into qbatch?

    Msatbh185 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • Name string alignment in AS/400 printer file

    I have a customer name field of 240 length. There are four fields defined with 60 length in AS/400 printer file. I wanted to print the name in the printer file with character alignment(like not leaving a single letter in the end of the field). Is there any procedure/steps you can suggest me to do...

    Sureyz2,760 pointsBadges:
  • Limit/restrict CPU% for a job in AS400

    Hi, I have a job where I want to restrict the maximum CPU% usage. I tried various ways like setting a low run priority and a low-timeslice. Still they are not meeting my requirement.  With these 2 parameters, when the system is free, it is allocating the full CPU% to my job alone which I don't...

    VVNMURTY15 pointsBadges:
  • iSeries printer file compile

    Is there any way around that we can compile more than one printer file in the same time?

    Sureyz2,760 pointsBadges:
  • AS/400 command line

    what is the command and steps to disable command line access in as400

    now225 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.

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

Following