uvsh append

Sunshine2323 · Post by **Sunshine2323** » Thu Aug 04, 2005 4:32 am

Hi All,

I want to append "," at the end of each of the job names outputed by the command below.

$ $DSHOME/bin/uv "Select NAME from DS_JOBS";

Thank You,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 04, 2005 4:45 am

Pipe it through an unix sed command which can do that.

Sunshine2323 · Post by **Sunshine2323** » Thu Aug 04, 2005 4:49 am

Hi Sainath,

Can you please elaborate?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 04, 2005 4:49 am

<command> | sed 's/$/,/'

Sunshine2323 · Post by **Sunshine2323** » Thu Aug 04, 2005 5:05 am

Hi,

What is the syntax to append to a column using the uv SQL, like we can do for other databases using sql?

Thanks,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 04, 2005 7:20 am

Use ||

ray.wurlod · Post by **ray.wurlod** » Thu Aug 04, 2005 4:19 pm

Code: Select all

SELECT NAME || ',' FROM DS_JOBS;

or

Code: Select all

SELECT NAME || ',' AS NAME_WITH_COMMA FROM DS_JOBS;

(the alias becomes a virtual column name).