• How to get DB2 table name from a column

    My apologizes if this question doesn't make sense at first but I'll give it a shot. I'm trying to find the table name from a column name in DB2. I already have the column name but need to figure out the table name (so I can see which column it should belong to). Is there a query for this?

    ITKE1,012,085 pointsBadges:
  • DB2: Find special characters in records

    There are millions and millions of records in my DB2 database. I found several fields with special characters that should not be stored. I believe it may be related to wrong/broken data. Is there a way find these records? Thank you.

    ITKE1,012,085 pointsBadges:
  • Stop DB2 query from finishing

    For the past few weeks, I've been trying to optimize my query in DB2. But whenever I make a change, it takes forever for the query to finish. It's taking way too much time. Can I see the query and possibly stop them? Thanks!

    ITKE1,012,085 pointsBadges:
  • Shrink and grow DB2 string dynamically

    For DB2, does anyone if there's a datatype that would shrink / grow a string dynamically? I need something similar to Varchar(Max). Is there anything out there like that?

    ITKE1,012,085 pointsBadges:
  • DB2: How to insert a date

    Hi all, I need to insert a date in DB2. It has to be under this format: yyyy-mm-dd How can I do this? Perhaps a SQL query?

    ITKE1,012,085 pointsBadges:
  • Limit number of deleted DB2 table rows

    I need to add some security measures for when I delete several lines on my DB2 table. Basically - I need to limit how many rows are deleted. Something similar to how MySQL works with limiting rows in a deletion. Can anyone help me out?

    ITKE1,012,085 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,012,085 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,012,085 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,012,085 pointsBadges:
  • Find available DB2 indexes on table

    On a DB2, how can I find all of the available indexes on my table? Is there a command for this? Thanks.

    ITKE1,012,085 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,012,085 pointsBadges:
  • DB2: Get value of last inserted ID on table

    For DB2, would there be a way for me to get the value of my last ID that was inserted in my table? Any help is greatly appreciated.

    ITKE1,012,085 pointsBadges:
  • DB2 table columns description

    I'm using DB2 - I need to know the description of all the columns in my table. Can I do this using SQL? Thanks so much.

    ITKE1,012,085 pointsBadges:
  • Connecting Python to DB2

    My apologizes for the brief question but I'll get straight to the point. How do I connect Python to DB2? Can anyone help? I just need someone to point me in the right direction.

    ITKE1,012,085 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,012,085 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,012,085 pointsBadges:
  • Checking DB2 version on Z/OS

    I'm on Z/OS and I need to check my DB2 version. How can I do that? I want to use SQL commands. Thank you.

    ITKE1,012,085 pointsBadges:
  • DB2 left outer join

    Left outer join is giving spaces between the values of 2 columns, how to get the output without any space in between, tried using '||' but getting error on CURRENT DATE field?

    shushank5 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:
  • IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm190 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