Avatar of jamestieman
jamestieman

asked on 

ODBC iSeries DSN SQL String Format

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
IBM System iVisual Basic.NET

Avatar of undefined
Last Comment
jamestieman

8/22/2022 - Mon