Can any one help me how to specify specific path in odisqlunload tools which is useful for both windows and linux.
I am developing and testing in windows and moving generated scenario into linux box to test for testing people
If in case any error out records are populated in E$ table then how that records will populated on xls file, later I am sending that attachement for email notification to concern people
Now in odisqlUnload you can use this as follows
OdiSqlUnload "-FILE=<%=snpRef.getOption("UNLOAD_DIR")%>\<%=snpRef.getSession("SESS_NO")%>.xlsx" "-DRIVER=<%=odiRef.getInfo("DEST_JAVA_DRIVER")%>" "-URL=<%=odiRef.getInfo("DEST_JAVA_URL")%>" "-USER=<%=odiRef.getInfo("DEST_USER_NAME")%>" "-PASS=<%=odiRef.getInfo("DEST_ENCODED_PASS")%>" "-FILE_FORMAT=VARIABLE" "-ROW_SEP=\r\n" "-DATE_FORMAT=yyyy/MM/dd HH:mm:ss" "-CHARSET_ENCODING=ISO8859_1" "-XML_CHARSET_ENCODING=ISO-8859-1"
select * from <@=error_tab_name@>
1st issue: For path name based on linux
If you can get the OS details using java then you can store the path into a java variable accordingly. For example
then v_path="D:\unload_dir ";
else if os==linux
then then v_path="/home/phaniknath/file_dir";
Note: This is not the exact code. Just a logic to be implemented.
I will update you as soon as i can.
If you are excuting the odiSqlUnload command using procedure with oditools technology then use
in the password field. In command on source select the technology as oracle and the logical schema containing the E$ table.
Its not specific to only source that you are using in interface. Its specific to the logical schema data you have selected in the command on source of a procedure.
So if you select the target logical schema it will get target dataserver encoded password. If you have both source and target under one user then you can selected any logical schema.
Its just a direction to get the encoded password which will be helpful to login to the user and get the details from the table. .
As you have to use the E$ table, go for the logical schema that points to staging ( having these temp tables ).