Reference:10. Modify Sequence and TSeq

The same syntax for array assignment in Java also applies to the sequence modification in esProc, that is, you can just assign directly to the member at appointed position to implement it. 

esproc_reference10_1Besides, similar to SQL statement, you can also use the insert, delete, modify, and other functions to perform the insert, delete, modify, and other operations on the sequence.


Unlike the other Sequence, the member of record in TSeq cannot be assigned directly. For example, if T is a TSeq, then the T(3)=r operation is wrong.

When modifying TSeq, you can only use insert( ), delete( ), modify( ), and other functions to modify the TSeq, or directly modify the record of this field.


As the expression in the A5 indicates that you can use ISeq to indicate the position when deleting the records in the TSeq. Therefore, with the pickout function of pselect() in the TSeq, you can delete the records according to the specified conditions.

esproc_reference10_4Use reset() function to delete all records in the TSeq and only keep the data structure.



About datathinker

a technical consultant on Database performance optimization, Database storage expansion, Off-database computation. personal blog at: datakeywrod, website: raqsoft
This entry was posted in Reference and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s