Hi,

I need to write a User Defined Function to separate every three digits of a number with a comma from the right hand side..

Eg: i will pass a number 1234567890 as a parameter to the function.

and i need the result as 1,234,567,890 .

Please help me..


Thanks ,
Raj!!

Hi Harry, You can change the path of exception and rejected data files while writing copy command. I followed this way. I created two folders named 'EXC_FILES' and 'REJ_FILES' in dbadmin. And while loading data using copy command, i mention these files path at EXCEPTIONS and REJECTED DATA. Thank you...

Hi Daniel,

Thats perfectly meeting my requirement.

Thanks a lot,
Raj!

Hi, Do we have the facility of searching a string as follows. Eg: i want to retrieve the names of the members whose name begins with 'A' or 'B' or 'C' For this i write the query as follows in sql. select * from MEMBERS where NAME LIKE '[A-C]%' Do we have the above facility in vertica too??? Thanks, ...

Hi,

How to connect to Admintools through Command line?

i have used the following command which shows the GUI screen. But, how can i operate it at command line..

Thanks,
Raj!!

Hi,

How to Back up and Restore a Schema in a database on the same node.
Im using Vertica v5.0.11-0 version.
Please help me.

Thank you,
Raj.

Hi Skwa,

Thanks for your info.

"If it is upgraded from VERTICA 5 to VERTICA 6 (using != upgrade), then it is needed to re- index it,
else it is not needed to reindex. By default new functionalities are available in vertica 6."

Raj!!