Using autoNumberHash

[#1]

Hello Guys!

I'm creating my first QV document and I have a lot of composite keys in my database...

So, I'm wondering to do something like:

SQL SELECT autonumberhash128 ( DRIVER.REGION_ID, DRIVER.ID ) as "driverPK",

DRIVER.REGION_ID,
DRIVER.ID,
FIRST_NAME
FROM myTable;

I'm importing data from SQL Server database, and of course, autoNumberHash128 is not a SQL Server function. How it's works?

QV throws an error when I tried to run this query.

There is any specific manual regarding load data and scripts?

Regards,

RM

[vidyut]

Hi, You do it using preceding load as shown below. As it is not a SQL function, you are getting an error.

Load autonumberhash128(DRIVER.......) as driverPK,*;

SQL SELECT DRIVER.REGION_ID,DRIVER.ID......

From MyTable.