Oracle Adaptor NULL values in SELECT

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Oracle Adaptor NULL values in SELECT

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Oracle Adaptor NULL values in SELECT

Page: [1]

Message

<< Older Topic Newer Topic >>

Oracle Adaptor NULL values in SELECT - 14 March 2007

brupert

Posts: 35
Score: 0
Joined: 1 June 2006
Status: offline

Do you know of a way to make the value in a map NULL when using the BizTalk Utilities Oracle Adaptor for Database Transport? For example, I am mapping to a schema generated by the adaptor and I want to make one of the values in the where clause "WHERE transfer_end_time IS NULL". I've been able to use an inline C# script to map it as null, but it ends up coming out in the SQL in the transport as "WHERE transfer_end_time = null". Just to be clear here is the SQL code from the event log becomes:SELECT YEAR, MONTH, RECORD_COUNT, DATE_CREATED, TRANSFER_START_TIME, TRANSFER_END_TIME, USERID, UPDATE_DATE_TIME
FROM GMS.CARE_DP_FORECAST_CONS_LOG
WHERE YEAR = '2006' AND MONTH = '08' AND TRANSFER_END_TIME = null and here is the SQL I'm trying to get to.SELECT YEAR, MONTH, RECORD_COUNT, DATE_CREATED, TRANSFER_START_TIME, TRANSFER_END_TIME, USERID, UPDATE_DATE_TIME
FROM GMS.CARE_DP_FORECAST_CONS_LOG
WHERE YEAR = '2006' AND MONTH = '08' AND TRANSFER_END_TIME IS null Thanks,