Page 2 of 2

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

PostPosted: Thu May 30, 2013 9:54 pm
by dick scherrer
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. . . :)

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

PostPosted: Fri May 31, 2013 8:01 am
by rskmfguy
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