Push CAST function on Sybase

Push CAST function on Sybase

book

Article ID: KB0079931

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.7,

Description

How to push down CAST function to Sybase.

Issue/Introduction

Push CAST function on Sybase

Environment

Any

Resolution

Add this capability on <TDV install directory>\apps\dlm\cis_ds_sybase\conf\sybase-0700.capabilities

1) Add below capability on latest  base capability file<TDV install directory>\apps\dlm\cis_ds_sybase\conf\sybase-0700.capabilities

<<<<<<<<<<<<<  CAST(@timestampAS~date): CONVERT(DATETIME, $1)  >>>>>>>>>>>>

2) Restart TDV server.

Powered by Wolken Software