ODBC Connector Stage in 8.5

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
greggknight
Premium Member
Premium Member
Posts: 120
Joined: Thu Oct 28, 2004 4:24 pm

ODBC Connector Stage in 8.5

Post by greggknight »

So I am in the process of converting from the depreciated SQL server stages, OLDB to the ODBC Connector stage in 8.5.

My User defined SQL
SELECT 1 as BATCH_KEY, 1 as BUSINESS_DATE_KEY , FEES_CODE_KEY, 'D' as Record_Status_Code, GETDATE() as DW_DATE_MODIFIED
FROM #DW_LIB#.dbo.tDim_#TableName# a
WHERE (not exists (select 1 from #STAGE_LIB#.dbo.tStage_#TableName#
where ERP_Division_ID = a.ERP_Division_ID
and Division_ID = a.Division_ID
and Location_ID = a.Location_ID
and FEES_CODE_ID = a.FEES_CODE_ID))
and Record_Status_Code = 'A'

i get the message "Invalid Property Value Unexpected procedure reference found"
If I replace the GETDATE() function with CURRENT_TIMESTAMP it is fine.

If I try to view the data with the getdate() FUNCTION I can see the data and when I run the job everything is green.
Any Idea on how to clear this warning
"Don't let the bull between you and the fence"

Thanks
Gregg J Knight

"Never Never Never Quit"
Winston Churchill
greggknight
Premium Member
Premium Member
Posts: 120
Joined: Thu Oct 28, 2004 4:24 pm

Post by greggknight »

This is a Known bug which is fixed in fix pack 1
"Don't let the bull between you and the fence"

Thanks
Gregg J Knight

"Never Never Never Quit"
Winston Churchill
Post Reply