Forum Stats

  • 3,827,324 Users
  • 2,260,761 Discussions
  • 7,897,203 Comments

Discussions

sqlcl lb exit code is always 0

User_LSLH0
User_LSLH0 Member Posts: 4 Blue Ribbon

Hi

I am running sqlcl liquibase from script like so.

The exit code is always 0 regardless of success or failure of change log errors .

How can we get return code when sqlcl lb fail?

sql /nolog<<EOF

WHENEVER OSERROR EXIT FAILURE

WHENEVER SQLERROR EXIT FAILURE

 connect usr/pwd

  lb update -changelog changelog.xml

EOF

echo $?

Answers