I have a VB.NET application that uses the ODBCConnection object to connect to a DSN that is defined using the iSeries Access ODBC driver. Right now, I can connect using the DSN name "AS400", like this: dsn=AS400 as the connection string. If a connection using the DSN is established in Excel first, Excel prompts for the credentials and then I can connect to the AS400. (How to provide credentials from my app is another question in my questions)
I need to create an update query and I don't know how to format it because I don't know what is considered the table name? Is this correct?
UPDATE Z3ODSPL SET DLUSPLIST = 1 WHERE DLUSPLIC = 300001002
Am I supposed to use the Database Library - TR1491AFWM, somewhere?
The AS400 people created a table and gave me this information.
Database file name - Z3ODSPL
Database Library - TR1491AFWM
Field Name - DLUSPLIC
FMT - P
Start -1
Lngth - 10
Dec - 00
Key -
Field Description - Plate Number
Field Name - DLUSPLINO
FMT - P
Start -7
Lngth - 4
Dec - 00
Key -
Field Description - Light Number
Field Name - DLUSPLIST
FMT - P
Start -10
Lngth - 1
Dec - 00
Key -
Field Description - Status
Our community of experts have been thoroughly vetted for their expertise and industry experience.