Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
SREG in SQL Listener
 Login/Join
 
Member
posted
Hello,
I'm trying to setup a SQL listener that checks for new orders that need to be processed. I am trying to use a special register to filter out orders running in different iWay configurations, say Dev for testing or Production for the real deal.

The SQL Query looks like this:
SELECT * FROM [INET].[dbo].[ELineTrafficCopNewOrders] WHERE iWayConfig = 'SREG(current_config)'

It isn't pulling any records, because according to the activity log the query is literally placing the text SREG(current_config) inside quotes.

How do I use a special register in this query? I have used SREG(variable_name) in FILE listeners just fine, I'm not sure what I'm doing wrong here. Any help is appreciated!
 
Posts: 4 | Location: Dayton, OH area | Registered: October 24, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.