# Using contexts on modifySQL

**URL:** <https://forum.liquibase.org/t/using-contexts-on-modifysql/2190>\
**Category:** General Discussion\
**Created:** [January 30, 2013, 12:39am UTC](https://forum.liquibase.org/t/using-contexts-on-modifysql/2190 "2013-01-30T00:39:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ecalvert](https://avatars.discourse-cdn.com/v4/letter/e/e19adc/32.png) [@ecalvert](https://forum.liquibase.org/u/ecalvert)\
**Post date:** [January 30, 2013, 12:39am UTC](https://forum.liquibase.org/t/using-contexts-on-modifysql/2190/1 "2013-01-30T00:39:00Z")

</div>

Maybe I’m just missing something, but I can’t get a tag to accept a context. &nbsp;I’m using liquibase 2.0.5 and have the following as a sample changeLog that illustrates the problem:

\<?xml version="1.0" encoding="UTF-8"?\>

\<databaseChangeLog xmlns=“[http://www.liquibase.org/xml/ns/dbchangelog/1.9](http://www.liquibase.org/xml/ns/dbchangelog/1.9)”

&nbsp; xmlns:xsi=“[http://www.w3.org/2001/XMLSchema-instance](http://www.w3.org/2001/XMLSchema-instance)”

&nbsp; xsi:schemaLocation="[http://www.liquibase.org/xml/ns/dbchangelog/1.9](http://www.liquibase.org/xml/ns/dbchangelog/1.9)

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd](http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd)"\>

&nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \<append value="IN STX\_${SCHEMA}_TRNHIST INDEX IN SIX_${SCHEMA}\_TRNHIST DISTRI

BUTE BY HASH(THIST\_CARD\_NUM) COMPRESS YES VALUE COMPRESSION"/\>

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp;

When I run the above changeLog, I get the following error:

SEVERE 1/29/13 9:54 AM:liquibase: cvc-complex-type.3.2.2: Attribute ‘context’ is not allowed to appear in element ‘modifySql’.

However, if I remove the context parameter, it works fine. &nbsp;

I have tried it both with and without the dbms parameter, and as ‘contexts’ instead of ‘context’ (just in case the documentation was wrong.

Based on some posts, it appears that some people are getting context to work on , so I’m afraid I’m missing some little bit of knowledge on how to make it work.
