AWS Redshift stored procedures have an atomic and non-atomic mode, the default being atomic but you can add a keyword of NONATOMIC to the stored procedure definition. Link below:
In DBVisualizer, if you try to add the NONATOMIC keyword to the stored procedure and compile it, it erases the word and then compiles successfully. Is there something i'm not doing right? It doesn't seem to matter where you put the keyword either. We are on the latest version of dbvisualizer.
Any help would be greatly appreciated. Thanks!
1 Comment
Peer Törngren
said
about 1 year ago
Hi Tim,
This looks like a shortcoming that we need to look into. I will register this and bring it up for discussion.
Tim
AWS Redshift stored procedures have an atomic and non-atomic mode, the default being atomic but you can add a keyword of NONATOMIC to the stored procedure definition. Link below:
https://docs.aws.amazon.com/redshift/latest/dg/stored-procedure-transaction-management.html#stored-procedure-transaction-management-nonatomic-mode
In DBVisualizer, if you try to add the NONATOMIC keyword to the stored procedure and compile it, it erases the word and then compiles successfully. Is there something i'm not doing right? It doesn't seem to matter where you put the keyword either. We are on the latest version of dbvisualizer.
Any help would be greatly appreciated. Thanks!