Concat in Universe Stage

asnagaraj · Post by **asnagaraj** » Tue Mar 11, 2003 7:34 am

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.

chulett · Post by **chulett** » Tue Mar 11, 2003 8:14 am

Or (as we all know) you can just use two pipe symbols "||" to do the same thing in Oracle. [:D]

I have no idea how you do it in Universe, but here's a wild guess - have you tried using a colon?

-craig

asnagaraj · Post by **asnagaraj** » Tue Mar 11, 2003 8:33 am

yes i have tried but only errors [:(]

Programmer Analyst,
Cognizant,
Chennai.

chulett · Post by **chulett** » Tue Mar 11, 2003 12:53 pm

Actually, since the dual pipes are standard SQL and are not specific to Oracle, I tried them out in 'Universe' and... they work! Try that.

-craig

ray.wurlod · Post by **ray.wurlod** » Wed Mar 12, 2003 11:34 am

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