View previous topic :: View next topic
|
Author |
Message |
aravindunlimited
New User
Joined: 08 May 2006 Posts: 16
|
|
|
|
I am trying to unload a data using the BMC unload utility. The SQL in the DB2DATA card has a SELECT MAX(COLUMN_1). This worked fine when I ran it in a SPUFI. But it is giving me error when run through the BMC unload.
DB2DATA is
UNLOAD SHRLEVEL CHANGE DIRECT YES
SELECT
COL_ONE
,MAX(COL_TWO)
FROM SAMPLE_TABLE
GROUP BY COL_ONE;
Please note that this SQL worked when I tried it in SPUFI |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to post the diagnostic information that you see. We cannot do much if you do not provide the info. Also, please post the table definition.
When you post the info, someone here will probably be able to help. |
|
Back to top |
|
|
|