Autmaticly move from as400 sesion to a web search on pc connected to the web
Is there a way for me to run a script that would toggle from my pc as400 session- open up a window explorer session and go to a particular website with the correct parm passed so that I could then retrieve a web bill for display on the pc. I would like to have a cmd key on the 400 that allows the...
Is there a way for me to run a script that would toggle from my pc as400 session- open up a window explorer session and go to a particular website with the correct parm passed so that I could then retrieve a web bill for display on the pc. I would like to have a cmd key on the 400 that allows the...
25 pts.
how can we use ponter in function keys?
usually we are using if *in03=*off like that instead of this i want to give directly IF EXIT like that I think some pointers are used to this i am not sure about that please replay me this question.
usually we are using if *in03=*off like that instead of this i want to give directly IF EXIT like that I think some pointers are used to this i am not sure about that please replay me this question.
How to read records in all of the members of a single pf?
I have a file name file1. it has 30 members. i have a input value from a display file and i need to check it in all the members. If it match i write the record in file2. How to read records in all members of a single pf?
I have a file name file1. it has 30 members. i have a input value from a display file and i need to check it in all the members. If it match i write the record in file2. How to read records in all members of a single pf?
How do I find out how many lines of source code are on the system?
Hello. I'm trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there's gotta be a better way to get the information i need. So far, this...
Hello. I'm trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there's gotta be a better way to get the information i need. So far, this...
EVAL Math Problem
Bruce, can you figure out this piece of code? I don't understand the result I get. Before code is executed: XXAVAL = 0, LTSTHQ = 30, LTCUSQ = 30, LTPICQ = 0, XPQTY = 30, OLOLQT = 30 EVAL XXAVAL= LTSTHQ-(LTCUSQ+LTPICQ+XPQTY)+OLOLQT After code is executed: XXAVAL = 0. I figured XXAVAL...
Bruce, can you figure out this piece of code? I don't understand the result I get. Before code is executed: XXAVAL = 0, LTSTHQ = 30, LTCUSQ = 30, LTPICQ = 0, XPQTY = 30, OLOLQT = 30 EVAL XXAVAL= LTSTHQ-(LTCUSQ+LTPICQ+XPQTY)+OLOLQT After code is executed: XXAVAL = 0. I figured XXAVAL...
Having trouble with DB2/400 UDF returning a table.
I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive...
I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive...
formatting date of 1070112 as 12-01-2007
I am having the date format of 1070112(yyddmm), which i've to convert into the form of 12-01-2007(ddmmyyyy)using RPGLE.
I am having the date format of 1070112(yyddmm), which i've to convert into the form of 12-01-2007(ddmmyyyy)using RPGLE.
Multiple Sorts Without Using Multiple Function Keys
When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act like that in...
When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act like that in...
User Exit Programs-FTP
Hello I am strggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture...
Hello I am strggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture...
calling a C function in COBOL ILE
In RPGLE I can call a C function like this: D sin PR extproc('sin') D parm F value C Eval mySine = sin( deg ) How do I do this in COBOL? Any examples? Thank you.
In RPGLE I can call a C function like this: D sin PR extproc('sin') D parm F value C Eval mySine = sin( deg ) How do I do this in COBOL? Any examples? Thank you.
How to check for a junk value in Numeric Field in RPGLE
How to check for a junk value in Numeric Field in RPGLE?
How to check for a junk value in Numeric Field in RPGLE?
Cursor using update and order
I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql ...
I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql ...
How to update in SQL using DS
My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the...
My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the...
SQL update question
I'm new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I'm updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update set record = :myds ...
I'm new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I'm updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update set record = :myds ...
SQL and CL
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?
