Hello
We are trying to add an Active-Link table from our AS/400 using OBDC driver. We create a custom SQL statement which includes a join to another table and our SQL statement is over 255 in character size. We can execute the query and preview the data fine but when we click next and assign a name for our table, the table is not created and we don't get any kind of error message.
Here is my SQL statement:
SELECT LWFILES001_CLTMSTPF.CLTSTS, LWFILES001_EVETRNPF.EVESFC, LWFILES001_EVETRNPF.EVEPRG, LWFILES001_EVETRNPF.EVERGR, LWFILES001_EVETRNPF.EVECEQ, LWFILES001_EVETRNPF.EVETMM, LWFILES001_EVETRNPF.EVECAS, LWFILES001_EVETRNPF.EVERMB, LWFILES001_EVETRNPF.EVETDD, LWFILES001_EVETRNPF.EVETYP, LWFILES001_EVETRNPF.EVEAGE, LWFILES001_EVETRNPF.EVECNF
FROM LWFILES001.EVETRNPF LWFILES001_EVETRNPF
INNER JOIN LWFILES001.CLTMSTPF LWFILES001_CLTMSTPF
ON LWFILES001_EVETRNPF.EVECAS = LWFILES001_CLTMSTPF.CLTCAS
WHERE (CLTSTS = 'A')
AND EVECN IN ('S', 'U')
AND (EVETYP = 'S')
AND EVECAS <> '000000000'
AND EVERMB IN ('01', '03', '05', '06')
AND EVEPRG NOT IN ('48', '49', '23', '16')
Also why does the SQL Genie wrap single quotes around my field names? I have to remove them before executing the query before I try to save it.
WHERE ('CLTSTS' = 'A')
AND 'EVECN' IN ('S', 'U')
AND ('EVETYP' = 'S')
AND 'EVECAS' <> '000000000'
AND 'EVERMB' IN ('01', '03', '05', '06')
AND 'EVEPRG' NOT IN ('48', '49', '23', '16')
Thank you
Tim
We are trying to add an Active-Link table from our AS/400 using OBDC driver. We create a custom SQL statement which includes a join to another table and our SQL statement is over 255 in character size. We can execute the query and preview the data fine but when we click next and assign a name for our table, the table is not created and we don't get any kind of error message.
Here is my SQL statement:
SELECT LWFILES001_CLTMSTPF.CLTSTS, LWFILES001_EVETRNPF.EVESFC, LWFILES001_EVETRNPF.EVEPRG, LWFILES001_EVETRNPF.EVERGR, LWFILES001_EVETRNPF.EVECEQ, LWFILES001_EVETRNPF.EVETMM, LWFILES001_EVETRNPF.EVECAS, LWFILES001_EVETRNPF.EVERMB, LWFILES001_EVETRNPF.EVETDD, LWFILES001_EVETRNPF.EVETYP, LWFILES001_EVETRNPF.EVEAGE, LWFILES001_EVETRNPF.EVECNF
FROM LWFILES001.EVETRNPF LWFILES001_EVETRNPF
INNER JOIN LWFILES001.CLTMSTPF LWFILES001_CLTMSTPF
ON LWFILES001_EVETRNPF.EVECAS = LWFILES001_CLTMSTPF.CLTCAS
WHERE (CLTSTS = 'A')
AND EVECN IN ('S', 'U')
AND (EVETYP = 'S')
AND EVECAS <> '000000000'
AND EVERMB IN ('01', '03', '05', '06')
AND EVEPRG NOT IN ('48', '49', '23', '16')
Also why does the SQL Genie wrap single quotes around my field names? I have to remove them before executing the query before I try to save it.
WHERE ('CLTSTS' = 'A')
AND 'EVECN' IN ('S', 'U')
AND ('EVETYP' = 'S')
AND 'EVECAS' <> '000000000'
AND 'EVERMB' IN ('01', '03', '05', '06')
AND 'EVEPRG' NOT IN ('48', '49', '23', '16')
Thank you
Tim