ODISQLUNLOAD syntax:
[-FETCH_SIZE=<array_fetch_size>] [CR/LF <sql_query> | -QUERY=<sql_query> | -QUERY_FILE=<sql_query_file> ]
Example:
Create one procedure and below code in Command on target
and select Source technology and logical schema on command on source.
OdiSqlUnload "-FILE=C:\temp\sessions.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=\r\n" "-DATE_FORMAT=yyyy/MM/dd HH:mm:ss" "-CHARSET_ENCODING=ISO8859_1" "-XML_CHARSET_ENCODING=UTF-8" "-FETCH_SIZE=5000" "-QUERY=Select sess_name,sess_beg,sess_status from dev1_odi_repo.snp_session"
This post first appeared on Oracle Data Integrator | ODI Online Training, please read the originial post: here
