Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

At one point, we used to document all the names of variables...


Toby Mills

Recommended Posts

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

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

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

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

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

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

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...