Forum Stats

  • 3,780,918 Users
  • 2,254,456 Discussions
  • 7,879,492 Comments

Discussions

Files_issue for SQL_Unload from ODI

ksangadi
ksangadi Member Posts: 30 Green Ribbon
edited Nov 29, 2021 5:36PM in Data Integrator

Hi Folks,

I have a issue when i generated the CSV from through SQL Unload.

The issue was data in the file got shrink as highlited in the file

ODISQL Unload query OdiSqlUnload "-FILE=#WC_SALES_REPORT_FILE_PATH/#WC_SALES_REPORT_FILENAME" "-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=ISO-8859-1" "-QUERY_FILE=#WC_SALES_REPORT_WRK_DIR/SQL/query.sql"


Is there any possible way to change the CSV file column width while generating from the ODI using the ODISQLUNLOAD tool.

Thanks in Advance.



Regards

Kamesh S

Best Answers

Answers