Expand my Community achievements bar.

SOLVED

what is the difference between xtk.session.write and sqlExec in terms of inserting and updating the data in schema

Avatar

Level 4

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Amine_Abedour 

Hi All,

what is the difference between xtk.session.write and sqlExec in terms of inserting and updating the data in schema

when we should use xtk.session.write and sqlExec in terms of inserting and updating the data in schema

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @DishaSharma 

 

The main difference between those are :-

sqlExec executes an SQL script whereas Write uses and XML Doc.

Both can be used to Upsert data according to use cases.

 

Thanks

Akshay

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @DishaSharma 

 

The main difference between those are :-

sqlExec executes an SQL script whereas Write uses and XML Doc.

Both can be used to Upsert data according to use cases.

 

Thanks

Akshay