On Thu, Jul 16, 2015 at 10:23 AM, Charles Mills <[email protected]> wrote: > Thanks everyone for your help on the first diagnostic. How about the second > one? > > Charles <deleted> > 4408 1 ' FROM PSRECTBLSPC' > 4409 1 ' WHERE DBTYPE IN (' ','1 ')' > 4409==> IGYPS0001-W A blank was missing before character "1" in column 48. > To get a single quote within a single quoted string, use two single quotes. 'IN ('' '',''1 '')'
-- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
