K
Karen
I am trying to run this pass-through insert query but
everytime I try I keep getting ODBC connection Failed and
then when I click OK I get an Oracle error "Keyword
VALUES missing"
Here is the query
INSERT INTO PSTRN.Sysadm.PS_KM_Health_Quest (National_ID,
DATETESTED, PROFCODE, HEAD508, PRINTER, N001, DATESCANNED,
FORMCODE, MR_STUFF, FORMNO, FORMNAME, SIGNATURE, X001,
X002, X003, X004, X005, X006, X007, X008, X009, X010,
X011, X012, X013, X014, X015, X016, X017, X018, X019,
X020, X021, X022, X023, X024, X025, X026, X027, X028,
X029, X030, X031, X032, X033, X034, X035, X036, X037,
X038, X039, X040, X041, X042, X043, X044, X045, X046,
X047, X048, X049, X050, X051, X052, X053, X054, X055,
X056, X057, X058, X059, X060, X061, X062, X063, X064,
X065, X066, X067, X068, X069, X070, X071, X072, X073,
X074, X075, X075, X076, X077, X078, X079, X080, X081,
X082, X083, X084, X085, X086, X087, X088, X089, X090,
X091, X092, X093, X094, X095, X096, X097, X098, X099,
X100, X101, X102, X103, X104, X105, X106, X107, X108,
X109, X110, X111, X112, X113, X114, X115, X116, X117,
X118, X119, X120, X121, X122, X123, X124, X125, X126,
X127, X128, X129, X130, X131, X132, X133, X134, X135,
X136, X137, X138, X139, X140, X141, X142, X143, X144,
X145, X146, X147, X148, X149, X150, X151, X152, X153,
X154, X155, X156, X157, X158, X159, X160, X161, X162,
X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS_200)
Select SSNO,DATETESTED, PROFCODE, HEAD508, PRINTER, N001,
DATESCANNED, FORMCODE, STUFF, FORMNO, FORMNAME, SIGNATURE,
X001, X002, X003, X004, X005, X006, X007, X008, X009,
X010, X011, X012, X013, X014, X015, X016, X017, X018,
X019, X020, X021, X022, X023, X024, X025, X026, X027,
X028, X029, X030, X031, X032, X033, X034, X035, X036,
X037, X038, X039, X040, X041, X042, X043, X044, X045,
X046, X047, X048, X049, X050, X051, X052, X053, X054,
X055, X056, X057, X058, X059, X060, X061, X062, X063,
X064, X065, X066, X067, X068, X069, X070, X071, X072,
X073, X074, X075, X075, X076, X077, X078, X079, X080,
X081, X082, X083, X084, X085, X086, X087, X088, X089,
X090, X091, X092, X093, X094, X095, X096, X097, X098,
X099, X100, X101, X102, X103, X104, X105, X106, X107,
X108, X109, X110, X111, X112, X113, X114, X115, X116,
X117, X118, X119, X120, X121, X122, X123, X124, X125,
X126, X127, X128, X129, X130, X131, X132, X133, X134,
X135, X136, X137, X138, X139, X140, X141, X142, X143,
X144, X145, X146, X147, X148, X149, X150, X151, X152,
X153, X154, X155, X156, X157, X158, X159, X160, X161,
X162, X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS
FROM [Health Questions]
Any ideas?
Thanks.
everytime I try I keep getting ODBC connection Failed and
then when I click OK I get an Oracle error "Keyword
VALUES missing"
Here is the query
INSERT INTO PSTRN.Sysadm.PS_KM_Health_Quest (National_ID,
DATETESTED, PROFCODE, HEAD508, PRINTER, N001, DATESCANNED,
FORMCODE, MR_STUFF, FORMNO, FORMNAME, SIGNATURE, X001,
X002, X003, X004, X005, X006, X007, X008, X009, X010,
X011, X012, X013, X014, X015, X016, X017, X018, X019,
X020, X021, X022, X023, X024, X025, X026, X027, X028,
X029, X030, X031, X032, X033, X034, X035, X036, X037,
X038, X039, X040, X041, X042, X043, X044, X045, X046,
X047, X048, X049, X050, X051, X052, X053, X054, X055,
X056, X057, X058, X059, X060, X061, X062, X063, X064,
X065, X066, X067, X068, X069, X070, X071, X072, X073,
X074, X075, X075, X076, X077, X078, X079, X080, X081,
X082, X083, X084, X085, X086, X087, X088, X089, X090,
X091, X092, X093, X094, X095, X096, X097, X098, X099,
X100, X101, X102, X103, X104, X105, X106, X107, X108,
X109, X110, X111, X112, X113, X114, X115, X116, X117,
X118, X119, X120, X121, X122, X123, X124, X125, X126,
X127, X128, X129, X130, X131, X132, X133, X134, X135,
X136, X137, X138, X139, X140, X141, X142, X143, X144,
X145, X146, X147, X148, X149, X150, X151, X152, X153,
X154, X155, X156, X157, X158, X159, X160, X161, X162,
X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS_200)
Select SSNO,DATETESTED, PROFCODE, HEAD508, PRINTER, N001,
DATESCANNED, FORMCODE, STUFF, FORMNO, FORMNAME, SIGNATURE,
X001, X002, X003, X004, X005, X006, X007, X008, X009,
X010, X011, X012, X013, X014, X015, X016, X017, X018,
X019, X020, X021, X022, X023, X024, X025, X026, X027,
X028, X029, X030, X031, X032, X033, X034, X035, X036,
X037, X038, X039, X040, X041, X042, X043, X044, X045,
X046, X047, X048, X049, X050, X051, X052, X053, X054,
X055, X056, X057, X058, X059, X060, X061, X062, X063,
X064, X065, X066, X067, X068, X069, X070, X071, X072,
X073, X074, X075, X075, X076, X077, X078, X079, X080,
X081, X082, X083, X084, X085, X086, X087, X088, X089,
X090, X091, X092, X093, X094, X095, X096, X097, X098,
X099, X100, X101, X102, X103, X104, X105, X106, X107,
X108, X109, X110, X111, X112, X113, X114, X115, X116,
X117, X118, X119, X120, X121, X122, X123, X124, X125,
X126, X127, X128, X129, X130, X131, X132, X133, X134,
X135, X136, X137, X138, X139, X140, X141, X142, X143,
X144, X145, X146, X147, X148, X149, X150, X151, X152,
X153, X154, X155, X156, X157, X158, X159, X160, X161,
X162, X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS
FROM [Health Questions]
Any ideas?
Thanks.