• Relational database normal form

    Consider a relation scheme R(A,B,C,D) where A is candidate key. With no information about FDs involved, then R is in which normal form? Is it First Normal form or Second normal form or BCNF or Third normal form?

    Asimb5 pointsBadges:
  • Connection of DSN to SQL Server has stopped working

    My Linux application uses DSNs to connect to our SQL Server. For some reason, the connection has stopped working and I can't find the DSN's credentials. What should I do here?

    ITKE1,004,465 pointsBadges:
  • How to check if a table exists in MySQL server

    Hi, To connect to my MySQL server, I've been using an ODBC connection. Is there a way to check if a table exists in my database? And if it's not there, how can I create one?

    ITKE1,004,465 pointsBadges:
  • Create ODBC DSN in C#

    In C#, can I programmatically create a new ODBC DSN? If so, what's the best way? Maybe use P/invoke? Thank you.

    ITKE1,004,465 pointsBadges:
  • How to export ODBC system DSNs on Windows

    Hello everyone, I'm in major need of help here. I'm on a Windows machine and I need to export my ODBC System DSNs. How can I do that? Has anyone done that before? Any help would be greatly appreciated.

    ITKE1,004,465 pointsBadges:
  • Connecting ODBC from Python in Windows

    I'm currently using Windows. How can I connect ODBC from Python? Should I use pyodbc for this? If not, what are some other good alternatives? Thanks.

    ITKE1,004,465 pointsBadges:
  • Error messaging when connecting to DB2 database through JDBC

    I've been trying to connect to our DB2 database through JDBC from Eclipse. I already have the JAR file but I keep getting this error message: Error occurred java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver Error occurred java.sql.SQLException: No suitable driver found for...

    ITKE1,004,465 pointsBadges:
  • Connecting .NET to AS/400 using ODBC

    We are connecting .NET to AS/400 using ODBC when we call an SP in AS/400 from .NET, we are getting the null output. What might be the problem.??

    bharathtata30 pointsBadges:
  • Testing DB2 database connection

    I'm trying to test my connection to my DB2 database. Usually with my Oracle databases, I would just run 'SELECT' from dual but I know that's for Oracle only. How can I do this for DB2? Is there a specific SQL statement?

    ITKE1,004,465 pointsBadges:
  • How can I escape all CRLF chars in all column values when doing a select?

    Let's say I want to do: SELECT * FROM tableName But some columns' values have linebreaks, so in my MySQL console it breaks the formatting of the table. I know I can circumvent this by explicitly REPLACE()ing CLRF chars, but this requires me naming each column and is not very quick to type out, eg.:...

    hazzlewis5 pointsBadges:
  • iSeries DB2 – Have Physical File need to create Logical File to access Member

    I know very little about the iSeries (I can spell it is all). I am working with an ODBC connection to get to DB2 data on the iSeries. Everything is going extremely well other than 2 files that I need to access use members. These are the only ones that do on the entire system. I was told that I...

    mgrady15 pointsBadges:
  • Backup options for DB2 database

    I have a DB2 database that has over 150 GB of data. I'm using the built-in backup option to back it up daily. Here's my issue - it's taking a long time to finish. Is there another backup option I should look into? Thank you.

    ITKE1,004,465 pointsBadges:
  • Call stored procedures asynchronously on DB2 database

    I'm working on a DB2 database - would I be able to call my stored procedure from another procedure asynchronously? Thanks so much.

    ITKE1,004,465 pointsBadges:
  • Changing DB2 database column name

    On my DB2 database, I'm trying to rename the column name on one of my tables. How can I do that?

    ITKE1,004,465 pointsBadges:
  • Dump content from IBM DB2 schema into SQL text file

    For the past few days, I've been trying to dump content from a schema (that's from a IBM DB2 server) into a SQL text file. But I'm running into a dead end. What should I do here? Is there anything like mysqldump for MySQL? Thank you.

    ITKE1,004,465 pointsBadges:
  • Combine DB2 columns into single timestamp

    Hello all, I have a DB2 database that has two different columns: Date / Time. Can I combine these two columns into one single timestamp? Appreciate the help.

    ITKE1,004,465 pointsBadges:
  • View table structure of DB2 database

    Hello, can I view my DB2 table structure? What command should I use to do this? Thank you.

    ITKE1,004,465 pointsBadges:
  • Get current schema on JDBC DB2 connection

    As of today, I have a JDBC DB2 connection. Is there a way for me to get my current schema? Would a SQL statement work for this?

    ITKE1,004,465 pointsBadges:
  • Modify database line for EMBL format

    LOCUS SCU49845 5028bp DNA PLN 21-JUN-1999. Explain the above line from gene bank database. How would the line be modified so that it can be stored in the EMBL format?

    sourajoy35 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 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.

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

Following