syntax problem??

From: Martin Meadows <mmeadows_at_indy.net>
Date: Sun, 19 Apr 1998 20:10:13 -0500
Message-ID: <353AA075.4DE6@indy.net>

Hi.

I'm trying to execute an insert command from some cobol source and I'm having no luck at all.  

The source looks like this:

   EXEC SQL

     INSERT INTO PAYROLL_TRANSACTION_DETAIL 
       (ptd_emp_#, ptd_date, ptd_acct, ptd_log_date, ptd_log_user,
ptd_pco_#)
       VALUES (111,'19-apr-98','111','19-apr-98','Meadows',111) 

   END-EXEC. After I execute the above statement I check the sqlca structure to see if it
worked. SQLCODE comes back with a value less than 0 & here's what's in SQLERRMC: ORA-00917: missing comma

So what's it trying to tell me??? Looks to me like all the commas are there.

Thanks in advance for any advice & assistance you can provide.

Martin Meadows Received on Sun Apr 19 1998 - 20:10:13 CDT