Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.
TD_FillRowID InputTable: fillrowid_input
Survived Pclass Name Age -------- ------ ------------------ --- 0 3 Mrs. Jacques Heath 35 0 3 Mr. Owen Harris 22 1 3 Mrs. Laina 26 1 1 Mrs. John Bradley 38
TD_FillRowID SQL Call
SELECT * FROM TD_FillRowID ( ON fillrowid_input AS InputTable PARTITION BY Pclass ORDER BY Age USING RowIDColumnName ('PassengerId') ) AS dt;
TD_FillRowID Output
The output shows the generated IDs in the PassengerId column.
Survived Pclass Name Age PassengerId -------- ------ ------------------ --- ----------- 1 1 Mrs. John Bradley 38 4 0 3 Mr. Owen Harris 22 4 1 3 Mrs. Laina 26 8 0 3 Mrs. Jacques Heath 35 12