Recent IT Questions

1 - 20 of 820
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

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

Answer Question   |  Nov 6 2009  3:02 PM GMT
iSeries, SQL, UDF Returning DATE
asked by RJonesPartrick

  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

Answer Question   |  Oct 30 2009  9:11 PM GMT
VB.NET, VB.NET 2008, Paradox 11
asked by ScotE

  35 pts.

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

View Answer   |  Oct 30 2009  8:00 PM GMT
Oracle, Long, CLOB
asked by SamG

  15 pts.

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

View Answer   |  Oct 27 2009  6:03 AM GMT
PL/SQL, SQL, Oracle
asked by Checkp3

  10 pts.

Sound from .net

how can I save and retrieve sound wav files to and from sql database using vb.net?

Answer Question   |  Oct 27 2009  4:53 AM GMT
.NET 2.0, .NET, SQL
asked by Semauel85

  15 pts.

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

View Answer   |  Oct 26 2009  1:24 PM GMT
SQL, SQL Query, SQL queries
asked by CompEng

  570 pts.

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

View Answer   |  Oct 25 2009  5:45 PM GMT
SQL, MySQL, PHP
asked by Worktopm

  5 pts.

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

View Answer   |  Oct 25 2009  7:37 AM GMT
SQL 7, SQL to Excel Database Conversion, SQL
asked by Bertski

  15 pts.

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

View Answer   |  Oct 23 2009  12:43 AM GMT
SQL, Access Datasheet
asked by CompEng

  570 pts.

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

Answer Question   |  Oct 23 2009  1:15 AM GMT
SQL, Oracle 11g
asked by ITKE

  10100 pts.

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

View Answer   |  Oct 19 2009  4:16 PM GMT
SQL, CL, SQL development
asked by TOASTY

  35 pts.

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

Answer Question   |  Oct 17 2009  5:21 AM GMT
SQL commands, SQL
asked by UUKKY

  15 pts.

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

View Answer   |  Oct 14 2009  10:05 PM GMT
SQLRPGLE, SQL, RPGLE
asked by Nutangujar

  745 pts.

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

View Answer   |  Oct 13 2009  2:16 PM GMT
SQL, MS Access Database Table
asked by CompEng

  570 pts.

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

View Answer   |  Oct 10 2009  3:02 AM GMT
MSSQL, SQL, CASE statement
asked by Rinkratt

  20 pts.

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

View Answer   |  Oct 9 2009  4:37 PM GMT
SQL, AS/400
asked by Rjejcsb

  5 pts.

SQL EXPLAIN

How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?

Answer Question   |  Oct 9 2009  3:18 PM GMT
SQL, columns
asked by ITKE

  10100 pts.

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  

View Answer   |  Oct 8 2009  8:00 PM GMT
SQL, Database, Data management and storage
asked by DCDJ

  30 pts.

SQL Communication Area

Hello, Can anyone explain the fucntionality of the program QSYS/QSQROUTE in AS400. Thnaks in advance

View Answer   |  Oct 7 2009  10:51 AM GMT
QSYS, QSQROUTE, SQL
asked by Sris1986

  55 pts.

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

View Answer   |  Oct 2 2009  9:51 PM GMT
SAP, SQL, NetApp
asked by DebDonohoe

  5 pts.

1 - 20 of 820
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>