• Prophet 21 Database Dictionary

    Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

    Carlosburkle5 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 pointsBadges:
  • Crystal Reports XI – SQL table fields that fail all compare tests

    I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as... if {mytable.mystring} = "test value" then 1 else 2 This is what happens during execution...  when the the preceding test is true, Crystal returns a...

    BTod45 pointsBadges:
  • SQL Work Files

    In the FOCUS programming language, you can retrieve data and hold that data for further processing at some point later in the program.  What is the best technique for doing this in SQL?

    Rhansard5 pointsBadges:
  • Receiving result sets in RPG (prior to release 7.1) from an SQL SP

    I have read through the IBM manual "Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries" for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this...

    MapleLeafDeveloper5 pointsBadges:
  • AS400 to SQL

    I am going to be leading a project to convert old AS400 data to SQL, and build a web front end.  Does anyone have a project charter, project plans etc I could use a a baseline for my write?  I'm looking for the whole gambit of information surrounding this 'conversion' and lessons learned etc. ...

    WayneGro15 pointsBadges:
  • Changing item color in Listbox

    I fill the listbox with tables from SQL base The colums are b1,b2,b3,b4,b5,b6,b7 There are up to 1 million rows in listbox example b1,b2,b3,b4,b5,b6,b7 are as follows: 1,2,3,4,5,6,7 4,5,14,25,35,36,39 14,15,22,23,25,30,31 1,7,14,18,22,26,30 If any row contain any of this numbers(1,4,14,23,35,36,37)...

    Ajibola110 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 pointsBadges:
  • Can you embed SQL statements in RPG program

    I am new to AS/400 and we have a project wherein we have to display the records grouped by some fields. Is it possible to write sql statements within RPG program?? How???

    Shwesmile20 pointsBadges:
  • Connect to Unix from iSeries

    I am trying to connect to EDW data mart on a Unix server from an SQLRPGLE pgm using the embedded SQL CONNECT TO code. I am getting SQLCOD = -000000113 when in debug and the connection fails. I have the code I can send in an email if you want? BCL2008

    BCL20085 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • SQL Query to consolidate rows into new table

    Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • SQL Query to get the difference from average for every row with grouping

    Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with... I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • steps for accessing sql data through ado.net code over LAN NETWORK

    steps for accesing sql data through ado.net code over LAN NETWORK

    Jib35 pointsBadges:
  • order by column number?

    Can you order by a column number, if so, what's the syntax?

    Shadowpuppet0 pointsBadges:
  • result shoud be like that pls *****sal**** in sql

       select ENAME, sal, (LPAD(SA,(4,'*')RPD) IS NOT WORKING.  THE RESULT SHOULD BE LIKE THAT WY. ENAME, ***SAL****  THANKS.

    Madina2875 pointsBadges:
  • SQL or How to find out Oracle COLUMNS containing value

    SQL or How to find out Oracle COLUMNS containing value "0" in a table. Suppose we have 20 columns in a table lets say 'T1' having column like C1, C2, C3, ----- upto C20, and we have to know in how many column zero or any other user specific value is present. Lets say in C1, C5, C7 there is/are zero...

    Maheshmamu20 pointsBadges:
  • CONNECTING SQL 2005 WITH VB.NET

    I used Linq to SQL method, but the problem is that at the last point where am suppose to add table, the instruction is that is should go to server explorer then open then table and drag items from server explorer to design surface, but i cant see any item to drag.Pls i need your suports,thanks

    Njubigbo5 pointsBadges:
  • SQL query How to select nth row from a table if they are not in any order

    How to select nth row from a table if they are not in any order

    Johnsmak5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following