Toby Mills Posted November 12, 2021 Share Posted November 12, 2021 At one point, we used to document all the names of variables you could check that tell you about your current adapter. All the info youd see by doing ENGINE SQLMSS Would have a &variables associated with them in case you wanted to programmatically check your user name or something. I found this link for 7707 docs by searching in google, but the link wont open for me. https://ecl.informationbuilders.com/focus/topic/shell_7707/adapter/relational/source/topic84.htm You can tell were looking at 7707 docs, and probably adapter administration, but I dont have that manual downloaded. Anybody have documentation on these Theyll be names like &ORAUSER or &MSSUSER &MSSSERVER or &ORASERVER Im hunting for more names - perhaps &MSSCONN will work for example. Ill post if I find more. Link to comment Share on other sites More sharing options...
Toby Mills Posted November 12, 2021 Author Share Posted November 12, 2021 Heres what I found by digging around - I bet replacing MSS in front with ORA will work for you guys doing oracle. If you want me to go find all those, I can look for them too. -TYPE MSSABORTRPT &MSSABORTRPT -TYPE MSSAUTOCOM &MSSAUTOCOM -TYPE MSSAUTODIS &MSSAUTODIS -TYPE MSSCONNAME &MSSCONNAME -TYPE MSSDRVINFO &MSSDRVINFO -TYPE MSSERUN &MSSERUN -TYPE MSSFETCHSIZE &MSSFETCHSIZE -TYPE MSSINSERTSIZ &MSSINSERTSIZ -TYPE MSSISOLATION &MSSISOLATION -TYPE MSSITEOPT &MSSITEOPT -TYPE MSSJOINTYPE &MSSJOINTYPE -TYPE MSSLOGINTIME &MSSLOGINTIME -TYPE MSSMSGTXT &MSSMSGTXT -TYPE MSSOPT &MSSOPT -TYPE MSSOWNERID &MSSOWNERID -TYPE MSSSERVER &MSSSERVER -TYPE MSSSQLTAG &MSSSQLTAG -TYPE MSSTABQUAL &MSSTABQUAL -TYPE MSSTIMEOUT &MSSTIMEOUT -TYPE MSSUSER &MSSUSER Link to comment Share on other sites More sharing options...
Martin Yergeau Posted November 12, 2021 Share Posted November 12, 2021 This is at what your link is pointing Link to comment Share on other sites More sharing options...
David Beagan Posted November 12, 2021 Share Posted November 12, 2021 Toby, it opened for me. Making it into code for your cut-and-paste convenience: -TYPE All adapter environmental settings are available for display and query as Dialogue Manager variables. The following sections list the variable names for each RDBMS, and the lines displaying their settings in the SQL query. -TYPE . -TYPE Note: If the length of the current setting value is greater than 12, the Dialogue Manager variable makes only the first 12 characters available. -TYPE . -TYPE Dialogue Manager Variables for the Adapter for DB2 -TYPE The following variables are available for DB2: -TYPE . -TYPE &SQLCAF - (FOC1442) CALL ATTACH FACILITY IS -TYPE &SQLSSID - (FOC1447) SSID FOR CALL ATTACH IS -TYPE &SQLPLANA - (FOC1448) ACTIVE PLAN FOR CALL ATTACH IS -TYPE &SQLPLANU - (FOC1459) USER SET PLAN FOR CALL ATTACH IS -TYPE &SQLPLANI - (FOC1460) INSTALLATION DEFAULT PLAN IS -TYPE &SQLSTATIC - (FOC1503) SQL STATIC OPTION IS -TYPE &SQLAUTOCLS - (FOC1444) AUTOCLOSE OPTION IS -TYPE &SQLAUTODIS - (FOC1496) AUTODISCONNECT OPTION IS -TYPE &SQLAUTOCOM - (FOC1499) AUTOCOMMIT OPTION IS -TYPE &SQLDBSPACE - (FOC1446) DEFAULT DBSPACE IS -TYPE &SQLID - (FOC1449) CURRENT SQLID IS -TYPE &SQLISOLATION - (FOC1424) ISOLATION LEVEL FOR DB2 TABLE INTERFACE IS -TYPE &SQLWRITE - (FOC1441) WRITE FUNCTIONALITY IS -TYPE &SQLOPT - (FOC1445) OPTIMIZATION OPTION IS -TYPE &SQLITEOPT - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS -TYPE &SQLEMSG - (FOC1484) SQL ERROR MESSAGE TYPE IS -TYPE &SQLEXPL - (FOC1497) SQL EXPLAIN OPTION IS -TYPE &SQLQUERYNO - (FOC1551) QUERY NUMBER TO BE USED FOR EXPLAIN -TYPE &SQLDEFDATE - (FOC1552) INTERFACE DEFAULT DATE TYPE -TYPE &SQLOWNERID - (FOC1520) SQL CURRENT OWNER ID IS -TYPE -TYPE &SQLRELEASE - Current release of DB2 in format Dxxx where -TYPE . xxx is release number (for example, 910 for -TYPE . DB2 Version 9 Release 1). -TYPE . -TYPE &SQLVVRRM - Return from CONNECT in the form DSNvvrrM. -TYPE . vv is the Version of DB2, rr is the Release, M is the -TYPE . Modification level. For more information, consult IBM's -TYPE . DB2 SQL Reference. -TYPE Top of page -TYPE Dialogue Manager Variables for the Adapter for Teradata -TYPE The following variables are available for Teradata: -TYPE . -TYPE &DBCCON - (FOC1463) DBC/1012 CONNECTION -TYPE &DBCPART - (FOC1467) PARTITION -TYPE &DBCTDP - (FOC1468) TERADATA DIRECTOR PROGRAM (TDP) -TYPE &DBCUSER - (FOC1469) DBC/1012 USER ID -TYPE &DBCAUTOCLS - (FOC1444) AUTOCLOSE OPTION IS -TYPE &DBCWRITE - (FOC1441) WRITE FUNCTIONALITY IS -TYPE &DBCOPT - (FOC1445) OPTIMIZATION OPTION IS -TYPE &DBCITEOPT - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS -TYPE &DBCEMSG - (FOC1484) SQL ERROR MESSAGE TYPE IS -TYPE &DBCEXPL - (FOC1497) SQL EXPLAIN OPTION IS -TYPE &DBCDEFDATE - (FOC1552) INTERFACE DEFAULT DATE TYPE -TYPE &DBCOWNERID - (FOC1520) DBC CURRENT OWNER ID IS -TYPE Top of page -TYPE Dialogue Manager Variables for the Adapter for IDMS/SQL -TYPE The following variables are available for IDMS/SQL: -TYPE . -TYPE &IDQDICTNAME - (FOC1756) CURRENT IDMS DICTIONARY IS -TYPE &IDQCURSCHEMA - (FOC1757) CURRENT SCHEMA IS -TYPE &IDQISLEVEL - (FOC1758) CURRENT ISOLATION LEVEL IS -TYPE &IDQAUTOCOM - (FOC1499) AUTOCOMMIT OPTION IS -TYPE &IDQDBSPACE - (FOC1446) DEFAULT DBSPACE IS -TYPE &IDQOPT - (FOC1445) OPTIMIZATION OPTION IS -TYPE &IDQITEOPT - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS -TYPE &IDQDEFDATE - (FOC1552) INTERFACE DEFAULT DATE TYPE -TYPE Top of page -TYPE Dialogue Manager Variables for the Adapter for Oracle -TYPE The following variables are available for Oracle: -TYPE . -TYPE &ORASERVER - (FOC1656) DEFAULT SERVER NAME -TYPE &ORAUSER - (FOC1502) USERID AND PASSWORD ARE -TYPE &ORAAUTODIS - (FOC1496) AUTODISCONNECT OPTION IS -TYPE &ORAAUTOCOM - (FOC1499) AUTOCOMMIT OPTION IS -TYPE &ORADBSPACE - (FOC1446) DEFAULT DBSPACE IS -TYPE &ORAFETCHSIZE - (FOC1491) FETCH BUFFERING FACTOR -TYPE &ORAINSERTSIZ - (FOC1531) INSERT BUFFERING FACTOR -TYPE &ORASPMAXPRM - (FOC1379) MAXIMUM STORED PROCEDURE PARAMETERS -TYPE &ORAWRITE - (FOC1441) WRITE FUNCTIONALITY IS -TYPE &ORAOPT - (FOC1445) OPTIMIZATION OPTION IS -TYPE &ORAITEOPT - (FOC1763) IF-THEN-ELSE OPTIMIZATION IS -TYPE &ORAEMSG - (FOC1484) SQL ERROR MESSAGE TYPE IS -TYPE &ORADEFDATE - (FOC1552) INTERFACE DEFAULT DATE TYPE -TYPE &ORAOWNERID - (FOC1520) ORACLE CURRENT OWNER ID IS -TYPE &ORADBSPACE - (FOC1446) DEFAULT DBSPACE IS -TYPE &ORAMSGTXT - MESSAGE RETURNED BY AN ORACLE STORED PROCEDURE Link to comment Share on other sites More sharing options...
Toby Mills Posted November 12, 2021 Author Share Posted November 12, 2021 Thanks guys! Ill add this to my adapter_variables.fex. Also I wonder what happened to this info in the newer releases We use mostly sql server and db2. Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 15, 2021 Share Posted November 15, 2021 Toby, Adapter Dialogue Manager Variables is included in the latest Relational Data Adapter Users Manual PDF (Release 8207.27.0). The topic starts on page 346. Here is the PDF link: docs.tibco.com TIB_focus_8207.27.0_relational_user.pdf 2.66 MB You can also access all of the latest FOCUS content here: https://docs.tibco.com/products/tibco-focus-8207-27-0 I hope this helps! Link to comment Share on other sites More sharing options...
Toby Mills Posted November 15, 2021 Author Share Posted November 15, 2021 toby.mills: -TYPE MSSABORTRPT &MSSABORTRPT -TYPE MSSAUTOCOM &MSSAUTOCOM -TYPE MSSAUTODIS &MSSAUTODIS -TYPE MSSCONNAME &MSSCONNAME -TYPE MSSDRVINFO &MSSDRVINFO -TYPE MSSERUN &MSSERUN -TYPE MSSFETCHSIZE &MSSFETCHSIZE -TYPE MSSINSERTSIZ &MSSINSERTSIZ -TYPE MSSISOLATION &MSSISOLATION -TYPE MSSITEOPT &MSSITEOPT -TYPE MSSJOINTYPE &MSSJOINTYPE -TYPE MSSLOGINTIME &MSSLOGINTIME -TYPE MSSMSGTXT &MSSMSGTXT -TYPE MSSOPT &MSSOPT -TYPE MSSOWNERID &MSSOWNERID -TYPE MSSSERVER &MSSSERVER -TYPE MSSSQLTAG &MSSSQLTAG -TYPE MSSTABQUAL &MSSTABQUAL -TYPE MSSTIMEOUT &MSSTIMEOUT -TYPE MSSUSER &MSSUSER Thanks Sarah! I thought you might know what manual to look in. I found these variables for SQL Server. Im not sure why they arent included in this manual Should I ask for a DocEnh for the SQL Server vars to be added Or is it not appropriate to put these variables in this manual for some reason Thanks Toby Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 15, 2021 Share Posted November 15, 2021 Toby, youre welcome! Im following up and will keep you posted. Link to comment Share on other sites More sharing options...
Michel Pageau Posted November 23, 2021 Share Posted November 23, 2021 Hi Sarah, And what are the names of DM Variables for Adapters like MySQL or PostgresSQL Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 29, 2021 Share Posted November 29, 2021 Michael, Im following up on that for you. Link to comment Share on other sites More sharing options...
Toby Mills Posted November 29, 2021 Author Share Posted November 29, 2021 Hi Michael I can take an educated guess for you. Try swapping MSS for MYS (for MYSQL) like -TYPE MYSQL Server Name: &MYSSERVER Try PST for Postgress like: -TYPE SQLPST Connection Name: &PSTCONNAME (follow this pattern with my list above on variable names - some of them will likely work) See if that gets you anywhere. Link to comment Share on other sites More sharing options...
Michel Pageau Posted November 29, 2021 Share Posted November 29, 2021 Hi Toby, Already tried different combinaison and did not get any valid ones. Thanks, Michel Link to comment Share on other sites More sharing options...
Toby Mills Posted November 30, 2021 Author Share Posted November 30, 2021 Sorry that didnt work Michael. Sometimes an educated guess pans out - sometimes not. Sarah will find out the real names. Id always believe what techsupport says over one of us. Meantime if youre feeling experimintal, try this: -* Vars that might work for MYSQL -TYPE MYSCONNAME : &MYSCONNAME -TYPE MYSFETCHSIZE : &MYSFETCHSIZE -TYPE MYSINSERTSIZ : &MYSINSERTSIZ -TYPE MYSDRVINFO : &MYSDRVINFO -TYPE MYSABORTRPT : &MYSABORTRPT -TYPE MYSSQLTAG : &MYSSQLTAG -* Vars that might work for Postgress -TYPE PSTCONNAME : &PSTCONNAME -TYPE PSTFETCHSIZE : &PSTFETCHSIZE -TYPE PSTINSERTSIZ : &PSTINSERTSIZ -TYPE PSTDRVINFO : &PSTDRVINFO -TYPE PSTABORTRPT : &PSTABORTRPT -TYPE PSTSQLTAG : &PSTSQLTAG My machine dies with physical interface not installed because I dont use those adapters. The important thing to note is that it does not try to prompt me for those variables - I think that means that these are real variables. Link to comment Share on other sites More sharing options...
Michel Pageau Posted December 1, 2021 Share Posted December 1, 2021 Hi Toby, The variables are working for MYSQL and PostgreSQL. Except for Variables MYSABORTRPT, MYSSQLTAG, PSTABORTRPT, and PSTSQLTAG all the others have an empty value. EX: MYSCONNAME (where my connection name is dev) And It should exist probably more than 6 variables for these Adapters. Thanks anyway, Link to comment Share on other sites More sharing options...
Toby Mills Posted December 1, 2021 Author Share Posted December 1, 2021 Thanks for the update Michael. Those variables are just best guesses from me. TIBCO support / Sarah will likely get the whole list you need. Ill be curious to see what they say. Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted December 2, 2021 Share Posted December 2, 2021 Hi Toby and Michel, Ive been following up and am trying to get this information for you. As soon as I have an update, I will post here. Thanks for your patience Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted December 3, 2021 Share Posted December 3, 2021 Hi Michel and Toby, I looked and asked around, but we dont have a list of variables for the adapters. What particular DBMS are you interested in Link to comment Share on other sites More sharing options...
Toby Mills Posted December 3, 2021 Author Share Posted December 3, 2021 Hi Sarah Michael was looking for MYSQL and Postrgress adapter variables. Thanks for checking! Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted December 3, 2021 Share Posted December 3, 2021 Here is what I was able to get. I hope this helpful. Please let me know if you are looking for something different. For PostgreSQL: PSTCONNAME PSTFETCHSIZE PSTINSERTSIZ PSTABORTRPT PSTSQLTAG For MySQL: same as above, only the names start with MYS. Also, the global variables: SQLENGINE SQLAPT ROWSAFFECTED SQLSCRIPT Only the 1st three PST or MYS variables have FOC message numbers: FOC1697 FOC1491 FOC1531 Link to comment Share on other sites More sharing options...
Toby Mills Posted December 4, 2021 Author Share Posted December 4, 2021 Also, the global variables: SQLENGINE SQLAPT ROWSAFFECTED SQLSCRIPT Those are probably handy! I didnt see them while rooting around. Im curious what &SQLSCRIPT will show. Ill go look. Thanks Toby Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now