Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield >
$(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in
idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com <mailto:Rohan.GPatil@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
|