What is the use of INROWNUM and OUTROWNUM datastage variables?
@INROWNUM and @OUTROWNUM are internal datastage variables which do the following: * @INROWNUM counts incoming rows to a transformer in a datastage job * @OUTROWNUM counts oucoming rows from a transformer in a datastage job These variables can be used to generate sequences, primary keys, id’s, numbering rows and also for debugging and error tracing. They play similiar role as sequences in Oracle. 24.Datastage trim function cuts out more characters than expected By deafult datastage trim function will work this way: Trim(” a b c d “) will return “a b c d” while in many other programming/scripting languages “a b c d” result would be expected. That is beacuse by default an R parameter is assumed which is R – Removes leading and trailing occurrences of character, and reduces multiple occurrences to a single occurrence. To get the “a b c d” as a result use the trim function in the following way: Trim(” a b c d “,” “,”B”) 25. Database update actions in ORACLE stage The destination table can b
Related Questions
- My firewall starts and restarts fine but if I try shorewall restore, the script fails because none of my shell variables from /etc/shorewall/params are set. Why?
- What are variables with values that are determined by chance called in statistics?
- What is the use of INROWNUM and OUTROWNUM datastage variables?
