Is it difficult to implement Result.LastInsertId()? Why isn't it implemented?

[ZhengweiHou]

https://github.com/ibmdb/go_ibm_db/blob/33d7b57f99fdc36fc42b5d7705277123e9a93fe4/result.go#L15C1-L18C2

[ZhengweiHou]

Or is there any other temporary way to achieve it?

[bimalkjha]

@ZhengweiHou There is another way to get it by just executing SELECT IDENTITY_VAL_LOCAL() AS last_inserted_id FROM SYSIBM.SYSDUMMY1; query.

Output from CLI Script showing query output:

> sqlallocstmt 1 1
SQLAllocStmt: rc = 0 (SQL_SUCCESS)
              CLI hstmt = 1, Test Driver hstmt = 1
> sqlexecdirect 1 "CREATE TABLE employees ( employee_id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL, name VARCHAR(20), department VARCHAR(20), PRIMARY KEY (employee_id) )" -3
SQLExecDirect: rc = 0 (SQL_SUCCESS)
> sqlprepare 1 "INSERT INTO employees (name, department) VALUES ('John Doe', 'Sales')" -3
SQLPrepare: rc = 0 (SQL_SUCCESS)
> sqlexecute 1
SQLExecute: rc = 0 (SQL_SUCCESS)
> sqlexecdirect 1 "SELECT IDENTITY_VAL_LOCAL() AS last_inserted_id FROM SYSIBM.SYSDUMMY1" -3
SQLExecDirect: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll:  Columns: 1
  LAST_INSERTED_ID
  1
FetchAll: 1 rows fetched.
>

Thanks.

[bimalkjha]

Internal link for my reference: https://jira.rocketsoftware.com/browse/DBC-17270