Hi all,

We are trying to call the DB2 Sequence through Spark and assign that value to one of the column (PK) in table. We are getting the below issue:

SEQ: CITI_VENDOR_UNITED_LIST_TARGET_SEQ
Table: CITI_VENDOR_UNITED_LIST_TARGET
DB: CITIVENDORS
Host: CIT_XX
Port: 42194
Schema: MINE

DB2 SQL ERROR: SQLCODE = 348, SQLSTATE= 428F9 SQLERRMC=NEXTVAL FOR MINE.CITI_VENDOR_UNITED_LIST_TARGET_SEQ 

IS this error because SEQUENCE is not deterministic a column ? I can query using simple SQL. But not from my spark code. The spark code is usual one with connection properties using spark.read.jdbc.

Thanks and regards,
Ravion