• 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)

    Messam260 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:
  • Error connecting to DB2 on iSeries

    Hello All, I'm getting below error while connecting db2 database on Linux which is cataloged to db2 on iSeries. Kindly help me out on this. db2 -r -u -p **** CLI ERROR ***** SQLSTATE: 58017 NATIVE ERROR CODE: -30073 Distributed Data Management (DDM) parameter value X'119C' not supported. Thanks in...

    umashankar2a120 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:
  • DB2 on iSeries V7R1

    Hello all, Can any one help on communicating db2 database on iSeries (V7R1) with DB2 v9.7 client on Red Hat linux ( RHEL6) ..? Thanks in advance. Regards, shankar

    umashankar2a120 pointsBadges:
  • DB2 on IBM iSeries AS/400

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

    kumarbabu5 pointsBadges:
  • Data schema for migrated data from Jbase to DB2

    How should the data schema looks like after converted it from jBASE to DB2?

    RobaNaji5 pointsBadges:
  • Is DBMS_OUTPUT.PUT_LINE works in DB2 tool such as DBvisualizer instead of only in db2Command Line Processor?

    I ant to print output of stored procedure using dbms_output.put_line. I am using DBvisualizer tool.

    rockstar185 pointsBadges:
  • New Embedded SQL to pull data from 1 DB to another is failing

    We just started using a TEST DB2 machine for the first time, for the past 20 years we've simply had test libraries on the Production DB2 box. Whenever I needed test data before, I just ran a CL I had created to copy *REPLACE the selected files. Our DB2 administrator is refusing to allow DDM to pull...

    MaryKyrrynMathias75 pointsBadges:
  • How to get data in DB2 based on index like (LIMIT 2,9) in SQL and other databases.

    In other databases we get data based on index using LIMIT. Example: SELECT * FROM ZEMPLOYEE LIMIT 2,9. I tried using native SQL it works fine if we give LIMIT 3, it will fetch the records from 1-3 but when I give LIMIT 2,9. Then it should fetch the data from 2nd record to 9th record but It through...

    arshadshaikh5 pointsBadges:
  • Problems with FTPing database views

    Hello. We currently have an FTP issue after upgrading to V7R2. We use views heavily and in a handful of them we use functions in the SELECT statement body of the view.  In V6R1M0 we can FTP the data from these views without problems.  In V7R2 it fails with code 426. It says file in library is not...

    erickfrancisco5 pointsBadges:
  • Restricting STRSQL

    Hi, we are using DBVisualizer to access DB2 in our AS/400. However, I want to create some user profile where they can't update/delete/insert in the tables but read only. How can we restrict the users use DBVisualizer for SELECT statement only? Thanks in advance. Vinod.

    MyDataTransfer20 pointsBadges:
  • Converting DB2 XML file in AS/400

    I am converting a DB2 XML file AS/400. I have no idea if you can give me please a detailed example with my DES015 file: No individual Long individual Name NAME NAME Sex code Birth date Birth-town Additional Info

    xylosis5 pointsBadges:
  • -927 in calling a batch COBOL program from CICS

    I'm getting a -927 in calling a batch COBOL program from CICS. What should I do?

    baruchbnb5 pointsBadges:
  • Calling COBOL program from native DB2 stored procedure

    Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

    Tanmay2115 pointsBadges:
  • SQL0666 SQL query exceeds specified time limit or storage limit

    I have a web service using a iDB2 connection to return a Data Set. I am searching a large table on a partial string to find a portion of a serial number, I kept getting this SQL0666 error so I had a new LF created over the file on the i-Series side by the text field I am searching on and it now...

    ToddN200042,930 pointsBadges:
  • Impact / estimate for DB2 database archiving

    What's the impact / estimate for DB2 database archiving?

    shuping15 pointsBadges:
  • Character conversion between CCSID 1208 to 850 requested by DSNXRST is not supported

    Hi, I am trying to create some native SQL procedures on DB2 Z/OS. I have connected to the Mainframe machine through IBM data studio. I can able to connect to the machine. When I m trying to compile the Stored procedure.I am getting the below error. Procedure: CREATE PROCEDURE PROCEDURE1 () RESULT...

    HABBIE895 pointsBadges:
  • How to offer a high availability database environment

    Can I configure VMware Fault Tolerance, or another VMware technology, to host an active DB2 database at one data center, and host a standby DB2 database at a second data center? Applications would access the primary DB when available, and then access the standby DB if the primary failed. The data...

    JimInTexas5 pointsBadges:
  • JAVA & “scrollable cursors”

    Am I able to use "scrollable cursors" from a JAVA AP? Thanks & regards Sepp Kraus

    garfield005 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following