• 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.

    ITKE970,560 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.

    ITKE970,560 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?

    ITKE970,560 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.

    ITKE970,560 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.

    ITKE970,560 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.

    ITKE970,560 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?

    ITKE970,560 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:
  • Where is a SQLite database file located on my Android device?

    I want to find the path to my SQLite database file in my android devices. Can I change the default save location to some other folder like Dropbox?

    hussain22juzer530 pointsBadges:
  • layer 2 & layer 3 switch

    Hi All, what is the basic difference between layer 2 & layer 3 switch. how can configure layer 2 & layer3 managable switch

    Psharma11760 pointsBadges:
  • Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE970,560 pointsBadges:
  • JDBC driver for Linux connect to DB2/400

    Because SAP HANA runs in Linux, I want export data to DB2/400. Where can I download JDBC Driver?

    lance2221357270 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:
  • How can I load CSV files into MySQL Workbench?

    I have several CSV files that need to be added into my database in MySQL Workbench. Is there a way to load them in? Is there a specific command I should use? Any help is appreciated.

    ITKE970,560 pointsBadges:
  • How to export database to CSV file

    I need to do this urgent! I have my database that I need to export into a CSV file. What's the best way to do that? Can I do it using PostgreSQL? This needs to be for the whole database (not just a table). Thanks!

    ITKE970,560 pointsBadges:
  • Loading CSV file into PostgreSQL table

    I have a CSV file that's set up like this: value1|value2|value2.... How would I be able to load these into my PostgreSQL table? Appreciate the help.

    ITKE970,560 pointsBadges:
  • How to show last entry in data environment in Visual Basic 6 and Microsoft Access

    How can I show the last entry in a data environment. I'm using VB 6.0 and Microsoft Access in the back end.

    HARDIKJOSHI5 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