• Can any one give Link for learning basics of CL programming

    Can any one give Link for learning basics of CL programming

    Operations in AS40085 pointsBadges:
  • Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?

    Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement? Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINE SELECT left(descr254_mixed, 20) from PS_REQ_LINE

    SQL Server Ask the Experts2,585 pointsBadges:
  • maxicode from spool file on pick list with labels

    I need to present substitutes for some form software to a client. They need to create replace existing form software with form software that can creaate UPS shipping labels. The primary reason for switch is current forms software claims they can not make Maxicode from an AS400 spool file and...

    JoeVB5 pointsBadges:
  • AS/400 PRINTING ISSUE

    We have over 20 different LAN printers used to print receipts for as/400. every time a printer runs out of paper, the printer loses connection and wont print anymore. The printers have to be reset from headquarters in order to work again. any reason why this is happening? It seems the IBM printers...

    Tennity5 pointsBadges:
  • Update excel charts auto from as400 data

    I have a user request to create charts in excel using data held on the as400. I can do this in seperate steps but the user wants it as automatic as possible. At the moment : I run a query on the as400 to create data file I transfer using client access I open in excel & then copy data to graph excel...

    Gerrib150 pointsBadges:
  • FTP Server job execution.

    Does anyone know of a way to execute a .bat file on an FTP server through an iSeries scripted FTP session? The server, if I remember correctly is NT based.

    Pmc95 pointsBadges:
  • Automated file transfer from AS400 to Word?

    A search400.com reader wrote in with this question: I need to take a spool file (say a Collection Letter) generated from RPGIV. I can copy this spool file to a physical file if needed. I want to automatically import or send this file to Microsoft Word for editing purposes. I have used the 'ADD-INs'...

    AS400 - Ask the Expert485 pointsBadges:
  • What is Harvesting an LPAR

    What is Harvesting an AS/400 LPAR

    Operations in AS40085 pointsBadges:
  • How to initialise Dedicated service tool

    How to initialise Dedicated service tool

    Operations in AS40085 pointsBadges:
  • can we see the code behind an system value in as/400? eg. qdate, qmonth etc

    can we see the code behind an system value in as/400? eg. qdate, qmonth etc

    Kundankumar 8375 pointsBadges:
  • wrkrpyle

    Hello! I am attempting to execute an automatic SAVCHGOBJ from the AS400 job scheduler each evening. At the end of each run I receive a message id of CPA0701 and associated msg of CPF3778 - not all objects saved from all libraries. My problem is that I have set up a reply to CPF3778 of "I" in the...

    Abbey120 pointsBadges:
  • Subfile Interaction with other Display Files

    I am trying to write my first subfile program. I thought I could use a subfile to display a file and allow users to select a record from that file to update a field in another file. In my case I'm maintaining client data and have a file with languages (English, Spanish, etc). I would like to user...

    Kellab575 pointsBadges:
  • Utility Program

    can we see the code behind an utility program in as/400? I mean *date, *day... like such utilities?

    Kundankumar 8375 pointsBadges:
  • Insert records between records in a file using RPG code.

    Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert function be used to do this?

    Francissamonte15 pointsBadges:
  • PRINTING PDF’S FROM THE AS400

    We currently create overlays from sollidworks and autocad files that are then printed from the iseries AS400. I have been told that it may be difficult or require a programming change to create an overlay of a pdf file. Can you tell me what is required to do this or if it is possible? Thanks,...

    GRH10 pointsBadges:
  • as400 copy qsys.lib directory to mapped I drive

    I need to be able to copy an as400 qsys.lib/ sub-library/ or speceific files (*.FILE) in that sub-libray to a mapped drive I. Drive I is on the as400 which my PC can access. I do not know the path on the as400 to the I drive. I would like to use qshell if at all possible. No conversion of data is...

    PhilG0 pointsBadges:
  • CVT2PDF

    In the CVT2PDF in RPGLE is there a way to change the font output? It appears to be Courier and I have Customers that say when they print out the PDF I send them via email that it doesn't appear very well.

    filuphaze475 pointsBadges:
  • Month End

    We are closing sales and I keep getting a msg. ENSURE ALL SALES USERS AREOFF MONTHEND FAILED!... All users are logged off and I have manually checked all their computers and nothing. Is there a way to tell what users are still logged on? We are a small company of less than 10 people. I have dont...

    Luv2baprincess5 pointsBadges:
  • File Objects creation

    Is there any way to find out what command was used by an authorised user to create a file object. Any help is highly appreciated.

    Mdshahid5 pointsBadges:
  • Default Journaling in V5R4

    I created the default journal data area(QDFTJRN) with all the appropriate upper case entries in my test library and wondered what I needed to do next. I've made changes to several files and added and deleted records in several files but nothing shows in my journal. What starts the "automatic"...

    Jlunger145 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