Skip to Content
0
Aug 09, 2023 at 10:58 AM

missing data after ASCII export

197 Views Last edit Aug 08, 2023 at 02:14 PM 2 rev

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

printscreen1.jpg

I have created a new task for the "To ASCII File" export with the following settings: Please refer to Print Screen #2

printscreen2.jpg

The result of this attempt is the absence of ATTR_ID data. Please refer to Print Screen #3.

printscreen3.jpg

It has MSKEY but missing ATTR_ID.

Thank you.

Attachments

printscreen1.jpg (44.7 kB)
printscreen2.jpg (47.7 kB)
printscreen3.jpg (58.2 kB)