在一个对象中从odbc加载两个表数据

Question

我试图从db中通过ODBC连接的两个表中获取数据。我不确定该怎么做，因为我正在尝试在db400中学到的基本查询。

ODBC CONNECT TO trial;

//-------- Start Multiple Select Statements ------



SQL SELECT *

FROM graphdata.`kbl_one_voice_responsiveness_measured`;

//-------- End Multiple Select Statements ------



/*TARGET TABLE */



LOAD [setup],

    'Responsiveness' as Domain,

    [sku],

    [KPI],

    [target]

as [SQL SELECT *

FROM graphdata.`kbl_one_voice_responsiveness_target`;]

我得到了这个错误

Syntax error



Unexpected token: 'ODBC', expected one of: ',', 'AutoGenerate', 'From', 'From_Field', 'Inline', 'Resident', 'Where', ...



LOAD [setup],

    'Responsiveness' as Domain,

    [sku],

    [KPI],

    [target]

as [SQL SELECT *

FROM graphdata.`kbl_one_voice_responsiveness_target`;]

///$tab KBL_Perf

>>>>>>ODBC<<<<<< CONNECT TO trial

请让我知道我哪里错了

Answer 1

您不应该将sql select包装在[]中

LOAD 
  setup,
  'Responsiveness' as Domain,
  sku,
  KPI,
  target
;
SQL 
SELECT 
  *
FROM 
  graphdata.`kbl_one_voice_responsiveness_target`
;

此外，没有必要在[]中对字段进行换行，除非它们包含空格。