View Full Version : "Column not found in specified tables"
07-28-2004, 06:23 AM
Change the length of &STATE to 4 and place apostrophes in the 1st and 4th bytes. This will tell QM you mean a literal value of CA, and not a column named CA.
07-28-2004, 06:34 AM
Thanks for the tip Mark, that part worked. Now I get this error, "Select or omit error on field *N..". 6 - A data mapping error occurred on the field before the select or omit operation was attempted. Select/omit error on member CIPOMF08 Value in date, time, or timestamp string not valid Report display failed. RUN QUERY command failed with SQLCODE -181 I ran the sql statement interactively to see if there were any bad data (dates) but there were none.
07-28-2004, 07:58 AM
I think it may help to replace the DIGITS() function to a DATE(), again like Mark said including quotes in the first and last positions of your parameter dates. Assuming that PMTEFFDTE are of data type DATE, it should work.
07-28-2004, 08:04 AM
I'm passing 3 parms from a CL program to a qmqry. When the qmqry is run, I get this error: "Column CA not in specified tables. RUN QUERY command failed with SQLCODE -206." 'CA' is the value of the third parm that I passed through my CL pgm. What gives?? Thanks in advance for the help! Rene <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6aed1d95')
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.