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

    Pgmr4680 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,150 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)...

    chowas400615 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:
1

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