Search results for query: *

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

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

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

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?

I'm fairly new to SQL Server 2005. I imported a Table, made a package that queries the data from the imported table, however when the package runs in the nightly refresh it runs the query but doesn't update the imported table data. Has anyone run into this before. The package is debugged and...

I'm new to SQL Server 2005 and I've got a SQL query that I keep getting a Invalid Column Name, SELECT newreg AS region, crsite AS location, CASE WHEN crsite='COLU2' THEN.03 WHEN crsite='COLUOH' THEN.2 WHEN crsite='GARYIN' THEN.24 WHEN...

I have a report in Visual Studio. In the data tab I created a Region Dataset from my main data to use as a drop down parameter in my report. The problem is that I have three subreports in that main report that I set the parameters to reflect the dataset. It works fine for three of my four...

I'm trying to create a report from an ODBC data source and am having problems. Query Select Region,Site,Repair from Expenses where Region IN(?) When I try to use a multi-value parameter I get this message Cannot add Multi-Value Query Parameter '?' for Data Set 'Expenses' because it's not...

I have an access database that has 6 linked spreadsheets. The question I have is when one of them is opened by another user it halts my query. I really don't want to import them so is there a way around this to where no matter if they are all open I can still access them?

Is there something that will return the day of the week name, like in DATEPART or something. I know how to do it the long way I just don't want to if I don't have to ex. DATEPART("dw",GETDATE())=3 - result wanted is Wed the only way I know how to do it is CASE WHEN DATEPART("dw",GETDATE())=3...

I need to create a Control Chart or something similar. I noticed that there's no Control Chart option in RS. Does anyone know of something that I could substitute in it's place. Like a custom column chart Thanks

I have a report with a main group with a sub group that I'm having problems with. Hopefully someone can help me with this Example: Main Group Sub Group # of Memphis New Alabany 20 Memphis Memphis 25 The problem is it will show on the drill down as Main...

I want to use the Top 10 to scan the table and show me the top 10 costs by site, the way the query is now, it just returns the top 10 of all sites. Any suggestions ----------------------CODE--------------------------------- use BI_db GO SELECT OBSITE as Site TOP 10 ,OBREPR as Repair...

I have read/write permissions to a database but when I right click on the database>Tasks>, I have no option to import. The options that I do have are: Detach, Shrink, Backup, Restore & Generate Scripts. Any Ideas of what it could be?

I have to learn SQL Server quickly, and I'm very new to it - virtually starting from scratch but I'm pretty good with the SQL language. What tutiorials, literature or websites would you recommend that would be helpful. Thanks