Combine two rows



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Combine two rows

Postby MemoPerez » Sat Nov 19, 2022 1:43 am

Hello everyone, I'm extremely new at this, my knowledge in Easytrieve is close to 0. However, I'm trying to learn, and part of the assignment is to transform a report from this:


--------------------------------------------------------------------------
 OPER-NAME/                                                              
 OPER-ID   LOC   DB AUTH    TC   DUAL VERIFY   OP     DATE/TIME ADDED    
                           AUTH     LEVEL      TYP    DATE/TIME LAST MAINT
 -------------------------------------------------------------------------
 FUDD, ELMER                                                              
 A1B6374         01         02        N               09/23/2022 14:08:13
                                                      09/23/2022 14:08:13
 BUNNY, BUGS                                                              
 A1B8924         01         02        N               09/23/2022 14:09:00
                                                      09/23/2022 14:09:00
 TRUMP, DONALD                                                            
 A1B9847         01         02        N               05/11/2021 15:36:03
                                                      05/11/2021 15:36:03
 


to this:


---------------------------------------------------------------------------------------------------------------
 OPER-NAME      OPER-ID   LOC   DB AUTH    TC   DUAL VERIFY  OP      DATE/TIME ADDED      DATE/TIME LAST MAINT
                                          AUTH     LEVEL     TYP
 --------------------------------------------------------------------------------------------------------------
 FUDD, ELMER    A1B6374         01         02        N               09/23/2022 14:08:13  09/23/2022 14:08:13
 BUNNY, BUGS    A1B8924         01         02        N               09/23/2022 14:09:00  09/23/2022 14:09:00
 TRUMP, DONALD  A1B9847         01         02        N               05/11/2021 15:36:03  05/11/2021 15:36:03
 


My question here is, how can I 'combine' two rows into one using Easytrieve?

Thank you.

- Guillermo Pérez
MemoPerez
 
Posts: 1
Joined: Sat Nov 19, 2022 1:27 am
Has thanked: 0 time
Been thanked: 0 time

Re: Combine two rows

Postby sergeyken » Wed Nov 23, 2022 11:34 pm

First of all, please demonstrate: how did you get the first example?
Javas and Pythons come and go, but JCL and SORT stay forever.
User avatar
sergeyken
 
Posts: 331
Joined: Wed Jul 24, 2019 10:12 pm
Has thanked: 5 times
Been thanked: 30 times


Return to CA-Easytrieve