• Plausability of natural key as primary key

    If you have a field in a table that is a natural key and meets all the criteria for a Primary key, is it advisable to use that natural key as your Primary? Or is it a better idea to assign a surrogate key (i.e. autonumber for TrainingProgramID instead of using TrainingProgramName)? Thanks in...

    Bdpowell25 pointsBadges:
  • How to find out which embedded SQL taking more time in RPGIV program

    Hi All, I have 4 Embedded SQLs in my RPGILE program. Can any one tell me how to find out which SQL taking more time to execute ? are there any commands/methods to find out ?

    Mohan K695 pointsBadges:
  • oracle9i

    i want to learn the oracle9i for get the job of DBA .for that what website i have to go?

    Kaninfoway15 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • Data Entry in Microsoft Access using ASP

    Data from the form not able to add into the database although using Internet sample source code.

    Mr.Poor In IT10 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • Using Microsoft Access to create reports from MACOLA

    Where can I get instructions on using Microsoft Access to create reports from Macola?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Generating ASPX pages from a MYSQL table

    I have a series of MYSQl Tables that I want to inspect via a web page, generating the logic to simply display the data is straightforward, however, it's tedious to create each page then write the logic to make the data editable. Since it's largely repetition it should be fairly easy for someone to...

    Jerry Lees5,335 pointsBadges:
  • COMPARISION OF DBMS AND RDBMS

    what is the difference between DBMS and RDBMS

    Pravi5 pointsBadges:
  • CRViewer Logon Failed error within Visual Basic 6

    I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few others,...

    Lamm10 pointsBadges:
  • Embedded SQL in an RPG FREE program

    I am developing an on-line screen program, where the user can select a view of the data from a list of "views". This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading the subfile. First...

    Merts30 pointsBadges:
  • Oracle Forms 6i and Oracle 11g database – Multilingual I18N

    HI, We have Forms 6i, we are going for Multilingual, and it has Oracle 11g db. We are updating the database with one more column in an exiting table with NVarchar2. The approach we are going for Column level Character set Updates. One more approach is Full Database level Character Set. I try to...

    Gguruji5 pointsBadges:
  • Numbers of records in flat file without opening it?

    Can we find the number of records in the files using the parameters Space used , Space allocated, LRECL, BLKSIZE in mainframe or are any other parameters required. I have to find the no of records without opening the file or even accessing it. Is it possible.

    K19085 pointsBadges:
  • FoxPro 2.6 for DOS

    when programs (small or large) runs in foxprox 2.6 for DOS the CPU usage showing 100%. how can i solve this problem

    Zarkos5 pointsBadges:
  • Delete duplicate values in Microsoft Access

    there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

    Kimidiramana30 pointsBadges:
  • CPYTOIMPF –FLDDLM(*TAB) QUESTION

    Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...

    VRSTEEL5 pointsBadges:
  • Oracle OLAP degenerate dimension

    Hi, How to declare a dimension as degenerate dimension in oracle Analytic workspace manager(AWM) tool? Is there any other tool to achieve this or any manual process involved? Thanks in advance, Vinay

    VinayOLAP30 pointsBadges:
  • Tables, queries, and database with Visual Basic 6

    hi i am developing a visual basic application with (vb6.0)and have the following questions,1. how will i add a table in my application and then use one column to be getting data from another table. 2. can i make a query in .mdb and then run it in visual basic.how will i do it if its possible, i...

    Ndonye5 pointsBadges:
  • SQL Data Types Conversions

    I'm new to SQL. Anyone have a good example or link of converting from one data type to another. We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or "numeric" data types. Our iSeries ERP solution...

    MikeBaker5 pointsBadges:
  • How to use Store Procedure for multiple column database update?

    I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

    KjitSingh5 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