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.

Posted by Unknown at 2:57 PM
Labels:

37 comments:

  1. LuciaMay 27, 2009 at 4:10 PM

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

    ReplyDelete
  2. LuciaMay 28, 2009 at 12:09 PM

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

    ReplyDelete
  3. KropeckMay 28, 2009 at 2:25 PM

    What does VNC stands for?

    Ex. VNC to 198.xxx.xxx.xx

    Could you please help me on this one?

    ReplyDelete
  4. KropeckMay 29, 2009 at 5:21 PM

    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. Bryan AranconMay 29, 2009 at 5:35 PM

    Can i connect visual basic to AS400?...

    ReplyDelete
  6. AnonymousJune 1, 2009 at 5:32 PM

    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. LuciaJune 2, 2009 at 9:40 AM

    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. LuciaJune 8, 2009 at 5:22 PM

    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. UnknownJune 9, 2009 at 12:34 PM

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

    ReplyDelete
  10. LuciaJune 16, 2009 at 5:05 PM

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

    ReplyDelete
  11. AnonymousJune 17, 2009 at 11:10 AM

    what is the structure of AS400?

    ReplyDelete
  12. LuciaJune 19, 2009 at 10:50 AM

    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. AnonymousJuly 10, 2009 at 9:44 PM

    Why do we hit a Session device error?

    ReplyDelete
  14. AnonymousJuly 22, 2009 at 4:27 PM

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

    ReplyDelete
  15. AnonymousSeptember 5, 2009 at 4:36 PM

    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. AnonymousSeptember 28, 2009 at 11:17 PM

    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. aaaadddd1December 1, 2009 at 10:34 AM

    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. UnknownFebruary 23, 2010 at 11:59 PM

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

    Thanks in advance.

    ReplyDelete
  19. AnonymousMarch 28, 2010 at 8:32 PM

    How long could be file, library or member name ?

    ReplyDelete
  20. -=aShIsH=-July 10, 2010 at 6:16 PM

    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. AnonymousSeptember 8, 2010 at 11:28 PM

    What is as 400 used for?

    ReplyDelete
  22. NishaDecember 12, 2010 at 3:20 PM

    What is the advantage of using a Activation group?

    ReplyDelete
  23. AnonymousDecember 28, 2010 at 3:25 PM

    Max No. of Libraries we can create in AS400?

    ReplyDelete
  24. UnknownApril 20, 2011 at 12:58 AM

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

    ReplyDelete
  25. NishaJune 16, 2011 at 5:14 PM

    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. yzeroSeptember 3, 2011 at 12:17 PM

    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. UnknownSeptember 12, 2011 at 3:00 PM

    what r the device types of dds?

    ReplyDelete
  28. AnonymousApril 14, 2012 at 2:48 AM

    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
  29. sirishaApril 24, 2012 at 4:07 PM

    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
  30. NishaApril 26, 2012 at 12:22 PM

    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
  31. AnonymousMay 9, 2012 at 11:42 PM

    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
  32. AnonymousAugust 6, 2012 at 7:54 PM

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

    ReplyDelete
  33. AnonymousAugust 19, 2012 at 4:30 PM

    how i can know the creation date of a folder ?

    ReplyDelete
  34. AnonymousAugust 29, 2012 at 5:02 PM

    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
  35. AnonymousSeptember 27, 2012 at 5:53 AM

    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
  36. JCosta ResendeJanuary 18, 2019 at 2:50 PM

    how i can call API in java?

    ReplyDelete
  37. JCosta ResendeJanuary 18, 2019 at 2:51 PM

    how i can track changes in registers?

    ReplyDelete

Subscribe to: Post Comments (Atom)