DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
FranklinE



Group memberships:
Premium Members

Joined: 25 Nov 2008
Posts: 687
Location: Malvern, PA
Points: 6500

Post Posted: Tue Jul 31, 2018 12:11 pm Reply with quote    Back to top    

Late to this thread, not sure if this will help, but we successfully use the following in an ODBC Connector stage to select from MSSql:

Code:
CALLS.local_start_time >= {ts '#CALL_START_DATE_1# 00:00:00.000'}  AND
CALLS.local_end_time<= {ts '#CALL_END_DATE_1# 23:59:59.000'}


Single quotes around the parameters is, as I recall, the first requirement. After that, you have to balance the text parsing that DS does at runtime with the syntax requirements of your DBMS.

_________________
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: http://www.dsxchange.com/viewtopic.php?t=143596 Using CFF FAQ: http://www.dsxchange.com/viewtopic.php?t=157872
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours