AS/400 Tag Directory

Featured AS/400 Questions

  • Difference between LAN Printing and Remote Printing

    Hi, In our shop, we need to get a user access to take printout from AS400 to a printer that is outside our office network. We proposed to create a virtual printer session and download the print output which can be printed in any printer to which the machine is connected. However, during this...

    Meetmeonline215 pointsBadges:
  • iSeries Print Spool File 3 Up

    We were printing 3x8 notices (continuous forms) on IBM 6262 printer. After upgrading to laser HP printers, the 3x8 notices print one to a page. The software vendor has offered no help citing that a program change was not warranted. How can I make these print 3 UP. I have tried changing the spool...

    435015 pointsBadges:
  • How to create a AS400 Qshell script (.sh) file

    Hi, I want to run a command STRQSH CMD ('/REPORTGENERATOR/move2current.sh') Where move2current would be a .sh file with commands as below: rm /HPA_CURRENT/_YOUR_AS400_NAME*.CSV cp /REPORTGENERATOR/*$(date '+%Y%m%d')* /HPA_CURRENT #set new owner chown hpa_transf /HPA_CURRENT/*.CSV My question is how...

    DeepikaR115 pointsBadges:
  • Key Mapping Error when writing records in AS/400

    When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error

    C.naveen09140 pointsBadges:
  • AS/400 query on all user profiles

    I ran query of all user profiles. I need to change the UPPWCD UPPSOD field from YYMMDD to MMDDYY. You cannot change it in Specify report column formatting. That only handles numeric. Can someone get back to me ASAP? Thanks!

    Gww2445 pointsBadges:
  • 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.

    as400dev590 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,190 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:

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