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

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

    ToddN200031,105 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:
  • ENCRYPT_AES return CCSID error

    Claude15 pointsBadges:
  • iSeries-AS/400 SQL

    I have a table in a test environment and need to update the same name table up in a production environment. This would be any table and here are things we won't know. We do not know if there is a key, field names, or what was changed. It could be any file. so this has to work for any table. I used...

    Pgmr46105 pointsBadges:
  • Performance optimization in DB2

    I have COBOL code running using DB2 files. I need to reduce run time for code. What all steps should I follow to achieve this? I did "Search all" for "Perform" in COBOL, for example.

    prdevghare25 pointsBadges:
  • SQL join for two files with identical field names

    When joining 2 files that have identical field names, what does the syntax need in order to handle this? I know the old IBM Query uses a file prefix. On AS/400 platform (DB2)

    aceofdelts2,190 pointsBadges:
  • SQL statement that retrieves the latest year record for customers

    Need to know this! I have a table that consist of a custom ID, year and amount column. Customers can have one row per year in that table with an amount. I want to do an SQL statement that retrieves the latest year (i.e 2015) record for each Customers. I'm not interested in records before year 2015!...

    hakaxh5 pointsBadges:
  • Transpose columns to rows and rows to columns in Oracle

    I have a table in the below format A B C D D 1 2 3 E 4 5 6 F 7 8 9 And I would want in the below form: A D E F B 1 4 7 C 2 5 8 D 3 6 9 I tried unpivoting and pivoting and doesn't seem to work much Please help!

    akalya5 pointsBadges:
  • DB2 crash on production Red Hat VM server

    We had a Red Hat virtual machine (VMware vSphere) that is hosting the database for our application the application runs normaling at some point it crashes with the error below seen on db2diag: ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied" DIA8701C Access denied for resource "", operating...

    hamzahir85 pointsBadges:

    How do I FETCH 1 ROW from a table inside a subselect? I am getting the error: [SQL0199] Keyword FETCH not expected. Valid tokens: ) UNION EXCEPT. Here is the subselect query: (SELECT EcoResProductTranslation_Name FROM RJERN.DMFPRODUCTENTITY INNER JOIN KBM400MFG.FKPSTRUC on...

    leogal5 pointsBadges:
  • DB2 Cobol stored procedure example

    DB2 Cobol stored procedure example FETCH  sql =-504

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