Recent content by OAKEJ

I created a standalone java desktop application using netbeans. It works on my pc both in the IDE and without the IDE. The issue is when I put all of the objects that are in the project folder into a zip file and email it. When the pc tries to use the executable jar file it comes back saying...

I got it now, thankyou very much for your help, I'll try it out

Sorry can't open the example, explorer couldn't find page

Thankyou for you assistance, I'll try Apache POI

Does anyone have any expirience using jexcel api to populate a jTable with the data read from the spreadsheet using netbeans?

I have users that are putting in invalid codes, the hex value is 2A but I want to see if I can store these codes in a file and use the program to read thru all of them and scan the fields for them, the reason is that when I encounter more of them it would be easier to update the file with those...

Nevermind I have it now. SQL to change the Primary code to Y if it is the lowest cost............ UPDATE OAKEJ/FLPJ PJ SET PJPRMP = 'Y' ,PJCHGD = '1091113' ,PJCHGT = '1202'...

I need to update File(OAKEJ/FLPJ) and Set PJPRMP(Primary Supplier) to "Y" when PJLCOS(Last Cost)= WP1COS(the Lowest Cost from OAKEJ/FLCP1WP for Part 'A 680 322 12 25' as well as Set PJPRMP to "N" when PJLCOS>WP1COS **************Initial SQL STATEMENT*************** SELECT...

That was what I thought, I wanted to see if it was possible with Embedded SQL, but it doesn't look like it is. Thanks for the response.

Is there a way to use a variable in the From SQL statement, I tried :@FILE and it fails to compile, when I use @FILE by itself it will compile but in the joblog it says it can't find the file *LIBL/@FILE, any suggestions @FILE is a file name that is passed earlier in the program SQL...

I need to upload a csv file from my pc into a PF in the 400? Does anyone know how I could do that in a CLP routine? I've tried using the CPYTOIMPF from the command line without success. CPYFRMIMPF FROMSTMF('I:\TMP\AURAPARTS.CSV') TOFILE(IESR7TEST/AURPARTS) RCDDLM(*CLRF)

I'm relatively new to RPG and don't quite know it's potential or limitations, I have a PGM that builds a file then sends it in *XLS format to users via MAILXLS. The question that I have is it possible to pass VB codes into that spreadsheet that will be emailed to the users like a code to create...

EXEC SQL SET TRANSACTION ISOLATION LEVEL NO COMMIT END-EXEC EXEC SQL...

Does anyone know a good source of literature for embedded SQL in RPGLE?

Does anyone know if there are any good windows based RPG IV appliations out there?