Hi,
Ibm trying to get a unique list from a delimited field into an XML
document. If I use a SQL bDISTINCTb select it aborts half way through.
In ReVise it bwouldb be SORT FILE BY COL1 BREAK.ON COL1 COL2 COL3 COL4
DET.SUP ID.SUP except that I canbt use a TOXML clause with this statement.
In
> Is this a limitation on I-types in SQL selects?
It would seem so based on your report. What does support have to say?
> Has anyone come across this problem before and is there a work around?
I haven't, but I haven't tried large orderded SELECTs on four I-types.
> Alternatively, can someone su
>>Is this a limitation on I-types in SQL selects?
>It would seem so based on your report. What does support have to say?
Seems like... VAR support is next port o' call.
>> Has anyone come across this problem before and is there a work
around?
>I haven't, but I haven't
Stuart,
UniVerse SQL "SELECT DISTINCT" and RetrieVe "SELECT ... SAVING UNIQUE ..."
(which are semantically identical queries) need the UniVerse parameter
"ALLOWMARKS"=1 to work with medium-large queries. This parameter is set by
default = 0.
There is an enhancement request at IBM for documenting t
Many thanks.
Cheers,
Stuart
__
UniVerse SQL "SELECT DISTINCT" and RetrieVe "SELECT ... SAVING UNIQUE
..."
(which are semantically identical queries) need the UniVerse parameter
"ALLOWMARKS"=1 to work