Sql – 4200 – SQL0104 – Token was not valid

ibm-midrangeselectsqlvb.net

ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104
– Token ( was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH ORDER UNION EXCEPT OPTIMIZE.

This is My Code, I want to display the Table Records to Data Grid View in VB from AS400

Sub ShowAS400()
    Call takeconnectionas400()
    conn.Close()
    conn.Open()
    adapter = New OdbcDataAdapter("select * from PYLEAVE (PTMIFLIB)", conn)
    ds = New DataSet
    adapter.Fill(ds, "PYLEAVE (PTMIFLIB)")
    DGVAS400.DataSource = ds.Tables("PYLEAVE (PTMIFLIB)")
    DGVAS400.ReadOnly = True
End Sub

Best Answer

try to modify your query like this

  select * from PTMIFLIB.PYLEAVE

or like this

  select * from PTMIFLIB/PYLEAVE

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

Sql – Not able to run SQL queries in AS400, run into Invalid Token errors

TABLE is a reserved word. SQL Reference: Reserved schema names and reserved words.

Single quotes escape a string literal
Double quotes escape a reserved word (similar to brackets in TSQL)

SQL Reference: Identifiers

The queries could be re-written as:

SELECT ID, SUM(FIELD1 + FIELD2) AS TOTAL FROM "TABLE" GROUP BY ID
SELECT COUNT(*) FROM (SELECT DISTINCT FIELD1 FROM "TABLE" WHERE FIELD2 = 'ABC')

UPDATE

DB/2 for i does not support your method of numeric to character conversion or the type of character comparison used in your LIKE query.

The query can be re-written as:

SELECT eds, SUM(INT(sds)) AS totalh 
FROM tbl1 
WHERE eds BETWEEN 20130500 AND 20130599 
AND siteds IN (
    SELECT DISTINCT site 
    FROM tbl2 
    WHERE H_04 IN ('1234') AND PERIOD = 201305
) 
GROUP BY eds
ORDER BY eds

You may need to use DEC instead of INT depending upon the definition of field sds.

SQL Reference: - INT - DEC - BETWEEN

Best Answer

Related Solutions

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

Sql – Not able to run SQL queries in AS400, run into Invalid Token errors

Related Topic