Domino web query returns incomplete result set
I’ve inherited a a web based application which when executed via the notes form returns a false result set. The sql query executes and returns the proper result set when run through query manager however, when executed via the Notes web form using the ALL ALL input search parameter only a partial result set is...
| March 5, 2014 4:27 PM
Looking for interchange software solution
We’re currently looking for interchange software that will allow us to send HTTP GET request w/ dynamic parameters to URL link and receive a response containing GZIP files and unzip these files and FTP unzipped files to our AS/400. We’re hopeful you can provide software recommendations or other options and we’re looking for immediate solution....
| February 18, 2014 10:26 PM
How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.
| January 23, 2014 8:38 AM
, MySQL Stored Procedures
, SQL stored procedures
, Stored Procedures
SQL / DB2 Optimization (timing out)
I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of...
| January 19, 2014 8:37 PM
, AS/400 DB2
I’m using a program that should not be asking for a Password in order to log in. I have uninsatlled the program twice and it continues to ask for a Password. My co-workers are using the exact same program and they are able to log in without entering a Password. Is there a particular file...
| January 13, 2014 4:16 PM
, Windows 7
I need help with a SQL problem
I have a SQL statement that reads as follows: select subject1, subject2, subject3, subject4, subject5, subject6 from card_catalog where subject1 like? This SQL statement works I just do not have the statement in front of me to type it in correctly. Is what my real question is. I have a TEXTBOX that stores the information...
| January 6, 2014 10:57 PM
SOA challenges and success factors
Dear all, I am looking for some expertise on SOA topic, especially the challenges a company meet while migrating to SOA and factors that has impact on success of SOA projects. I would kindly ask you to respond to the survey which will take you a few minutes. The survey consists of 4 parts including...
| January 5, 2014 5:47 PM
How can I manipulate a string in RPG?
I know this might sound like a “beginner” question but I know most of the time strings in RPG have a fixed length (but more importantly, have a finite length). But I’m pretty much lost on how to write a procedure for string manipulation. How can I write a procedure that takes care of a...
| January 1, 2014 8:28 PM
, String manipulation