• Converting DB2 Timestamp to UTC milliseconds

    I'll get right to my point - would I be able to convert my DB2 timestamp into UTC milliseconds? Is there a function to do this? And yes - I'm currently doing this in SQL.

    ITKE1,071,740 pointsBadges:
  • How to convert DB2 timestamp into Unix timestamp

    Hi experts, I've been trying to convert my DB2 timestamp into a Unix timestamp but haven't had any success. Is there a built-in function to do this? SQL command? Thank you.

    ITKE1,071,740 pointsBadges:
  • How to see DB2 definition view

    Does anyone know if I'm able to see the definition of a view in DB2? Is there a SQL query I can use? I already tried this code: SELECT * FROM SYSCAT.VIEWS But I'm getting an error message saying it's an undefined name. What can I do?

    ITKE1,071,740 pointsBadges:
  • Run DB2 queries on Linux machine

    I'm fairly new to DB2 - been working on for the past few months. I just installed DB2 on my local machine and I'm trying to run my queries through the terminal. This is a Linux machine. Whenever I try to run any queries, I keep getting this error message: SQL1092N "ROOT" does not have the authority...

    ITKE1,071,740 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,071,740 pointsBadges:
  • Transfer Oracle tables into DB2

    I need to access several Oracle tables and copy them into DB2. What's the best way to do that? Thanks so much.

    ITKE1,071,740 pointsBadges:
  • How to rename a DB2 table

    Inside of DB2, I'm trying to rename one of my tables. But I keep getting this error message: the name "mytable" has the wrong number of qualifiers.. SQLCODE=-108,SQLSTATE=42601 What should I do? How can I fix it.

    ITKE1,071,740 pointsBadges:
  • 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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,071,740 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