Hi all experts,
I have written the task to export the data to an ASCII file. I ran the SQL query using SQL developer tool, and there were no issues. I was also able to export it from the tool successfully.
However, when I tried to use the same query and export the data from Eclipse, it only exported a limited amount of data. Any ideas? The details are as follows:
SQL: SELECT * FROM MXI_VALUES WHERE MSKEY < 208100
Result: Please refer to Print Screen #1
I have created a new task for the "To ASCII File" export with the following settings: Please refer to Print Screen #2
The result of this attempt is the absence of ATTR_ID data. Please refer to Print Screen #3.
It has MSKEY but missing ATTR_ID.
Thank you.