• How to import PDF file into DB2 blob field

    My table has a blob field that usually stores a PDF or even an image. For the most part, I use a Java EE application. But sometimes, I have to update the Blob field through a command. Is there a better way to do that? I don't want to use coding. This is on DB2 too. Thanks.

    ITKE970,245 pointsBadges:
  • Query DB2 database table comments

    Hi, Can I query all of the table comments in my DB2 database? Basically - how do I select all those comments? Thank you.

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

    ITKE970,245 pointsBadges:
  • Restore DB2 system tray icon on Windows XP

    Yes - I'm still using Windows XP but here's my issue - I just closed my DB2 system tray icon but now I can't restore it. I even tried a reboot but that didn't work. What should I do?

    ITKE970,245 pointsBadges:
  • Exporting DB2 file without DB2 server

    Here's the issue - I was given a DB2 file but I don't have a DB2 server. I need to export all of its data without the server. Is there a tool for this? It doesn't matter if it's for Linux or Windows. Thanks very much.

    ITKE970,245 pointsBadges:
  • Finding name of DB2 table primary key

    Hello, Can I find the name / value of a DB2 table's primary key? I already tried SYSCAT but that didn't work. I'm using DB2 version 10. Thank you.

    ITKE970,245 pointsBadges:
  • DB2: Limitation on SQL statement characters

    On DB2, is there a limitation to how many 'characters' can be passed to my database? My friend told me that there was in older versions but I'm on the latest version so I wanted to confirm this. Thank you.

    ITKE970,245 pointsBadges:
  • 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.

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

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

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

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

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

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

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

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

    ITKE970,245 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!

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

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

    ITKE970,245 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