• Display physical file using subfiles in AS/400

    How to display a physical file record using subfiles?

    sampathrsk5 pointsBadges:
  • Migrate from DMS2 database to DB/400

    Hi team, Is it possible to migrate from DMS2 database (unisys database) to DB/400? If so, what are the migration steps? If not , is it possible to migrate the DMS2 to DB2 on Linux or Unix?

    Gayathri123625 pointsBadges:
  • Assimilate AS/400 file into SYNON

    How to I assimilate AS/400 DB2 file into SYNON? Please provide step by step instruction.

    synonuser20175 pointsBadges:
  • On a AS/400, what is a database?

    What all consist a database? And how does it differ from an environment at AS/400?

    rajat01130 pointsBadges:
  • IBM.Data.DB2

    Could anyone please tell me what is the difference between IBM.data.db2 and IBM.Data.DB2.iSeries. In my understanding .iSeries is specific to Windows and iSeries DB2 whereas IBM.Data.DB2 is for other series of DB2 as well. In other words IBM.Data.DB2.iSeries is a subset of IBM.Data.DB2. Is my...

    smrksrpqr5 pointsBadges:
  • Copy TXT to DB2

    I have a text file that has special characters such as ! ' and the do not translate correctly to the DB2 table/ File. I am using the CPYFRMIMPF as follows: CPYFRMIMPF + FROMSTMF('/qntc/fp2554/Temp$/MISJSE/0000000+ 436_MISJSE.txt') TOFILE(QTEMP/REPORT165P) + MBROPT(*REPLACE) RCDDLM(*CRLF) +...

    Jengel15725 pointsBadges:
  • Pull record of duplicate key in DB2 table

    I want to pull the first record of a duplicate key in a DB2 table

    mh140315 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transferred from Excel to AS/400 displays garbage. Is there an add-in I need to install? Kindly help me in this how to transfer the data file from Excel (.xls) to AS/400 DB2.

    AnwarHabib25 pointsBadges:
  • 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.

    ITKE1,050,865 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.

    ITKE1,050,865 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...

    ITKE1,050,865 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?

    ITKE1,050,865 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.

    ITKE1,050,865 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.

    ITKE1,050,865 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.

    ITKE1,050,865 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.

    ITKE1,050,865 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,050,865 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,050,865 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,050,865 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,050,865 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