× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
vaibhavladdha271(*) reported 2014-01-31T04:36:35Z  · NielsGron last modified 2014-06-25T01:09:25Z

Statement separator not working properly for Server script generator in Paraccel


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Server Script Gen
Version Future - 0.1

Aqua Data Studio 15.0.0-dev-86
Build #: 35703
Built on: 2014-Jan-27 10:31:45 AM     

Database:Paraccel 4.0.2.4

Operating environment:Windows 7 x64

Connect to Paraccel

Create 2 groups named 'administrator','test_group'

Create group scripts:

CREATE GROUP [administrators] WITH SYSID 100 
GO
GRANT CREATE ON DATABASE [sfd] TO GROUP [administrators]
GO
GRANT CREATE, TEMP ON DATABASE [dev] TO GROUP [administrators]
GO
GRANT TEMP ON DATABASE [project] TO GROUP [administrators]
GO
GRANT CREATE ON DATABASE [atest] TO GROUP [administrators]
GO
 
CREATE GROUP [test_group] WITH SYSID 12 
GO
 
Right click on Groups in security node
 
Select Tools->Select server script generator
 
Select Groups from Object types window
 
Click Next
 
Select One file from Save as field
 
Enter file name in File field
 
Select '/' from statement separator field
 
Select Single Quotes: 'object' from Object quoted identifier field
 
Check all options
 
Click Next
 
Here statement separator is generated properly for every statement
 
Now again Go to Server script generator window
 
Change Statement separator from '/' to 'GO'
 
Click Next button
 
Go to File & verify contents of file
 
Here statement separator does not change for every statement in file

 

2 attachments

Issue #11591

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017