Questions & Answers

  • SQL Server database: Inserting a table using the input from another table

    I've been trying to insert a table using the input from one of our other tables. I know this is possible but I'm having trouble with the correct Syntax for the SQL engine of the day. Would anyone know of a silver-bullet syntax coming from a SQL standard that would allow us insert the values without...

    ITKE346,430 pointsBadges:
  • Deleting a MySQL database through a Linux shell command

    For my MySQL database, I constantly update the schema files and then delete / recreate the database so our new schema is created. I do this by MySQL Query Browser, login and then delete the database. Now I'm looking to delete the database through a Linux shell command in Ubuntu.

    ITKE346,430 pointsBadges:
  • What’s the better database option: MySQL or SQLite?

    Our organization is deciding to use either SQLite and MySQL for our database. We understand that SQLite is a single-file database and MySQL is just a normal database. But in your opinion, what's the better option?

    ITKE346,430 pointsBadges:
  • unable to install Oracle 8i in Windows 7

    please help me to install oracle8i in windows7.it is giving error not found jrew.exe

    Hem5 pointsBadges:
  • C4040-129 IBM i 7.1 Administration

    Who has an updated dump version? Thanks Randy

    excellentrandy1,235 pointsBadges:
  • How to enable cookies on users BlackBerry Curve

    How do you enable cookies on the browser of a Curve?

    Itech5015 pointsBadges:
  • How should we be careful with a live database?

    For one of our clients, we work with them on their live database when they come up with a problem or they have bad data. Similar to Unix root access, it's pretty pretty dangerous. What would be the number one thing that we should learn about operating with live data.

    ITKE346,430 pointsBadges:
  • What’s the difference between a failed call and no answer

    What is the difference in failed call and no answer. I have noticed when I call a friend most of the time it goes to "call failed" immediately. Sometimes it take a while and says no answer. They are showing unavailable. When the available light is on, sometimes it says no answer, when they answer...

    monteweldon20 pointsBadges:
  • Learn AS/400 development

    I want to know sources (site/ document) for learn RPG, RPGLE, CL & CLLE . Its hard to learn those from IBM documents and the sites which I referred.

    Anshan50 pointsBadges:
  • Win2k sp4-2

    I upgraded my hp vectra machine(running w2k) from sp3 to service pack 4, now it is behaving erraticaly. It reboots it self, produce blue screen of death very often. Before the sp4 it was not behaving this way, though it was hanging for a while when restarting windows or at login. I update all...

    Senomango0 pointsBadges:
  • Why is NoSQL better than traditional RDBMS?

    I'm relatively new to the database world and I'm just getting into NoSQL. I want to know what makes NoSQL better than traditional RDBMS?

    ITKE346,430 pointsBadges:
  • How to fix a persistent connection error in Django

    I've been using Django with Apache, mod_wsgi and PostgreSQL (they are all on the same host) and now I need to handle a ton of dynamic page requests. But I've run into a problem with Django: It doesn't have a persistent database connection and keeps reconnecting for each question (which takes about...

    ITKE346,430 pointsBadges:
  • What’s the difference between create database and create schema in MySQL?

    For one of my projects, I'm looking to use a "information_schema" database and metadata but I'm still wondering if there are any actually differences between the "create schema" command and the "create database" command in MySQL. What are the differences (if there are any at all)? Thanks!

    ITKE346,430 pointsBadges:
  • Problem with PDF and Activex IBM iNotes 9 Control

    Hello, We have troubles with some kind of PDF files  when we want to open them on Notes Web Access (Version of Lotus 9.0.1) - Some PDF can't be open with IE but not problem with Chrome or firefox- We can't save them nor open them - We found that ActiveX IBM inotes 9 Control is guilty! We need...

    Michel37675 pointsBadges:
  • Microstrategy (Reporting tool)

    What is Microstrategy (Reporting tool)?

  • How to resolve the object store database is disabled error in Lotus Notes

    When I try to archive my emails, I'm getting " Notes error: The object store database is disabled " error. Please suggest us to resolve the error.

    Mohan55 pointsBadges:
  • Restricting Customer Master Screen Enhancement depending on Account Group

    Hello, I have added a new tab to receive an information (RDC) which will be saved in a new field of KNVV table.This was done implementing particular interfaces of BADIs CUSTOMER_ADD_DATA and CUSTOMER_ADD_DATA_CS. I now want this button to be visible only when a particular account group is selected...

    RGupta215 pointsBadges:
  • What’s the best way to connect and query my database for a set of C# records?

    I need some big time help with my database. What's the best way to connect and query my database for a set of records in C#? Please note that this is for a SQL Server database. Thank you!

    ITKE346,430 pointsBadges:
  • Creating CSV file from AS/400 fixed length physical file

    We are having a requirement that we need to create an interface file with different sections as follows. File Header, Data Header, Data Details and Footer. Each record is of variable length. But the information should follow the same format such as File Header should be first record then followed...

    Babs312195 pointsBadges:
  • Adding a new table to our SQLite database

    My team and I have already created SQLite tables but we're looking to add a new table to our database. Here's the DB version: private static final int DATABASE_VERSION = 2; We've also added this string to create the table: private static final String DATABASE_CREATE_color = "CREATE TABLE IF NOT...

    ITKE346,430 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