Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT...
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to...
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF? Software/Hardware used: RPG, CL, SQL, iSeries
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...
I have an sql : [strong]select customer invoice_no invoice_amount due_date from Table[/strong] This gives a list of all details in rows 99999 1234 12.50 21/11/09 99999 1235 13.55 22/11/09 99998 7899 12.20 21/12/09 99998 7900 12.75 22/12/09 99998 7901 11.11 23/12/09 I want a line...
Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February. The code I am attempting to use is below, but every time I use it, no records are...
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says the...
We have a department that has several applications running on Paradox 11. They need assistance migrating their tables and application UI/code to another platform. Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks
I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table. __________________________________________________________________ Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE",...
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...
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
VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35.....IN THE ABOVE GIVEN REFRENCE Software/Hardware used: SOFTWARE


