Skip to Content
0
Former Member
Jun 24, 2009 at 07:41 AM

JDBC Receiver

83 Views

Hey,

In XI 3.0 doe's xi jdbc receiver uses bind variables ?

because i have a case where it sends like this:

INSERT INTO MTN_MEDATV_48_AVCHANOT (MEDATV_48_CLAIM_ITEM_ID, MIS_SIDURI, KOD_AVCHANA, TAR_AVCHANA, SIVUG_AVCHANA, BATCH_ID, KOD_MAARECHET, SHEM_AVCHANA_HEB, SHEM_AVCHANA_ENG, TEUR_AVCHANA) VALUES (000428684, 002, '1-471', '23-Jun-2009', '01', 366395, 'ESBPM', 'Biopsy of endometrium (SG)', 'Biopsy of endometrium (SG)', '333')

is there a way to control this, so it will send it in bind variables ?

like this:

INSERT INTO STUDENTS

VALUES (:STUDENT-FIRST-NAME,:STUDENT-FAMILY-NAME);

TX

Edited by: Zevik Heinoch on Jun 24, 2009 10:38 AM