Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Fooch
  • Content: Threads
  • Order by date
  1. Fooch

    Calling an RPG Program from Java

    I have a java web app running on a Tomcat server. And I am trying to call an RPG program that exists on an AS400 and pass it parms. I can do this with the CommandCall method and passing it an AS400 object. And then using the .run method to create a CL string to call an RPG program. The problem...
    • Fooch
    • Thread
    • Replies: 1
    • Forum: Java
  2. Fooch

    Can you get the name of the DB you are currently connected to in SQL?

    I have a program with a lot of SQL connections in it and although I know how to open, close, use, change, etc. I can't find a way to pull the DB name I am currently connected to. I have a service program with a log procedure in it that does SQL connects. What I want to do is when the "logger" is...
  3. Fooch

    SNDDST and error CPF900C

    This is a small part of a program to show what I am trying to do... H BNDDIR('QC2LE') .... D RunClCmd PR 10i 0 ExtProc('system') D CmdString * Value D Options(*String) D ExpMsgId S 7...
  4. Fooch

    Automating Report Creation

    I am fairly new to the software so please excuse my ignorance. I am automating a process that at the end I would like to pass parms to crystal and have it generate and email a report on it's own. Is this possible? If so, can someone point me in the right direction to research this? I am on...
  5. Fooch

    RPG interfacing with Web Forms

    This is kind of a long shot, but I was thinking outloud and just wanted to see if anyone knew if this was possible or not. I am automating a process that starts on the iSeries in ILe RPG. After this process starts I need to go to an intranet webpage and fill out a "Request for Services" to the...
  6. Fooch

    Put a Record Format Into an array

    I swear I knew a way to do this, but I can't remember it or find it. What I want to do: There is a file, at the end of the record is a list of 20 fields, all defined the same. I want it so that as soon as I read a record, my array is populated with those 20 fields. I don't want to have to move...
  7. Fooch

    Issues allowing IBM to handle SubFile paging.

    If you don't put "pageup", "pagedown", "rollup", or "rolldown" on the display and you just fill the entire subfile before you display the screen, IBM will handle your paging up and down, but is there any way to get the "More..." and "Bottom" words to show up with the subfile when you do it this...
  8. Fooch

    SQLRPGLE and the PREPARE Keyword

    I am trying to use SQL to remotely change files on other machines. They exist on different libraries on different machines, so I HAVE to dynamically change the Library, and possibly file, so I need to PREPARE an SQL statement...but I am having some issues using fields in the PREPARE statement...
  9. Fooch

    Pointers to pull multiple fields into one.

    Is there an easy way to do this, I have an SQL table set up like the folowing: Create Table TRM003R ( "File Name" for Column "FILE" CHAR(10) Not NULL, "File Library" for Column LIBRARY CHAR(10) Not NULL, "Machine 1" for Column MACHINE1 CHAR(8) Not NULL, "Machine...
  10. Fooch

    QDBRTVFD issues

    I am using this API to pull the Max number of members allowed in a file and the Current number of records in a file. I am using the API correctly and everything with this as my return variable from the User Space. D FileInfo DS Based(UsrSpcPtr) D MaxMbrs...
  11. Fooch

    Free- Form equivilant to TestN()

    Does this exist? I need an easy way to check if the value that was passed in from a CL is a valid number. Because of they don't pass the number in as three chars(ie '060', '040', etc) RPG pulls the values as junk. There is no way for the CL to pass me a number and get it correctly in the RPG. So...
  12. Fooch

    Pulling Values from the 'system' procedure

    Is this possible? I am trying to pull the total number of records currently in a file. I ahve been using the QDBRTVFD API to get all the information I need but I can't find anything in there to get the number of records in the file. But I DID find a CL command to do it and I wanted to use the...
  13. Fooch

    Moving arrays in Free Form

    I know MoveA cannot be used in Free, and I know you should use %SUBARR to move arrays, but I have a field that is 30 long and filled with 10 values, all 3 long. I have a DIM(10) array size 3A and I want to move the value in the field across all the elelments in the array but I can't get it to...
  14. Fooch

    Job Date

    Is there a BIF or something that will allow me to pull the Job Date? The reason I ask is because I am working on a program that is in a job scheduler and when it is run it is supposed to run a report for the current date, but sometimes the program runs over midnight because it queries the date...
  15. Fooch

    Write statements being queued instead of written?

    I have a program that is pretty straight forward as far as my changes. As I am walking through it in debug and it goes over the "WRITE" line it completes it successfully and goes through the fields but it doesn't actually write the record(s) until I back completely out of the program...any idea...
  16. Fooch

    Breaking on a Submited Job

    Is there a way to get a submitted job to break so that I can debug it?
  17. Fooch

    Free form and MOVE

    This may be a dumb question, but is there a MOVE equivalent in Free form? There are many times when I have needed to force a numeric into a char for certain reasons, or vice versa. For concatination or things like that where %CHAR won't work because of the deletion on leading zeros.
  18. Fooch

    Date fields and Days

    This may be a long shot, but can RPG determine the day(Thursday, Saturday, Etc.) from a given date field? To like determine it is a weekend or something?
  19. Fooch

    Running CL Commands within an RPG Progam.

    What is the most efficient, easiest, or best way to go about running CL commands from within an RPG? I ask because I have a program that monitors a data queue and whenever a record shows up it is procesed and send to the file in the library specified by the data queu record. Since this will...
  20. Fooch

    Indicators

    This may be a stupid question and something i should know but I have no had to deal with it in years. Are there Indicators already defined for the F-Keys or enter key or anything in RPG? I am looking at old programs and I see that there are indicators like *INKL, *INKE, *INKC, etc. and there...

Part and Inventory Search

Back
Top