iSeries SQL UDF gets CPF426A
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...
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...
5 pts.
Migration from Paradox to MS Access or VB.Net/MS SQL
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
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
How to convert LONG to CLOB or to VARCHAR type in select statement
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, 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...
About Time
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
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
SQL query help
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...
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...
MySQL database size
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
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
Converting SQL 7 Database to Excel
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks
How to use SQL to filter columns in a spreadsheet.
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",...
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
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...
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...
STRQMQRY in batch on i5
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
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
I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS
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
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
SQLRPGLE
I've Report to print using SQLRPGLE The Report criteria screen has around 15-20 select conditions...based on the conditions entered by the user, I build a query of type Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many select...
I've Report to print using SQLRPGLE The Report criteria screen has around 15-20 select conditions...based on the conditions entered by the user, I build a query of type Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many select...
Using SQL with MS Access and the AS400.
Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...
Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...
ms sql query problem with a case statement
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
[strong]This code works: SELECT passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...
Convert and Expand Field through SQL/400
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...
SQL EXPLAIN
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?
Updating a View
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ
SQL Communication Area
Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance
Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance
SAP on SQL Server and NetApp
Hi Everyone, We are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...
Hi Everyone, We are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...
