• 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