hi,
the need is to use an UV stage to write a select clause that does a join of 5+ hash files and it also does a concatenation of some of the input fields when providing the output.
as we all know oracle has a function called concat to get the purpose solved.but what is that i can do in UV for solving the same.
Help me.
Programmer Analyst,
Cognizant,
Chennai.
Concat in Universe Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's correct; UniVerse complies with ? level of ODBC 2.0 SQL grammar, so it has "regular" SQL functions like SUBSTRING and TRIM (which are different from the corresponding UniVerse BASIC functions of similar name). And, since || is defined as the concatenation operator in the ODBC 2.0 SQL Grammar, that's the one to use.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518