Ray Justus
Reputable Poster
Bojan,
The JDE way is to use the cursor approach (Select, Fetch Next) but my SQL instructor says virtually all cursors can be replaced using Joins. I haven't had a chance to prove or disprove his statement yet but I'm going try it out the next time I write a UBE that doesn't need the detail. It may be worth your time to experiment with business views.
Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4679
(602) 631-6157
mailto: [email protected]
Hi List,
Is there any way in JDE to retrieve sum for some field without of fetching records (like "SELECT SUM (FieldName) FROM (TableName) WHERE*")? I*d like to avoid network traffic with:
TableName.Select
TableName.FetchNext
While SV File_IO_Status is equal to CO SUCCESS
TableName.Fetch Next
End While
and fetch the result only.
Thanks in advanced.
Bojan.
B733.2, SP 10, NT 4.0, SQL 7.0.
The JDE way is to use the cursor approach (Select, Fetch Next) but my SQL instructor says virtually all cursors can be replaced using Joins. I haven't had a chance to prove or disprove his statement yet but I'm going try it out the next time I write a UBE that doesn't need the detail. It may be worth your time to experiment with business views.
Ray W. Justus
Kitchell Corporation
1707 East Highland Avenue, Suite 100
Phoenix, AZ 85016-4679
(602) 631-6157
mailto: [email protected]
Hi List,
Is there any way in JDE to retrieve sum for some field without of fetching records (like "SELECT SUM (FieldName) FROM (TableName) WHERE*")? I*d like to avoid network traffic with:
TableName.Select
TableName.FetchNext
While SV File_IO_Status is equal to CO SUCCESS
TableName.Fetch Next
End While
and fetch the result only.
Thanks in advanced.
Bojan.
B733.2, SP 10, NT 4.0, SQL 7.0.