RE: [U2] Dataflo Unidata TCL and the INV file
bruce I think this is what you want LIST INV '302618''302618' F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... Regards graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Friday, January 12, 2007 3:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dataflo Unidata TCL and the INV file Hi, Anybody familiar with Dataflo running on Unidata? I'm tryng to view a list of records from INV am having trouble with my TCL. What queries I've tried only return partial info. What I need is a combination of the info returned by the two queries below: *** INV query *** LIST INV WITH F0 = 302618 F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK SV VR 1 record listed INV,SV query LIST INV,SV WITH F0 = 302618 F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 14. 67C 1. 44B 1 record listed *** i.e. What I want to see is this: INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK 14. 67C SV 1. 44B VR 1 record listed ** Can somebody show me how to query INV correctly? Thanks, Bruce Ordway Viking Engineering P.S. I find INV to be the most confusing part of my MV world. I'd like to hear any insights/comments on INV. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dataflo Unidata TCL and the INV file
Bruce Sorry miss read your email - as Kevin said I think you have a multi level file. Not sure but you probably best using an itype with some basic code to get what you need. Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 12, 2007 4:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Dataflo Unidata TCL and the INV file bruce I think this is what you want LIST INV '302618''302618' F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... Regards graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Friday, January 12, 2007 3:58 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dataflo Unidata TCL and the INV file Hi, Anybody familiar with Dataflo running on Unidata? I'm tryng to view a list of records from INV am having trouble with my TCL. What queries I've tried only return partial info. What I need is a combination of the info returned by the two queries below: *** INV query *** LIST INV WITH F0 = 302618 F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK SV VR 1 record listed INV,SV query LIST INV,SV WITH F0 = 302618 F4 F9 F8 INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 14. 67C 1. 44B 1 record listed *** i.e. What I want to see is this: INV... INVENTORY CODE. BIN QUANTITY... BIN LOCATION... 302618 SK 14. 67C SV 1. 44B VR 1 record listed ** Can somebody show me how to query INV correctly? Thanks, Bruce Ordway Viking Engineering P.S. I find INV to be the most confusing part of my MV world. I'd like to hear any insights/comments on INV. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata v6 into SQL 2005
Thanks to Angelo and Adrian for replies, probably going to use mv.net (core objects) with a Unidata trigger. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Merrall Sent: Thursday, November 09, 2006 8:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Unidata v6 into SQL 2005 Graham, Next dilemma is how to get really time updates from Unidata into SQL. I was thinking about adding a trigger to the Unidata file which execute a SQL command to update the SQL database? Very grateful for any advice on how anyone else has achieved really time updates from Unidata to another database. I'm not sure if anyone has achieved real time as opposed to near time. The problem with putting the update into a trigger is you are tying the SQL update to your regular transaction and potentially slowing it down as well as all the error handling and recovery issues (what to do when one system is down and your updates need to queue.). AFAIK A more common approach is to use the triggers to update a UDT file of updates to go to SQL and then have a phantom or cron poll this and process them. By working around timing etc., you should be able to get your lag pretty low. The cron process can use just about whatever transmission procedure you like. From experience, make sure you have procedures to handle one or other servers being down, lost updates, clearing queues, regenerating messages, logging and status checking. It would be interesting to see where common consensus is at now as the above was the common practice a few years back when we set it up. Reviewing it is on my to-do list. HTH, Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Unidata v6 into SQL 2005
I have resolved the 200 character problem by splitting the field into MV. Next dilemma is how to get really time updates from Unidata into SQL. I was thinking about adding a trigger to the Unidata file which execute a SQL command to update the SQL database? Very grateful for any advice on how anyone else has achieved really time updates from Unidata to another database. Thanks Graham Forbes -Original Message- From: Forbes,G,Graham,JGFT C Sent: Wednesday, November 08, 2006 12:53 PM To: 'u2-users@listserver.u2ug.org' Subject: Unidata v6 into SQL 2005 Hello all Has anyone experienced problems importing data from Unidata into SQL 2005 using the IBM ODBC driver 3.01? I have a problem with text being truncated at 200 characters and the import hanging on certain records. Has anyone tried using Redback OLE DB? Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata v6 into SQL 2005
Hello all Has anyone experienced problems importing data from Unidata into SQL 2005 using the IBM ODBC driver 3.01? I have a problem with text being truncated at 200 characters and the import hanging on certain records. Has anyone tried using Redback OLE DB? Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Optio version 6.3 with colour
Hello all Does anyone have any tips on how to get Optio version 6.3 to print a colour image? I have tried ps device's and tiff images, but still appear in BW. Thanks for any help, Graham Forbes --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] BCI Connect
Does anyone know if I can call a SQL stored procedure using the SQLExecDirect command? Thanks Graham Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20 7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20 7177 | E: [EMAIL PROTECTED] | www.bt.com/globalservices -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Sunday, January 02, 2005 11:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect A couple of small things. You didn't need SQLNumResultCols, because you already knew - from your SELECT statement - that there would be three columns in the result set. And you didn't need to unbind variables; this will happen anyway when you use SQLFreeStmt with SQL.DROP as the second argument. I would have liked to have seen your CHECK.STATUS subroutine; this is usually the critical part. Similarly, your main (fetch) loop does not exit on error - you really want it to do so. ErrCode = SQLFetch(hStmt) LOOP WHILE ErrCode SQL.NO.DATA.FOUND AND ErrCODE SQL.ERROR CRT SQLDATA(1) : : SQLDATA(2) : : SQLDATA(3) ErrCode = SQLFetch(hStmt) REPEAT IF ErrCode = SQL.ERROR THEN GOSUB CHECK.STATUS Hope this helps; I've deliberately top-posted so that you can compare what I've suggested with your admittedly working code. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect Date: Fri, 31 Dec 2004 07:55:00 - Ray Richard Thanks for you reply. Here is my code which works, but would appreciate if you could cast a quick eye over it. 029: * use Unidata Connect to get data from Siebel 030: $INCLUDE DEMOINCLUDE ODBC.H 031: 032: * setup connect parameters 033: datasource=SIEBELTEST 034: username=SIEBEL_READ_ONLY 035: passwd=PASSWORD 036: STATUS = SQLAllocEnv(database.env) 037: * 038: MODULE = ESTABLISH.BCI 039: ENVTYPE = Database 040: Fn = SQLAllocEnv 041: GOSUB CHECK.STATUS 042: * 043: * Step 2 - Allocate Connection Environment 044: * 045: * 046: STATUS = SQLAllocConnect(database.env,connection.env) 047: * 048: ENVTYPE = Connection 049: fn = SQLAllocConnect 050: GOSUB CHECK.STATUS 051: * 052: * 053: * 054: 055: * Step 3 - Connecting to Database 056: * 057: * 058: STATUS = SQLConnect(connection.env, datasource, username, passwd) 059: * 060: ENVTYPE = Connection 061: GOSUB CHECK.STATUS 062: * 063: ALLOC.STATEMENT.ENV: 064: * 065: * --- 066: 067: * Step 4 - Allocate Statement Environment 068: * The Statement Environment is used when executing SQL 069: * statement functions 070: * 071: * 072: STATUS = SQLAllocStmt(connection.env,statement.env) 073: * 074: MODULE = ALLOC.statement.env 075: Fn = SQLAllocStmt 076: ENVTYPE = Connection 077: GOSUB CHECK.STATUS 078: 079: SQLSTATEMENT=SELECT ROW_ID AS ACCNT_ROW_ID, NAME AS ACCOUNT_NAME, LOC AS ACCOUNT_LOC FROM SIEBEL.S_ORG_EXT WHERE X_BTS_BUSINESS_UNIT = 'Financial Servic es' AND X_BTS_SECTOR = 'Trading Systems' 080: 081: STATUS = SQLExecDirect(statement.env, SQLSTATEMENT) 082: 083: STATUS = SQLNumResultCols (statement.env, cols) 084: 085: DIM SQLDATA(cols) 086: FOR NUMCOL=1 TO cols 087: SQL.STATUS = SQLBindCol(statement.env,NUMCOL,SQL.B.DEFAULT, SQLDATA(NUMCO L)) 088: NEXT NUMCOL 089: 090: STATUS = 0 091: Fn = SQLFetch 092: ENVTYPE = Statement 093: 094: LOOP *--: P 095: WHILE STATUS SQL.NO.DATA.FOUND DO 096: * 097: * 098: STATUS = SQLFetch(statement.env) 099: * 100: GOSUB CHECK.STATUS 101: IF STATUS SQL.NO.DATA.FOUND THEN 102: FOR NUMCOL=1 TO cols 103: CRT SQLDATA(NUMCOL): : 104: NEXT NUMCOL 105: CRT 106: END 107: REPEAT 108: * 109: ENVTYPE = Statement 110: GOSUB CHECK.STATUS 111: 112: 113: * that it, discount from the server 114: STATUS = SQLFreeStmt(statement.env, SQL.UNBIND) 115: STATUS = SQLFreeStmt(statement.env, SQL.DROP) 116: STATUS = SQLDisconnect(connection.env) 117: STATUS = SQLFreeConnect(connection.env) 118: STATUS = SQLFreeEnv(database.env) 119: CRT Finished 120: STOP *--: Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: 31 December 2004 06:02 To: u2-users@listserver.u2ug.org Subject: Re: [U2] BCI Connect Source code for the CONNECT verb is supplied. Track it down and take a look at it. The steps are as follows. You should check for, and clear, errors at every step. Seriously. ODBC simply does not function with dirty handles. 1. Allocate ODBC environment (SQLAllocEnv) 2. Allocate connection environment (SQLAllocConnect) 3. Connect to Oracle database (SQLConnect) (optional) discover information about connection (SQLTables, etc.) 4. Construct SELECT statement. 5. If SELECT
RE: [U2] BCI Connect
Angelo No, Unidata on Windows to SQL 2005. I haven't tried it yet, but when I do I will post an example here. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 28, 2006 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect Graham, By any chance are you doing BCI via UNIX? Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 2:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect Does anyone know if I can call a SQL stored procedure using the SQLExecDirect command? Thanks Graham Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20 7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20 7177 | E: [EMAIL PROTECTED] | www.bt.com/globalservices -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Sunday, January 02, 2005 11:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect A couple of small things. You didn't need SQLNumResultCols, because you already knew - from your SELECT statement - that there would be three columns in the result set. And you didn't need to unbind variables; this will happen anyway when you use SQLFreeStmt with SQL.DROP as the second argument. I would have liked to have seen your CHECK.STATUS subroutine; this is usually the critical part. Similarly, your main (fetch) loop does not exit on error - you really want it to do so. ErrCode = SQLFetch(hStmt) LOOP WHILE ErrCode SQL.NO.DATA.FOUND AND ErrCODE SQL.ERROR CRT SQLDATA(1) : : SQLDATA(2) : : SQLDATA(3) ErrCode = SQLFetch(hStmt) REPEAT IF ErrCode = SQL.ERROR THEN GOSUB CHECK.STATUS Hope this helps; I've deliberately top-posted so that you can compare what I've suggested with your admittedly working code. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] BCI Connect Date: Fri, 31 Dec 2004 07:55:00 - Ray Richard Thanks for you reply. Here is my code which works, but would appreciate if you could cast a quick eye over it. 029: * use Unidata Connect to get data from Siebel 030: $INCLUDE DEMOINCLUDE ODBC.H 031: 032: * setup connect parameters 033: datasource=SIEBELTEST 034: username=SIEBEL_READ_ONLY 035: passwd=PASSWORD 036: STATUS = SQLAllocEnv(database.env) 037: * 038: MODULE = ESTABLISH.BCI 039: ENVTYPE = Database 040: Fn = SQLAllocEnv 041: GOSUB CHECK.STATUS 042: * 043: * Step 2 - Allocate Connection Environment 044: * 045: * 046: STATUS = SQLAllocConnect(database.env,connection.env) 047: * 048: ENVTYPE = Connection 049: fn = SQLAllocConnect 050: GOSUB CHECK.STATUS 051: * 052: * 053: * 054: 055: * Step 3 - Connecting to Database 056: * 057: * 058: STATUS = SQLConnect(connection.env, datasource, username, passwd) 059: * 060: ENVTYPE = Connection 061: GOSUB CHECK.STATUS 062: * 063: ALLOC.STATEMENT.ENV: 064: * 065: * --- 066: 067: * Step 4 - Allocate Statement Environment 068: * The Statement Environment is used when executing SQL 069: * statement functions 070: * 071: * 072: STATUS = SQLAllocStmt(connection.env,statement.env) 073: * 074: MODULE = ALLOC.statement.env 075: Fn = SQLAllocStmt 076: ENVTYPE = Connection 077: GOSUB CHECK.STATUS 078: 079: SQLSTATEMENT=SELECT ROW_ID AS ACCNT_ROW_ID, NAME AS ACCOUNT_NAME, LOC AS ACCOUNT_LOC FROM SIEBEL.S_ORG_EXT WHERE X_BTS_BUSINESS_UNIT = 'Financial Servic es' AND X_BTS_SECTOR = 'Trading Systems' 080: 081: STATUS = SQLExecDirect(statement.env, SQLSTATEMENT) 082: 083: STATUS = SQLNumResultCols (statement.env, cols) 084: 085: DIM SQLDATA(cols) 086: FOR NUMCOL=1 TO cols 087: SQL.STATUS = SQLBindCol(statement.env,NUMCOL,SQL.B.DEFAULT, SQLDATA(NUMCO L)) 088: NEXT NUMCOL 089: 090: STATUS = 0 091: Fn = SQLFetch 092: ENVTYPE = Statement 093: 094: LOOP *--: P 095: WHILE STATUS SQL.NO.DATA.FOUND DO 096: * 097: * 098: STATUS = SQLFetch(statement.env) 099: * 100: GOSUB CHECK.STATUS 101: IF STATUS SQL.NO.DATA.FOUND THEN 102: FOR NUMCOL=1 TO cols 103: CRT SQLDATA(NUMCOL): : 104: NEXT NUMCOL 105: CRT 106: END 107: REPEAT 108: * 109: ENVTYPE = Statement 110: GOSUB CHECK.STATUS 111: 112: 113: * that it, discount from the server 114: STATUS = SQLFreeStmt(statement.env, SQL.UNBIND) 115: STATUS = SQLFreeStmt(statement.env, SQL.DROP) 116: STATUS = SQLDisconnect(connection.env) 117: STATUS = SQLFreeConnect(connection.env) 118: STATUS = SQLFreeEnv(database.env) 119: CRT Finished 120: STOP *--: Graham Forbes
RE: [U2] Unidata 6 into SQL 2005
Steve Interesting that you didn't use ODBC to move the data directly out of Unidata? In the DTS script you can use CONVERT or CAST to change the data type. Eg: SELECT CAST(COMPANY AS varchar(3)) AS Company, Project, CAST(ProjectName AS varchar(60)) AS ProjectName, CONVERT(char(10), EndDate, 101) AS EndDate FROM dbo.US_eTimeProjectLoad CONVERT(length,source,type) Regards Graham Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20 7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20 7177 | E: [EMAIL PROTECTED] | www.bt.com/globalservices -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 22, 2006 5:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 We have a homegrown process where a cron job runs a nightly script that calls basic programs which create comma-delimited text files. Then a windows server runs a scheduled task to ftp the files to that server. Then a DTS script loads the SQL tables with the data. The problem is that the user wants us to type the data (dates mostly). Is there a way to do this with our current process? Thanks in advance. Steve Kunzman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, June 22, 2006 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 [ad] Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and
RE: [U2] Unidata 6 into SQL 2005 - connection string
Angelo Thanks for this - I have now loaded a new ODBC driver. In SQL 2005 you need to build the connection string (I am using the .net framework Data Provider for ODBC). Here is what I have at the moment: Driver={IBM UniData ODBC Driver};provider=Ardent.UniOLEDB;data source=servername;location=databasename;user id=odbc;password=password Does anyone have a successful connection string which works with SQL 2005 SSIS? Thanks graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 4:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata 6 into SQL 2005
Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC text field
I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC text field
Sorry, I am on Unidata and I am trying to return as a single value text field rather than normalise. Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, April 27, 2005 1:08 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC text field Graham I'm assuming that you mean to return the multivalued field as a single valued text field. If your are on UniVerse (you don't say) try the following ITYPE expression: CONVERT(@VM:@SVM, , OCONV(@RECORDn,MCP)) Where 'n' is the field number of the field to return. Also make sure field 6 is set to S Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 April 2005 10:24 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC text field I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RedBack Performance
Guess you have checked the .ini files which specifies if the responder stays up - state 1 or 2 I think? Graham Forbes Trading Systems BT Consulting Systems Integration tel: (+44) (0)20 7176 fax: (+44) (0)20 7177 mob: (+44) (0)77407 38550 web: www.bt.com/consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 15 February 2005 14:06 To: u2-users@listserver.u2ug.org Subject: [U2] RedBack Performance Hi all, I'm on a site doing some work enhancing a web site running RedBack. Except that is not running: it is crawling, and I've never seen RedBack so slow. Their server *is* fairly slow and old (running 9.2 uv on AIX) but on top of the time taken to actually run the subroutines, it seems that virtually every method call seems to add an extra 2 seconds overhead, so the cumulative effect is horrible. It's not their web server: I've pointed the same web server to a dev account on my laptop and it flies. Same RBOs, same code. No delays. I've also checked the other direction: running a gateway and IIS on my laptop to access their uv server. Slow. So it isn't anything specific to networking between their web server and uv server. They are running RedBack 3.5.x. Does anyone recall any performance issues/fixes around that time? Helpfully, the performance monitoring option doesn't work. Any help greatly appreciated. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] [UV] Run phantom as another user
Thanks Mike and David, found out the problem only happens when I call from RedBack. Oracle is running on Unix and I have the connection user name and password embedded in my Unidata code. Not sure why it doesn't work from RedBack responder, but got around problem by have a batch file which runs the routine. Thanks for your help, Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: 25 January 2005 22:41 To: u2-users@listserver.u2ug.org Subject: Unclassified RE: [U2] [UV] Run phantom as another user Graham, For David's very good idea to work, you must not be using NT Authentication for the ODBC Connection that the BCI is using. [You did not say what O/S the Oracle host is running]. If the Oracle host is a Windows box, and the ODBC connection is using NT Authentication, it will ignore whatever UID Password you pass in, and use the credentials of the user issuing the request. If you are not using NT Authentication, I suggest you should use the UniBasic encryption / decryption functions to store the password encrypted on disk, not in plain text in the code of the program [apologies if 'teaching Grandma to suck eggs']. Note that you can run a SQL Stored Procedure [via SQLExecuteDirect rather than SQLExecute], which might enable you to do all you want. HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Wednesday, 26 January 2005 10:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user You can make an SQL call to a subroutine on a remote server. You can set the SQL Connect statement with a different user name and password. Bind the Parameters for the Subroutine and then Call it. The code below may give you some idea. Regards David Jordan 0019: UID = USERNAME 0020: PWD = PASSWORD 0021: SOURCE = FCSHOST 0022: PRINT Connecting to Computer: : 0023: Fn = SQLConnect ... 0027: STATUS = SQLSetConnectOption(CONENV, SQL.OS.UID, UID) 0028: STATUS = SQLSetConnectOption(CONENV, SQL.OS.PWD, PWD) 0029: PRINT Connecting to data source: : SOURCE 0030: STATUS = SQLConnect(CONENV,SOURCE,PATHNAME,) 0042: Fn = SQLBindParameter 0043: *status = SQLBindParameter (statement.env, mrk#, data.type, sql.type, prec, scale,param [,param.type]) 0044: STATUS = SQLBindParameter(STMTENV,1,SQL.B.BASIC,SQL.CHAR,0,0,CLIENT.NO,SQL.PARAM. INPU T) 0045: GOSUB CKSTMTENV .. 0055: STATUS = SQLExecute(STMTENV) 0056:IF STATUS SQL.SUCCESS THEN RETURN 0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 26 January 2005 5:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy ord istribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
Windows 2000, tested running routine as another user and works ok, only seems to fail when being run from Redback phantom, even though I have started the redback phantom? Tested from a 'normal' phantom and it works OK. Any thoughts on what's different from RedBack responder to phantom in Unidata? Thanks Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Beel Sent: 25 January 2005 20:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user If you are on a unix box you should be able to run a cron daemon. Lee [EMAIL PROTECTED] 01/25/05 10:09AM I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
Sorry, should have said I am using BCI Connect SQL to extract data from an Oracle database into Unidata. Works as me, but not when executed from a RedBack phantom which has been started by someone else. Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: 25 January 2005 18:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Why not GRANT the other user access to whatever it is? And if you are using Redback, why do you need SQL anyway? ADO? Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC - Capture Select
Have you tried switching on logging (I think you can specify client and or server). Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vincent MASSON Sent: 20 January 2005 09:11 To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODBC - Capture Select Dear all, Is there a way to capture the sql statement sent to Universe through an ODBC connection ? I'm using a tool to build queries (like Business Object) but I can't see the SELECT statement it builds. Any idea ? Thanks, Vincent MASSON mailto:[EMAIL PROTECTED] Infodata Sarl http://www.infodata.lu Tel : (352) 33 16 48 Fax : (352) 33 75 55 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unidata bci commands not compiling
I am successfully using BCI connect from Unidata 6. See code example : Note - when I compile I need to use the -I option. 029: * use Unidata Connect to get data from Siebel 030: $INCLUDE DEMOINCLUDE ODBC.H 031: 032: * setup connect parameters 033: datasource=SIEBELTEST 034: username=SIEBEL_READ_ONLY 035: passwd=PASSWORD 036: STATUS = SQLAllocEnv(database.env) 037: * 038: MODULE = ESTABLISH.BCI 039: ENVTYPE = Database 040: Fn = SQLAllocEnv 041: GOSUB CHECK.STATUS 042: * 043: * Step 2 - Allocate Connection Environment 044: * 045: * 046: STATUS = SQLAllocConnect(database.env,connection.env) 047: * 048: ENVTYPE = Connection 049: fn = SQLAllocConnect 050: GOSUB CHECK.STATUS 051: * 052: * 053: * 054: 055: * Step 3 - Connecting to Database 056: * 057: * 058: STATUS = SQLConnect(connection.env, datasource, username, passwd) 059: * 060: ENVTYPE = Connection 061: GOSUB CHECK.STATUS 062: * 063: ALLOC.STATEMENT.ENV: 064: * 065: * --- 066: 067: * Step 4 - Allocate Statement Environment 068: * The Statement Environment is used when executing SQL 069: * statement functions 070: * 071: * 072: STATUS = SQLAllocStmt(connection.env,statement.env) 073: * 074: MODULE = ALLOC.statement.env 075: Fn = SQLAllocStmt 076: ENVTYPE = Connection 077: GOSUB CHECK.STATUS 078: 079: SQLSTATEMENT=SELECT ROW_ID AS ACCNT_ROW_ID, NAME AS ACCOUNT_NAME, LOC AS ACCOUNT_LOC FROM SIEBEL.S_ORG_EXT WHERE X_BTS_BUSINESS_UNIT = 'Financial Servic es' AND X_BTS_SECTOR = 'Trading Systems' 080: 081: STATUS = SQLExecDirect(statement.env, SQLSTATEMENT) 082: 083: STATUS = SQLNumResultCols (statement.env, cols) 084: 085: DIM SQLDATA(cols) 086: FOR NUMCOL=1 TO cols 087: SQL.STATUS = SQLBindCol(statement.env,NUMCOL,SQL.B.DEFAULT, SQLDATA(NUMCO L)) 088: NEXT NUMCOL 089: 090: STATUS = 0 091: Fn = SQLFetch 092: ENVTYPE = Statement 093: 094: LOOP *--: P 095: WHILE STATUS SQL.NO.DATA.FOUND DO 096: * 097: * 098: STATUS = SQLFetch(statement.env) 099: * 100: GOSUB CHECK.STATUS 101: IF STATUS SQL.NO.DATA.FOUND THEN 102: FOR NUMCOL=1 TO cols 103: CRT SQLDATA(NUMCOL): : 104: NEXT NUMCOL 105: CRT 106: END 107: REPEAT 108: * 109: ENVTYPE = Statement 110: GOSUB CHECK.STATUS 111: 112: 113: * that it, discount from the server 114: STATUS = SQLFreeStmt(statement.env, SQL.UNBIND) 115: STATUS = SQLFreeStmt(statement.env, SQL.DROP) 116: STATUS = SQLDisconnect(connection.env) 117: STATUS = SQLFreeConnect(connection.env) 118: STATUS = SQLFreeEnv(database.env) 119: CRT Finished 120: STOP Graham Forbes Trading Systems BT Consulting Systems Integration tel: (+44) (0)20 7176 mob: (+44) (0)77407 38550 web: www.bt.com/consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 15 January 2005 20:16 To: u2-users@listserver.u2ug.org Subject: RE: [U2] unidata bci commands not compiling There's never any harm in stating the obvious. People should do it more often. My problem is on unidata, not universe, so there is no UNIVERSE.INCLUDE or BCI.H (mentioned in another response). There's an ODBC.H in INCLUDE though, and unfortunately I've already included it and successfully used equates from it in other bci functions. No help there. The compiler still seems to think I'm referencing an unDIMed array with too many dimensions. There's a sample program in the back of the unidata bci manual (available at http://publibfi.boulder.ibm.com/epubs/pdf/25124330.pdf), and on page B-8 they demonstrate the SQLBindParameter function. Apparently the code printed in the manual was never entered into a real computer and tested, because there is no closing parenthesis on the function call (on any one of the four examples). I also get the same result using the unidata PE on redhat. I think that's version 6.0 as well. Is there anyone out there who has ever used SQLBindParameter on unidata 6.0, or on any version of unidata? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, January 14, 2005 11:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unidata bci commands not compiling Hi It might be stating the obvious, but it has caught me once or twice, did you include $INCLUDE UNIVERSE.INCLUDE ODBC.H at the beginning of the program. I have used this in UniVerse for years, the problem maybe using a wrong parameter code. The following is from some of my code ST=SQLBindParameter(STMTENV,1,SQL.B.BASIC,SQL.CHAR,0,0,CLIENT. NO,SQL.PARAM.I NPUT) Hope it gives you some ideas to try. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Clark Sent: Saturday, 15 January 2005 8:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] unidata bci commands not compiling I'm attempting to use BCI on unidata
RE: [U2] BCI Connect
Ray Richard Thanks for you reply. Here is my code which works, but would appreciate if you could cast a quick eye over it. 029: * use Unidata Connect to get data from Siebel 030: $INCLUDE DEMOINCLUDE ODBC.H 031: 032: * setup connect parameters 033: datasource=SIEBELTEST 034: username=SIEBEL_READ_ONLY 035: passwd=PASSWORD 036: STATUS = SQLAllocEnv(database.env) 037: * 038: MODULE = ESTABLISH.BCI 039: ENVTYPE = Database 040: Fn = SQLAllocEnv 041: GOSUB CHECK.STATUS 042: * 043: * Step 2 - Allocate Connection Environment 044: * 045: * 046: STATUS = SQLAllocConnect(database.env,connection.env) 047: * 048: ENVTYPE = Connection 049: fn = SQLAllocConnect 050: GOSUB CHECK.STATUS 051: * 052: * 053: * 054: 055: * Step 3 - Connecting to Database 056: * 057: * 058: STATUS = SQLConnect(connection.env, datasource, username, passwd) 059: * 060: ENVTYPE = Connection 061: GOSUB CHECK.STATUS 062: * 063: ALLOC.STATEMENT.ENV: 064: * 065: * --- 066: 067: * Step 4 - Allocate Statement Environment 068: * The Statement Environment is used when executing SQL 069: * statement functions 070: * 071: * 072: STATUS = SQLAllocStmt(connection.env,statement.env) 073: * 074: MODULE = ALLOC.statement.env 075: Fn = SQLAllocStmt 076: ENVTYPE = Connection 077: GOSUB CHECK.STATUS 078: 079: SQLSTATEMENT=SELECT ROW_ID AS ACCNT_ROW_ID, NAME AS ACCOUNT_NAME, LOC AS ACCOUNT_LOC FROM SIEBEL.S_ORG_EXT WHERE X_BTS_BUSINESS_UNIT = 'Financial Servic es' AND X_BTS_SECTOR = 'Trading Systems' 080: 081: STATUS = SQLExecDirect(statement.env, SQLSTATEMENT) 082: 083: STATUS = SQLNumResultCols (statement.env, cols) 084: 085: DIM SQLDATA(cols) 086: FOR NUMCOL=1 TO cols 087: SQL.STATUS = SQLBindCol(statement.env,NUMCOL,SQL.B.DEFAULT, SQLDATA(NUMCO L)) 088: NEXT NUMCOL 089: 090: STATUS = 0 091: Fn = SQLFetch 092: ENVTYPE = Statement 093: 094: LOOP *--: P 095: WHILE STATUS SQL.NO.DATA.FOUND DO 096: * 097: * 098: STATUS = SQLFetch(statement.env) 099: * 100: GOSUB CHECK.STATUS 101: IF STATUS SQL.NO.DATA.FOUND THEN 102: FOR NUMCOL=1 TO cols 103: CRT SQLDATA(NUMCOL): : 104: NEXT NUMCOL 105: CRT 106: END 107: REPEAT 108: * 109: ENVTYPE = Statement 110: GOSUB CHECK.STATUS 111: 112: 113: * that it, discount from the server 114: STATUS = SQLFreeStmt(statement.env, SQL.UNBIND) 115: STATUS = SQLFreeStmt(statement.env, SQL.DROP) 116: STATUS = SQLDisconnect(connection.env) 117: STATUS = SQLFreeConnect(connection.env) 118: STATUS = SQLFreeEnv(database.env) 119: CRT Finished 120: STOP *--: Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: 31 December 2004 06:02 To: u2-users@listserver.u2ug.org Subject: Re: [U2] BCI Connect Source code for the CONNECT verb is supplied. Track it down and take a look at it. The steps are as follows. You should check for, and clear, errors at every step. Seriously. ODBC simply does not function with dirty handles. 1. Allocate ODBC environment (SQLAllocEnv) 2. Allocate connection environment (SQLAllocConnect) 3. Connect to Oracle database (SQLConnect) (optional) discover information about connection (SQLTables, etc.) 4. Construct SELECT statement. 5. If SELECT statement includes parameter markers (?) bind variables to each (SQLBindParameter). 6. Allocate statement environment (SQLAllocStmt) 7. Either: (a) send SQL statement to be prepared (SQLPrepare) and executed (SQLExecute) (b) send SQL statement to be executed directly (SQLExecDirect) 8. If you don't already know how many columns there are in the result set (e.g. SELECT * FROM ...) find out (SQLNumResultCols). 9. Bind a variable to each result set column (SQLBindCol). 10. Loop calling (SQLFetch), which returns one result row, until its status is SQL.NO.DATA.FOUND. 11. The value from each column is in the relevant bound variable. Do whatever with these. 12. Now that the loop's finished: (a) Free the statement environment (SQLFreeStmt) (b) Disconnect from the Oracle server (SQLDisconnect) (c) Free the connection environment (SQLFreeConnect) (d) Free the ODBC environment (SQLFreeEnv) Simple, innit? - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] BCI Connect Date: Thu, 30 Dec 2004 13:30:39 - Hello all I am trying to extract data from an Oracle Database from Unidata. I have read through the BCI Connect manual and it looks fairly simple using the Connect command, but much more complicated using directly within Unibasic. Does anyone have a simple example of executing a SQL statement and returning the results into either a Unidata file or reading each row? If I do not want to update should I just datastack and use the CONNECT command? Thanks Graham Graham Forbes Trading
[U2] BCI Connect
Hello all I am trying to extract data from an Oracle Database from Unidata. I have read through the BCI Connect manual and it looks fairly simple using the Connect command, but much more complicated using directly within Unibasic. Does anyone have a simple example of executing a SQL statement and returning the results into either a Unidata file or reading each row? If I do not want to update should I just datastack and use the CONNECT command? Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Media Charge
I am interested if other users of Universe are charged a media charge for upgrades from VAR's. My client is already paying a maintenance charge to the VAR (for Universe and an application support charge) and the VAR charges to perform the upgrade. Thanks, Graham This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.btsyntegra.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC failing
I have a link table in Access 2002 which connects to Unidata 6 (on W2000) using odbc. When I run the query, I can scroll through a few pages, and then Access hangs. I cannot identify which record is causing the problem. I have checked the file using GUIDE and it reports no problems. From UNIDATA I did a SELECT * FROM viewname ; in a SQL session it if scrolled through the file without a problem. Does anyone know what characters can cause ODBC to fail? Thanks v much. Graham Forbes This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.btsyntegra.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/