• DB2 left outer join

    Left outer join is giving spaces between the values of 2 columns, how to get the output without any space in between, tried using '||' but getting error on CURRENT DATE field?

    shushank5 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:
  • JDBC driver for Linux connect to DB2/400

    Because SAP HANA runs in Linux, I want export data to DB2/400. Where can I download JDBC Driver?

    lance2221357270 pointsBadges:
  • IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm180 pointsBadges:
  • How DB2 converts the FLOAT value to IEEE floating-point format?

    I had created a SQL table as below: CREATE TABLE MYLIB/Mytable (FLD1 FLOAT (9) NOT NULL WITH DEFAULT) When I ran DSPFFD, I had seen that FLOAT(9) gets converted to 3F 2. So, I want to understand how does it happen? Which algorithm is being used?

    manojibmi5 pointsBadges:
  • List libraries and size used by DB2

    How do I list all the libraries used by DB2 in an AS/400 environment?

    gmorote15 pointsBadges:
  • AS/400 DB2 Sav file

    Can an AS/400 DB2 Sav file be restored or migrated to MS SQL Server or Oracle? If not, can non IBM program or script be used to parse data from a SAV file?

    jknight275 pointsBadges:
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • Interface DB2 to Oracle

    Dear all, I  have an 02 database (Oracle database 11 and DB2). I'm using inquiry command SQL in DB2 select about 2 million records very fast but interface to ORACLE by Database gateway transaction process very slow. Please give me reccommend or doccument. Thanks for help

    Hvphong031160 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • How to find the list of queries (WRKQRY) using a PF

    I want to list down all the Queries build using WRKQRY which are using a particular Physical File.

    asakla245 pointsBadges:
  • DB2: Decrease column length

    Can I decrease the column length in DB2? In one of my columns, it's currently defined as VARCHAR(80). I want to move it to VARCHAR(60). How can I do that?

    ITKE828,740 pointsBadges:
  • Identifying DB2 port number in Java

    My boss asked me to make a DB2 connection using a port number in Java. But I'm not sure what the port number is. Is there any DB2 command to identify it? Thanks.

    ITKE828,740 pointsBadges:
  • From DB2 in mainframe to distributed server

    How can I switch from a DB2 in mainframe to a distributed server?

    dbaadmin15 pointsBadges:
  • Connecting SPSS to AS/400 DB2

    Hi I need to connect SPSS to AS/400 DB2 in order to run queries and get data. I try to connect using iSeries Access ODBC Driver I receive the following error: "Database connection failed. The driver may not be configured properly." I tried to connect to AS/400 from ACCESS and from iSeries Navigator...

    felixb95 pointsBadges:
  • Mainframe Decomission

    Hi All, I am working on Mainframe decommission project. This application also having DB2 as database. I want to know the DB2 removal process. Like first I need to remove tables, table spaces than storage group. I want help on the same. How can I remove all db2 components any command or process....

    amittandon7865 pointsBadges:
  • DB2 on IBM iSeries AS/400

    How to upgrade the version of DB2 in iSeries AS/400?

    kumarbabu5 pointsBadges:
  • DB2 master address space architecture

    Why is the DB2 MSTR still with 31-bit mode? Why can't it exploit the 64-bit? Thanking you in advance.

    duamlee5 pointsBadges:
  • SQL in DB2 for AS/400

    What I have an error when I try to execute the following SQL statement: UPDATE kfilasm/SCPF exception JOIN KFILasm/LDPF ON SCAB = JUBBN and SCAN = JUBNO and SCAS = JUSFX set SCRBA = SCRBA - JUHAMT, SCRBB = SCRBB - JUHAMT WHERE SCAB||SCAN||SCAS IN (SELECT JUBBN||JUBNO||JUSFX FROM QTEMP/JUPF2)

    Messam280 pointsBadges:
  • Load Excel with Japanese characters to iSeries DB2 file

    How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

    tonycurtis135 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