Jeremiah31
Programmer
I'm working on a AS400/DB2 system. I'm new to IBM DB2, and so far I'm not having very much luck.
What I'm trying to create a query were the results would insert into a table.
I learned that AS400 works with libraries, and I need to show the correct library path.
Questions that I have is, I'm I using the correct code, how do I reference an Access table?
My goal for today is to transfer a field into a table. I'm using access the information by a passthrough query .
INSERT INTO TBLTEST (txtTrailerNumber)
(select SSCPGM.WHPMTLDA.TRLR_ID_NO
from SSCPGM.WHPMTLDA)
What I'm trying to create a query were the results would insert into a table.
I learned that AS400 works with libraries, and I need to show the correct library path.
Questions that I have is, I'm I using the correct code, how do I reference an Access table?
My goal for today is to transfer a field into a table. I'm using access the information by a passthrough query .
INSERT INTO TBLTEST (txtTrailerNumber)
(select SSCPGM.WHPMTLDA.TRLR_ID_NO
from SSCPGM.WHPMTLDA)