How to find -811 entry in Easytrieve DB2 program?



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

Re: How to find -811 entry in Easytrieve DB2 program?

Postby dick scherrer » Thu May 30, 2013 9:54 pm

Hello,

The following runs with no problem:
JOB INPUT SQL                                                       
SELECT ACONTROL_NBR, FIRST_NAME, LAST_NAME, SSN, TS_ROW_CREATED, + 
       TS_LAST_UPDATED, LAST_PROGRAM                             + 
   FROM MSTR.REQUESTS                                            + 
   INTO :W-ACONTROL-NBR,                                         + 
        :W-FIRST-NAME,                                           + 
        :W-LAST-NAME,                                            + 
        :W-SSN,                                                  + 
        :W-CREATE-DATE,                                          + 
        :W-LAST-UPDATED,                                         + 
        :W-LAST-PROGRAM       


At least it was promoted a while back. . . :)
Hope this helps,
d.sch.

These users thanked the author dick scherrer for the post:
rskmfguy (Fri May 31, 2013 8:04 am)
User avatar
dick scherrer
Global moderator
 
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to find -811 entry in Easytrieve DB2 program?

Postby rskmfguy » Fri May 31, 2013 8:01 am

Hi NicC,

Sorry my workstation pc is secured and so I couldn't copy paste the code. I will keep in my mind about code tags and will use it going forward. Sorry for the inconvenience caused.

Hi All,

I'm still working to fix this problem. If I get to find the solution then will post it here.

Any help with this request is greatly appreciated.

Regards,
rskmfguy
rskmfguy
 
Posts: 10
Joined: Mon Oct 22, 2012 11:07 pm
Has thanked: 8 times
Been thanked: 0 time

Previous

Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post