Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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.

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?

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...

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...