About Me

Hello Friends,

This is Yusuf, I am working as Software developer from past 10+ years. I have been working under As/400 IBM i (RPGLE, DB2) technology and HTML5, JavaScript. Recently started exploring AWS, NodeJS and full stack development. In this on going journey I have failed/succeeded/learnt a lot. I would like to share the interesting things which I have come across to the world via this blog and I hope it may save some of your valuable time. 

Have fun!!! Happy coding...!!!!

Thanks & Regards,
Mohammed Yusuf

16 comments:

  1. Hi Yusuf

    I'd like to create a macro in AS/400 that copies cell data from an XLS spreadsheet to AS/400 screen field. How can i do that? Please help

    Thanks
    Shin

    ReplyDelete
    Replies
    1. If your screen field is based on a PF, then we can think of way to update your PF based on the Excel. But could you help me to understand the actual requirement pls. I will try to help if possible.

      Delete
  2. Hi Yusuf,
    I loved you posts about CGI code and posting data to IBMi local website. Is is possible to connect the IBMi apache website (via Java JDBC for example) to DB2 database and fetch records to dynamic web content? If yes, could you provide example?

    ReplyDelete
    Replies
    1. Hi Mierk,
      Thanks for your feedback. I have not much worked with web development with Java. But I can give example on how we can connect DB2 from a JAVA program using JDBC and retrieve data. May be you can extend this to your requirement. JT400.jar is used for this. More info from https://sourceforge.net/projects/jt400/

      Delete
  3. Hi,
    I do not have current project/requirements to stick to, but I am exploring options to bring data from DB2 to the web. I have the following list that I consider:
    - IBMi Web Query
    - CGI programs
    - Web Services Server (similar to CGI, which you already provided all the heave lifting for)
    - Java application
    - Application Servers internal (Tomcat, WebSphere) or external (.net, etc..)
    - Third party software (from Helpsystems or alike)

    I think the Web Services Server is the most efficient and cost effective option for my pet projects and your CGI documentation will be very helpful. Here is couple of reference links:
    http://www-01.ibm.com/support/docview.wss?uid=isg3T1026868
    https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_61/rzaie/rzaiewebservices.htm

    Thank you again for all the info you are sharing.




    ReplyDelete
  4. I need access to the IBMi AS400. Please Let me know any way so that i can work from home.

    ReplyDelete
  5. Please Let me know how can i get access to IBMi as400 from home. As I can see you worked from home and you have the access.

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Hi Mohammed, I'm trying your xml parsing but I get parsing error 12 because of the first line (xml declaration), how do you get around that? thanks

    ReplyDelete
  8. Interesting, way to go my boy!!✌��

    ReplyDelete
  9. I am currently on v6r1. I would like to know if it is possible to use Rest apis to send and receive json files. I have to use it for my GST E invoicing project.

    ReplyDelete
  10. SIR, I AM A BEGINNER IN AS400 RPGLE AND YOUR VIDEOS FROM YOUTUBE ARE HELPING ME
    IMMENSELY YESTERDAY I WANTED TO CREATE A DISPLAY FILE THEN WRITING A PROGRAM FOR IT AND THAN WANTED TO STORE THE DATA OF DISPLAY FILE ENTRIES IN A PHYSICAL FILE HOW TO MAKE IT HAPPEN HELP ME SIR.

    ReplyDelete
  11. Hi Yusuf
    Have a problem with SFTP from IBM i to linux server with QSH in CL program:
    CHGVAR VAR(&CMD) VALUE('sftp root@xxx.xxx.xxx.xxx')
    QSH CMD(&CMD)
    CHGVAR VAR(&CMD) VALUE('put /opt/QRADAR/qradar1.txt +
    /opt/qradar/qradar1.txt')
    STRQSH CMD(&CMD)
    Have this message:
    QSH - qsh: 001-0019 Error found searching for command ls. No such path or directory.

    What I'm doing wrong.
    Thanks a lot

    ReplyDelete
  12. bonjour Yusuf,
    je débute en programmation AS400 et j'aimerais savoir si vous avez fait un tuto avec un programme qui permet d'avoir le résultat d'un calcul via le RPG ou cobol.
    exemple j 'ai en stock 20 PC j 'en vends 5, je voudrais que le résultat s'affiche automatiquement après avoir saisie la vente.

    merci d'avance si vous pouvez m'aider

    ReplyDelete
  13. Hi yusuf,

    I got a requirement that
    One company want to send New year and Christmas Greeting message in PDF format to all of their clients on email. So i should write a RPG program to generate that PDF which will have Logo and Name of the company and client’s company.

    For this the Client name and designation can be taken from master table and the PDF should have the company and client’s Logo and address (which should pick logo from IFS).

    Can you please suggest me the approach which i should follow also how and where should i create the ifs folder in pub400 machine? I tried the CRTFLR command but i received some authority error.

    ReplyDelete
  14. hi yusof
    I tried download file from AS400 using IBM client acces data transfer but gives error - BLOB
    how I can download the BLOB file using ODBC driver in text format

    ReplyDelete