Hi All,

What could be the equvalant line for the following line

floor(CAST( DATEDIFF( DAY, "dly_partcpnt_dim"."brth_dt",convert(datetime, {d '2012-02-29'}) ) as REAL ) / 365.25).
Note :This is sql code . I want the same in vertica.

Please help me out .

Thanks in advance ,
Malar

Hi All,

Do we have looping statements in vertica like (for, while, do while).

If so , syntax and all is similar sql ?

Thnaks in Advance!!!

Malar

Hi ,

I just want to know, can we migrate data from sysbase to vertica with out using any ETL tool.

Thanks,
Malar

Hi All, In a table for example Employee_table , empid is set as primarykey. When i insert duplicate records it is accepting the records. sample data: empid empname 101 A 101 B But when we take this records in joining tables it is voilating. I just want to get the error message when i insert data to ...

Hi ,

Can anybody help me out to do the following thing .

1.How to migrate a schema or tables from oracle to vertica.

thanks,
Malar

Hi ,

Yes that is what i wanted to do.Thanks for the solution .

Thanks,
Malar

Hi All,

I want to implement c++ add & substraction concepts using a single library in vertica.

Please help me out to find the solution for this .

Thanks .
Malar