Wednesday, May 27, 2009

(Announcement) Place Your Questions Here



For questions, just enter your questions (here) as comment.
Then I will create a new topic based on your query.

Thanks.


35 comments:

  1. What's the different between *date and *udate in rpg?

    ReplyDelete
  2. how can i check the status of job switch in rpg?

    ReplyDelete
  3. What does VNC stands for?

    Ex. VNC to 198.xxx.xxx.xx

    Could you please help me on this one?

    ReplyDelete
  4. Hi As400 Guru,

    i have a problem regarding on CSV files.

    I have made a program that will produce records in CSV format.

    But when i downloaded it and opened it in Excel. The card numbers are different.

    Instead of 1234567891234567, the number in excel would come out like 4.321+13 sumthin like that. But when i check it in RPG card number is OK and also when CSV is opened using notepad.

    Thank you!!

    ReplyDelete
  5. Can i connect visual basic to AS400?...

    ReplyDelete
  6. Hi.. I need to use socket programming in AS400. Can you please give me step-by-step instructions on how can I do that? Or atleast give me templates?

    Your soonest reply is so much appreciated.

    -g*Ld

    ReplyDelete
  7. do you know how can i use the chinese in as400?as far as i know ,there is one way that when i create the source file ,i should change the parameter of User specified DBCS data- > *YES,but now i can't fine the paremeter of user specified DBCS data in the as400

    ReplyDelete
  8. what's the the programe description file in the rpg?what is it used for?how can i create it to be a physical file in the program?can you give me a example?

    ReplyDelete
  9. hi want to create tool to delete old spool files. any please help me to give the code

    ReplyDelete
  10. HI,Can you tell me how can i retrive the current user id in the rpg program?thanks

    ReplyDelete
  11. what is the structure of AS400?

    ReplyDelete
  12. hello,i create the physical file by rpg program ,now i want to add the the column heading for the physical file inside the rpg program,how can i do that?thank you

    ReplyDelete
  13. Why do we hit a Session device error?

    ReplyDelete
  14. Can I connect to another AS400 file with embedded SQL in RPGLE?

    ReplyDelete
  15. I just want to ask on how can i go about transfering a flat file to an excel file, which uses comma (,) as a delimeter. And how about if it's from a physical file and i want to transfer it to an excel file? Can you also provide a link on how to do it or maybe you can give me a step by step sample program.

    Many Thanks! :)
    kNOw_wELL

    ReplyDelete
  16. hi...

    i would like to know how to not encounter error when using savlib command
    SAVLIB LIB(&LIBL) the &LIBL: as the parm and has 500 length (ex. 10 libraries inside)..
    in the command prompt when SAVLIB is used:
    LIB should appear as this :
    MLIB
    XLIB
    SLIB
    but.. when the RPG calls the CL it becomes
    'MLIB XLIB SLIB' -- it is transferred as one constant how can i pass the parameter and let the command be as shown as above ?


    thanks ... Lui :-)

    ReplyDelete
  17. Does anyone knows a process or CL that uses DSPLIB to display the contents of a library and their attributes, such as their size and last used date, followed by creating a file that I can query against?

    My goal is to first list the name, last used date and size of all objects in a production library and delete objects that have not been used in more than a year.

    ReplyDelete
  18. How can a get information about the (number and type of) parameters a PGM wants.

    Thanks in advance.

    ReplyDelete
  19. How long could be file, library or member name ?

    ReplyDelete
  20. We, a group of three have just started learning AS400 recently. We have learnt the basics of the CL language and creating display files. We have to develop an application software for our final year project based on AS400,probably on Bank Management. Can you help us with this scenario as to develop an efficient software. Please suggest some other front and backends as well.

    Thank you.

    ReplyDelete
  21. What is as 400 used for?

    ReplyDelete
  22. What is the advantage of using a Activation group?

    ReplyDelete
  23. Max No. of Libraries we can create in AS400?

    ReplyDelete
  24. Is there a way to print out a catalog of the files in the as400 library

    ReplyDelete
  25. 1.How do I know which line I have printed last without using a counter? Suppose I have printerd 60 lines, I wanted to know the lastnumber that i have printed is 60.
    2. In load all subfile if I have pressed page down many times and then if I pressed enter, control will go back to first page, how can i avoid that?
    3.Suppose I have 3 jobs A B and C. I want B to start only after finishing A and C to start only after finishing B. How is this possible?
    4.How can I know the number of records in a file in runtime?
    5.What is the purpose of using an Activation group?
    6.Suppose I have a PF with members sun,mon,wed,thurs and Fri. I want my RPG program to use member Wed. How can I achieve this without using EXTMBR?

    ReplyDelete
  26. Hello, how can I convert string to numeric using wrkqry? thanks :) kindly email me if you have any suggestion. my email is yzero8_norm@yahoo.com
    thank you very much!

    ReplyDelete
  27. How can I import a file directly from AS400 to Excel...step by step. I remember having to setup the ODBC Connection for the AS400, but no longer remember the steps...help.

    Thank you.

    ReplyDelete
  28. 1) What happens if u do a RUNQRY on Source PF?




    1) What happens if u do a RUNQRY on Source PF?
    2) PF1 is having 2 LF’s LF1 & LF2, LF2 is having unique keyword associated with it, and if u are trying to insert a duplicate record into a PF? What happens and what is the error which u get?

    3) PF1 is having 3 LF’s and LF1 is having 5 key fields and LF2 is having 4 key fields and LF3 is having 3 key fields, which will u compile first and why?

    4) I should design a PF in which we should be able to insert records into a PF but we should not be able to modify any records? How can we achieve that?

    5) If I change any field in a PF, then is it necessary to compile all the LF’s that are built using this PF?

    6) A PF is not containing any records in it, but when we do a runqry on that PF, it says member full, Then how will u handle this scenario? I mean what will u do so that u store data in that PF?

    7) In CL, when I encounter any error I need to display the Message ID of that error case, like cpf9801 ? How to display that particular message ID and description through CL?

    8) How will get the record count of any PF in CL?

    9) How will get the record count of any PF in RPG with out using READ opcode?


    10) In Array’s the no. of elements, entry length of array are given during declaration, If I need to get dynamically at run time how to achieve it?

    11) How can u modify a particular field of a PF through RPG?

    ReplyDelete
  29. 5. If we do a CHGPF, and the associated LF has the same record format of the PF, we dont need to recompile those LF.
    8. Can get the record count from RTVMBRD command
    9. I guess we can get the record count in CL from file information data structure.
    Please answer all other questions.

    ReplyDelete
  30. i've got an interesting situation. we are doing a Disaster Recovery on an as400... did a system save (sys, non-sys, etc), and then a system restore on the DR system... all sys and non-sys objects seem to have been restored file. However, the disk space used is almost 400gig lower on the DR system, than on our production system... i've check file sizes, number of files, IFS files, and don't see anything even close to that amount...?

    no issues, just curiosity!

    anyone have any thoughts?

    ReplyDelete
  31. i ran a PROCESS AND IT FAIL IN THE MIDDLE. hOW CAN I RELEASE IT ?

    ReplyDelete
  32. how i can know the creation date of a folder ?

    ReplyDelete
  33. There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known.

    how can we do this?Solution should be performance oriented

    ReplyDelete
  34. I was wanting to know, on as400, I have a program in which a barcode is generated. when looking at wrksplf (spool file) i see that it utilized my printqueue. my issue is that i have no physical barcode printer at my desk, i have to ask someone out of state to print it for me, given my username/password, they go into the print spool file and change the printq to print it out. Question begs now is, can i somehow setup my printq so that it matches her print queue thus saving her hours of time?

    Thanks in advance.
    sraza74@gmail.com

    ReplyDelete