• Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 pointsBadges:
  • Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • I want to assemble a workstation and I don’t know which correct board to use

    I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media contents...

    dixton20105 pointsBadges:
  • Crystal Reports 9

    Hi, I'm using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I'm unable to query it even after I have verified all the options such as tables, views etc in the "Options". But none of them have...

    code4565 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

    RangjungDorje20 pointsBadges:
  • Multiple subnets on one physical network

    I am setting up a fairly large wireless network. We have a fibre connection to the internet for a small community wireless project to give high speed to the 10-20 houses in the area. The router device is a windows PC running with two NIC cards, it is hardened down to very minimal services, with...

    Johnshoff60 pointsBadges:
  • I want to select months from Jan to Dec using SQL query

    I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

    44063860 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh31,855 pointsBadges:
  • DB2 Date function to convert number to Date

    In Cognos-Framework Manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated...

    Meenac0 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • Loading CSV files into Oracle tables

    I want to load data from the Microsoft Excel sheet to my Oracle 8i database. Can I achieve this using TOAD? This question posed on 10 March 2005 You cannot use TOAD to move your data from MS Excel to Oracle. You can save the Excel spreadsheet as a comma-separated-values (CSV) or text file. Then use...

    Gaugelc0 pointsBadges:
  • How to create a CSV file in PHP code?

    I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

    Texmansru4725 pointsBadges:
  • Data warehouse vs Database

    What is the difference between a database and a data warehouse?

    Gayle5 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • DB2 Unload and Load JCL using IBM utility

    Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I'm new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need to get the syspunch file created first and...

    Ari200940 pointsBadges:
  • SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 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