Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tDBInput - cursor size 100000 - get the error record id

Hi,

 

I have a job that has tDBInput ---> tJavaFlex----> tDataShuffle ----> tDBOutput

 

In tDBInput the records are read with cursor size - 100000 followed by shuffle.

I am using tJavaFlex component between reading and shuffling to get the current record id - globalMap.put("currentID", row1.ID); This is used in tDie component to log the id when it failed.

 

My question is:

Since the fetch is based on cursor and not on individual record, will the value of "currentID" be the last record in the cursor or will it be assigned the current record id that is read from table?

 

Could you clarify as I am not a DB expert and trying to understand how it would work.

 

Thanks 

Labels (3)
0 Replies