MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...
Dear Sir, Can someone kindly help me with the following: I want to export html to word with an image. I struggle a lot to do this. Appricate it if someone can help me. Thank you Jessica Software/Hardware used: Visual studio 2008
I am working on vb dot net code which is used to send email from the desktop application, it is not working CORRECTLLY. I need your expertee help Please !!!!! The main problem arises when I tried to attach multiple files or i tried to attach a file in the array and for loop. Below is the...
I am working on a project where I need to be able to pass a string through a SHA-2 encryption and then use the result as part of a call to open a URL. The URL call is a breeze.., If there source code out there that has the SHA-2 algorithm that can run on the iSeries? If it has to be in a JAVA...
Hello . I've developed a local website using xampp , and I want to access the mysql database in it to develop a J2SE application. Is it possible ? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind . Thank you very much . ...
Hi, Can anyone explain me how to set a value to combobox in lotusscript through code Thanks Raji
Hello, Would you please anybody tell me what are the test conditions or what are the procedure to test of storage product that is based Service Oriented Architecture and file based secondary storage product. Thanks Bib
Performance testing, Performance Testing Tool, Service-Oriented Architecture
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on it Software/Hardware used: AS/400 sql400 DB2
Hi, I want to write a formula or javascirpt in such a way that on click of a value in one combobox(AccountType) , i want one value to be displayed in another combobox(PSD Indicator).If i am writing a java script on one event there is nothing being displayed.Can anyone explain me how to implement...
Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it? Software/Hardware used: MySQL
Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...
I am using windows XP and need to write a DOS batch (.bat) file that will delete old files from a directory. This will run on a schedule and will not require human interaction to input any data. My problem is, I am not good at writing batch files. I can do the basic 101 type stuff, but finding...
I cannot query result from my custom Database View created from TOAD SQL, anyone knows why? I have granted access for the user.
I have a program I did in visual basic 4, after adding the custom control Microsoft Multimedia Control, everyone seems the get this error, I’ve not seen it yet, but they all seem to get it, it something like Custom control 367mc can’t load control, and it seems the be this mmc that I added for...
When you have a file and your the creator of this file.exe and put it on a server, others can down load, but they get a msg. saying Unknown Publisher, is there a way you can let ie. know who the publisher is, so they don't get this warning?
I've been noticing a dropoff in profile pictures lately -- here's a reminder on how to upload yours if you haven't already. If you're participating in the community, we want to know who you are! I'll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload...
I'm a little stuck. I'm trying to follow some guides regarding using CGIDEV2 on my iSeries V6R1 to do AJAX. I've looked at easy400.net as well as some other references, but I keep having the same issue. I keep getting error CPF980F 'Binding directory [dir] in library *libl not found.' Do I...
I know you can set breakpoints without using F6 by typing break and the line number at the debug screen. I need to know how to set up a conditional break point. I essentially need to know exactly when a field is being populated. How would something like this be correctly written: "break when badd3...
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL


