Recent content by jmd0252

might go to jdelist.com to post this question. not many jde people on this site.. As asking, have you looked at the business rules for JDE,, I was on World 7.3 cumm 11,, and I remember somewhere where we defined the business rules, for what went where, but that was like 6 years ago..

you may have better luck asking the question on jdelist.com, more edwards people over there..

I believe that as long as the field is defined as a "date",, then subtract that field fron todays date, and get the number of days that have elapsed.

Well,, you could run the YTD totals, as an sql command, and join the 2 tables, using the ytd as your basis for your join. because if it is in the ytd nnumbers, it may or may not be in the other numbers, so be sure and make provisions, if the other numbers are null ( ie not there).

do you know how to do a wrkqry, an IBM utility? If so,, go thru that, and pick upi records where the "key" matches,, that way you can be assured that the data is valid.Then you could try a setll and do a reade, and see what happens..

do you have anything in your database manager, that would allow you to create a "view"? That way you can create the view and "see", the underlying sql atatement.

you might try a set lower limts, but I would do a read equal. My initial question was you are sure that filea, does contain some records that need to be deleted.. so you do have some where the chain "hits"..

I'll ask the obvious. You are sure that some file a records are in file b?

Well, try this the math does work. take your decimal value, say.25 and multiple by .6 the result is .15. I have done the math, and it works thru.9 for the decimal, which equals out to .54. A tenth of an hour ahould be 6 minutes.

What kind of problems are you having???

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzaiq/rzaiq.pdf This is an IBM reference, you should be able to find the info you need..

There are not many JDE people on this web site. You better bet would be to go to jdelist.com. It is a site deveoted to JDE, and the AS400. You can find info both on the World,and the OneWorld, to use the "old" names..

DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QTEMP/TEMP1) doing this command will create a file named temp1, in the library qtemp,, now you can change the command to fit your needs,, then you can do what you want with your file..

I would try setting up a mapped drive on the server, into the access database, and see, if that helps.

You could create a view in say SQL, and when you create the view, you do a "UNION", which combines all entries from table1, and all entries from table2 into a brand new file.. Would that give you what you need??