Hello community,
After binding `db2sampl_VECTOR.bnd`, you can use the Db2 stored procedure `CALL SYSPROC.CREATE_VECTOR_SAMPLE('SAMPLE_VECTOR')` in Db2 v12.1.5 to generate sample data.

Are there any examples available here showing how to query these tables? I would like to incorporate the new vector technology into my training materials and make use of existing queries if possible. If not, perhaps we could compile some examples together?

CREATE TABLE SAMPLE_VECTOR.MLBLOGS_ANSWERS (
  ANSWER  VARCHAR(1024)
  ) 
  IN IBMDB2SAMPLEVECTOR
  COMPRESS YES STATIC
  ORGANIZE BY ROW;

CREATE TABLE SAMPLE_VECTOR.MLBLOGS_QUESTIONS (
  QUESTION  VARCHAR(1024)
  ) 
  IN IBMDB2SAMPLEVECTOR
  COMPRESS YES STATIC
  ORGANIZE BY ROW;

CREATE TABLE SAMPLE_VECTOR.PATIENTS (
  PATIENT_ID  INTEGER,
  NAME  VARCHAR(30),
  AGE  INTEGER,
  GENDER  VARCHAR(6),
  CHOLESTEROL_LEVEL  INTEGER,
  BLOOD_PRESSURE  INTEGER,
  SMOKING_STATUS  VARCHAR(10)
  ) 
  IN IBMDB2SAMPLEVECTOR
  COMPRESS YES STATIC
  ORGANIZE BY ROW;

Best Regards, Michael