Search results for query: *

Thanks, I took your advice, did a Join on both files and got the results I was looking for. Thanks again, I appreciate all the help I can get. [smile]

I've read some posts in this forum but only see snippets of code and don't understand all of it. Somewhat new at this. This is the procedure I am creating with a few comments. Using the most recent cust date in hdr file, i created a cursor to retrieve data from detail file with the most recent...

Thank You !

I only know RPG, some Sql that I reference in SQL/400 and I develop code in RDP. Sorry, should I ask somewhere else on this website? Thanks for looking at my post[smile]

Please ignore this post. I moved it from RPG to Sql , sorry.

RPGer trying SQL. I've read some of SQL posts in this forum but only see snippets of code and don't understand all of it. This is what I came up with just from using my SQL book and reading posts. I want to get detail for the hdr record cust/date. Then I want to delete dups and update the date...

RPGer trying SQL. I've read some of SQL posts in this forum but only see snippets of code and don't understand all of it. This is what I came up with just from using my SQL book and reading posts. I want to get detail for the hdr record cust/date. Then I want to delete dups and update the date...

Thank You, I didn't see that:( Thanks for all your help as always, and have a great day!!!

Does anyone know how to convert a date to the hundred year date format. For example, how would i convert 8/11/2004 (B3ForD) to its hundred year date (wA3EndD) format? I appreciate any suggestions. Thanks in advance.[flowerface]

Thank You for your help! I want to read each record in FileA, chain each record to FileB and if that filea record is not found in FileB, delete the record from FileA. Filea should always contain records that need to be deleted, but i guess there is the possibility there wouldn't be. Tf the...

Thanks, that gets me stuck in a loop. Should I setll on fileb instead of chaining?

Thanks for responding....It is possible filea records are not in fileb. If filea records are not in fileb, i want to delete them from filea.

Not good at this, as you can see, I want to read every record in FileA, Chain to FileB and if not found in FileB, delete the record from FileA. but I am deleting the entire file. sounds simple but I cant see my mistake. Please advise. FFileA UF E K DISK FFileB IF E K...

Thanks for the explanation in comments, being a newbee, I appreciate that. U R the best!!

I am trying to convert this piece of code to freeform, but I am not sure what to do, tried several different things from online forums, but not working , can you help? Not very good at working with arrays. D ZXB S 9 0 DIM(10) D XITEM DS...

Got it!

Can someone help me make this work? When i converted my pgm to free form, this is what i got. I have tried several diff ways, but there are so many diff date formats, i cant seem to get one to work. Sorry, i am a newbee. D w_Date S d D w_IsoDate S...

Thanks!

Rookie, Jr Programmer here. I converted one of my pgm's to free form, but not everything converted. Can someone send me some samples of 'O' spec conversions. thanks