I have a specific query. In Netezza, I need to assign the value of one record to another record. I am trying as below,
record1 := record2;
But it is not working this way. While if I try to assign individual values, it is working. Like...
record1.col1 := record2.col1;
Can we all the values at the same time as done in Oracle. If possible, how?