How do I verify if my AAI database is case insensitive?
AAI and Autosys both must be using the same case sensitivity. By default AAI should be case sensitive.
Release : 6.0.1
Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE
In order to verify if the AAI database is set to be case sensitive run the following query:
select * from JawsProperties where propertyName='DB.SCHEMA.VERSION'
If the database is case sensitive then you will not receive any result set.
In order to verify if your Autosyst DB is case senstive run:
select str_val from ujo_alamode where type='autoserv'
If you receive result str_val and it is not null then it is case insensitive else database otherwise it is case sensitive.