Hello everyone,
I have started a discussion in one of my last discussions I have already opened, but I think it is better to open in public where everyone can share.
I was asking about carriage return in Varaibles to resolve a problem and Pavan8u have suggested for me to use OdiSqlUnload using ODI Procedure. I have started but I am facing errors . I will explain first how I define it .
1- Create a Procedure in a Package .
2. Create Task in this package .
3. in Source I just copy this Cide :
OdiSqlUnload "-FILE=C:\NRT_CWH_FILES\cc.csv" "-DRIVER=<%=odiRef.getInfo("SRC_JAVA_DRIVER")%>"
"-URL=<%=odiRef.getInfo("SRC_JAVA_URL")%>" "-USER=<%=odiRef.getInfo("SRC_USER_NAME")%>"
"-PASS=<%=odiRef.getInfo("SRC_ENCODED_PASS")%>" "-FILE_FORMAT=VARIABLE" "-FIELD_SEP=" "-ROW_SEP="
"-DATE_FORMAT=yyyy/MM/dd HH:mm:ss" "-CHARSET_ENCODING=ISO8859_1" "-XML_CHARSET_ENCODING=ISO-8859-1" “-FETCH_SIZE=5000”
and defined Technology : OdiTool
4- in Target I just copy my SQL:
select *
from NRT.Data_to_be_spool
where file_name='#NRT_DH.File_Type_Name'
and spool_status ='NOTDONE'
and FILE_FLAG= #NRT_DH.FILE_FLAG
order by CREATION_DATE DESC
) "
Technology : Oracle
Error :
ODI-1281: Source Technology ODI Tools of task ODIsqlunload is not of JDBC Type. When both Source and Target commands are specified, the Source Technology should be of JDBC type.
First , is what I did correct ? What are the mistakes I have done. Where as first time I use CODE and SQL in Target and define Technology :Odi Tools. but I got errors
Your help is highly appreciated .
br,
Mohammed