• Create CL program Update in AS/400

    Dear All, I am learning to write CL program in AS/400 for DB2, maybe call new programmer. I have a file1 include ( field 1 ->10) to have value as: Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 112118 P I 1 A B C D E I want to create CL program update file 1 in AS/400 to...

    Hvphong0311100 pointsBadges:
  • Can you debug from a Lotus Notes client using LotusScript connecting to DB2 on an iSeries

    I'm at a client that has Domino 9.0 running on an iSeries. I tried to debug a LotusScript agent with a lcsession connection to DB2 to no avail. I was told you can't do that. And I'd have to schedule the agent and write to an agent log to debug. Is there another option?

    westmo5 pointsBadges:
  • Trigger program lock.

    When a trigger program is locked because the physical file is locked, how can we promote a program through MKS when it is locked. We have over 40 warehouses with a copy of the same file so getting everyone out of the individual files would be a chore. Can we use a CL for the trigger program or is...

    UARTJ170 pointsBadges:
  • Display physical file using subfiles in AS/400

    How to display a physical file record using subfiles?

    sampathrsk15 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?

    Gayathri123925 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?

    rajat01170 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,067,595 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,067,595 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,067,595 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,067,595 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,067,595 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,067,595 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,067,595 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,067,595 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,067,595 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