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

    ToddN200045,650 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,330 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:
  • FETCH 1 ROW IN A SUBSELECT

    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:
  • DB2/400-AS/400

    File:Student ................. SID     . Sname . ................. 1       .  Chow . 2       .  Ratna. ................. I want to update sname= Rotna(2nd position a=o) using substring? Please help the query or correct the below query: UPDATE STUDENT SET SNAME=SUBSTR(SNAME, 2,1)...

    chowas400620 pointsBadges:
  • DB2 to SQL conversion

    How to I convert DB2 to SQL?

    cgardel015 pointsBadges:
  • Can anyone give me HP-UX commands related to SAP and DB2

    Hi, I'm new to HP-UX so please give me the list of HP-UX commands related to SAP and DB2 database. Thank you, navakanth

    Navakanth5 pointsBadges:
  • DB2/400 database on Windows

    Hi, DB2 c express database can be installed on any Windows, Linux etc. We can develop using DB2 c express. My question is I need to develop procedures & functions only on DB2/400 database alone. Can someone tell me where can I get DB2/400 database which can be installed on Windows as similar as...

    HABBIE895 pointsBadges:
  • LISTAGG Function in AS/400 DB2

    Does AS/400 DB2 support LISTAGG Function? If not, then what is the equivalent function for AS/400 DB2?

    KeSudhakar10 pointsBadges:
  • How to join two or more rows from single table and put them in one column in DB2 (AS/400 Platform)

    How to join two or more rows from single table and put them in one column in DB2 (AS/400 Platform) TABLE Name : EDITBL COLUMN 1   : EDIVND COLUMN 2   : EDITYP Data: Vendor Number  EDI Type 1019      810I 1028      852O 1535      FAXO 1546      FAXO 1612      FAXO...

    KeSudhakar10 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