• How to drop a DB2 table

    Hello everyone, I'm trying to figure out if a certain table exists in DB2. And if that table does, how can I drop it? Thank you.

    ITKE1,042,895 pointsBadges:
  • Checking DB2 table space

    Hi everybody, Can I figure out in DB2 how much space a table is consuming? I'm talking about the total space that is allocated to it.

    ITKE1,042,895 pointsBadges:
  • How to edit a view in DB2

    Hi experts, Would I be able to alter / edit a view in DB2? I would like to use System i Navigator. I don't want to delete it because I'll have to create it again. Thanks!

    ITKE1,042,895 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,042,895 pointsBadges:
  • 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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,042,895 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