on 03-05-2015 5:18 PM
Hello,
when we executed the below sql statement in hdbsql, we are getting the syntax error. I think issue is because of incorrect quotes. please suggest correct statement.
su - <sid>adm –c ‘hdbsql –U SYSTEM “ALTER SYSTEM ALTER CONFIGURATION('indexserver.ini','System')SET('password policy','force_first_password_change') = 'false' with reconfigure”’
Regards
Shridhar Gowda
Hello Shridhar,
The syntax error is caused by single quotation matching ( ' before hdbsql matchs ' before indexserver.ini, but you do not want to see that...)
Can you use an alternative way if you want to do it in one step:
Firstly, put the followings into a executable file:
hdbsql -i ## -n hostname -u SYSTEM -p password "ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini','System') SET ('password policy','force_first_password_change') = 'false' with reconfigure"
Secondly, execute su - sidadm -c file_name
Regards,
Ning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Colleagues,
Thanks for the assistance so far.
We happen to get the following error too:
su - <sid>adm -c 'hdbsql -U SYSTEM export "'A'"."'*'" as binary into "'Export location'" with replace'
* 257: sql syntax error: incorrect syntax near "*": line 1 col 16 (at pos 16) SQLSTATE: HY000
su - <sid>adm -c 'hdbsql -U SYSTEM export "'A'".'"*"' as binary into "'Export location'" with replace'
hdbsql: No match.
I am confused now, Is the second statement correct or wrong.
Can any of you confirm this.
Thanks and Regards,
Akhil
I tried the same using the 2 step procedure and it works for me Can you try that? Step 1. hdbsql -i INS# -n HOSTNAME -U SYSTEM Step 2. ALTER SYSTEM ALTER CONFIGURATION('indexserver.ini','System') SET('password policy','force_first_password_change') = 'false' with reconfigure
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.