MVSFORUMS.com

[meghna]

Hi,

I want to unload only 1 column from a table.
I am trying to use D2IBMCUP.
I give the query in a file.

The query is :
UNLOAD SHRLEVEL CHANGE
SELECT Col1
FROM Tab1
(This runs fine)

But I want only unique values , so I tried using this query:
UNLOAD SHRLEVEL CHANGE
SELECT DISTINCT Col1
FROM Tab1
For this it abends.
It abends and in my joblog I see:
BMC50102I UNLOAD SHRLEVEL CHANGE
BMC50102I SELECT DISTINCT SE_NO
@
BMC50104E UNEXPECTED TOKEN 'SE_NO' ENCOUNTERED IN COMMAND
BMC50013I UTILITY EXECUTION TERMINATING, RETURN CODE = 8

Can any one of you assist?

Thanks!

[kolusu]

meghna,

Is column SE_NO in the table you are trying to unload? check if it is misspelled.

Kolusu

[meghna]

Kolusu

I have checked the column spelling. It is correct.