Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Example of OdiSqlUnload


  [-FETCH_SIZE=<array_fetch_size>] [CR/LF <sql_query> | -QUERY=<sql_query> | -QUERY_FILE=<sql_query_file> ]


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

Share the post

Example of OdiSqlUnload


Subscribe to Oracle Data Integrator | Odi Online Training

Get updates delivered right to your inbox!

Thank you for your subscription