Skip to content

Instantly share code, notes, and snippets.

@Sorien

Sorien/query.sql Secret

Created July 31, 2018 06:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Sorien/558c028ee20157a3976b2c283f356a0b to your computer and use it in GitHub Desktop.
Save Sorien/558c028ee20157a3976b2c283f356a0b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
Connect, CONNECT TO "D:\work\DB\Mydb.FDB" AS USER "SYSDBA"
Transaction, TRANSACTION STARTED.
Prepare Statement, Statement 1 : SELECT rdb$description AS VERSION FROM rdb$database
Execute Statement, Statement 1: SELECT rdb$description AS VERSION FROM rdb$database
Prepare Statement, Statement 2 : SELECT ID_USER, FULLNAME, LOGIN, ROLE FROM CFG_USERS ORDER BY FULLNAME ASC
Execute Statement, Statement 2: SELECT ID_USER, FULLNAME, LOGIN, ROLE FROM CFG_USERS ORDER BY FULLNAME ASC
Transaction, COMMIT TRANSACTION "D:\work\DB\Mydb.FDB"
Connect, DISCONNECT FROM "D:\work\DB\Mydb.FDB"
Connect, CONNECT TO "D:\work\DB\Mydb.FDB" AS USER "SYSDBA"
Transaction, TRANSACTION STARTED.
Prepare Statement, Statement 3 : SELECT rdb$description AS VERSION FROM rdb$database
Execute Statement, Statement 3: SELECT rdb$description AS VERSION FROM rdb$database
Transaction, COMMIT TRANSACTION "D:\work\DB\Mydb.FDB"
Connect, DISCONNECT FROM "D:\work\DB\Mydb.FDB"
Connect, CONNECT TO "D:\work\DB\Mydb.FDB" AS USER "sysdba"
Transaction, TRANSACTION STARTED.
Prepare Statement, Statement 4 : SELECT rdb$description AS VERSION FROM rdb$database
Execute Statement, Statement 4: SELECT rdb$description AS VERSION FROM rdb$database
Prepare Statement, Statement 5 : EXECUTE BLOCK RETURNS (ID_USER Integer, FULLNAME VarChar(50), ROLE Integer, CONNECTION_ID Integer) AS BEGIN FOR EXECUTE STATEMENT 'SELECT FIRST 1 ID_USER, FULLNAME, ROLE, MON$ATTACHMENT_ID FROM CFG_USERS LEFT JOIN MON$ATTACHMENTS on MON$ATTACHMENT_ID = CONNECTION_ID WHERE LOGIN = ''servis''' WITH autonomous TRANSACTION INTO :ID_USER, :FULLNAME, :ROLE, :CONNECTION_ID DO SUSPEND; END
Execute Statement, Statement 5: EXECUTE BLOCK RETURNS (ID_USER Integer, FULLNAME VarChar(50), ROLE Integer, CONNECTION_ID Integer) AS BEGIN FOR EXECUTE STATEMENT 'SELECT FIRST 1 ID_USER, FULLNAME, ROLE, MON$ATTACHMENT_ID FROM CFG_USERS LEFT JOIN MON$ATTACHMENTS on MON$ATTACHMENT_ID = CONNECTION_ID WHERE LOGIN = ''servis''' WITH autonomous TRANSACTION INTO :ID_USER, :FULLNAME, :ROLE, :CONNECTION_ID DO SUSPEND; END
Prepare Statement, Statement 6 : SELECT GEN_ID(AGENDA_ID, 0) FROM RDB$DATABASE
Execute Statement, Statement 6: SELECT GEN_ID(AGENDA_ID, 0) FROM RDB$DATABASE
Connect, CONNECT TO "D:\work\DB\Mydb.FDB" AS USER "SYSDBA"
Transaction, TRANSACTION STARTED.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment