OS/2 Professional Developers Kit 1992 November

home *** CD-ROM | disk | FTP | other *** search

/ OS/2 Professional Developers Kit 1992 November / Disc01 / Disc01.mdf / os2bbs / os2dbm.cfo < prev next >

Wrap

Text File | 1992-10-31 | 233.5 KB | 5,675 lines

This forum is supplied for demonstration purposes only and is accessible via the IBM OS/2 BBS system. What you see below is the forum as it existed on 10/30/92. The IBM OS/2 Bulletin Board System (BBS) is IBM's new electronic support offering for OS/2 Version 2.0. With OS/2 BBS you can electronically review OS/2 technical information, submit program defects to IBM, and receive information on how to solve problems. Users of the OS/2 BBS not only include OS/2 customers, but the OS/2 expertise of the entire internal IBM community worldwide. OS2BBS makes all this available via a local or toll free number in most major cities. To request a complete OS/2 BBS Information Package detailing the OS/2 BBS offering and including pricing and registration/access information, please call: 1-800-547-1283. ===== OS2DBM CFORUM created at 01:49:38 on 92/04/08 GMT (by HOPKINS at AUSVM8) IBM UNCLASSIFIED ---------------- The information in this forum is considered by IBM to be external and may be shared by everyone who is given access. This forum is shared with the internal IBM employee conferences. Forum: OS2DBM CFORUM Forum subject: OS/2 Extended Services for Database Manager This FORUM is provided as a conferencing tool to promote discussion regarding the installation, customization and use of OS/2 Extended Services for Database Manager and present issues, questions, and problems encountered during the use of Database Manager for ES. Contributions must not contain confidential or proprietary information. Each contributor agrees, in placing material in this forum, that IBM and other users are free to prepare derivative works based upon it, and to use, reproduce, perform, display and distribute inside and outside their company such material and such derivative works, without obligation or charge. IBM is not responsible or liable for the use, copying, or distribution of materials placed on this forum, and has therefore no obligation to control such acts. All subscribers are required to abide at all times by the conference rules described in the Bulletin Board Rules under "News and Announcements". All IBM personnel are required to abide at all times by the IBMPC RULES and the IBM Business Conduct Guidelines. IBM personnel will read the CUSTOMER FORUM RULES in IBMPC RULES before contributing. Contributions violating these rules will be deleted by the CFORUM Owner or their delegate, and in some cases by an IBM conference Administrator. The OS2BBS CFORUM is where anyone may raise concerns regarding rules violations found in this and other CFORUMS. The IBM Owner of this forum is: Name: Kenneth M. Hopkins, OS/2 Support Services Mailing Address: IBM Manufacturing and Development 11400 Burnet Road Internal Zip 2900-042/1D003 Austin, Texas 78758 IBM Node/Userid: AUSVM8/HOPKINS ..... 4952 lines pruned at 06:01:39 on 92/10/16 GMT (by HOPKINS at AUSVM8) ..... ----- OS2DBM CFORUM appended at 22:57:59 on 92/07/31 GMT (by DGODOM at LSAVMIC4) Subject: Time to import 1M+ rows increases exponentially Ref: Append at 21:31:03 on 92/07/31 GMT (by UBIQUITY at AUSVM1) Richard, Interesting information about the internal operation of OS2 DBM. After all the talk about DBM being a direct copy of DB2, it seems, in this instance at least, that DBM operates more like SQL/DS. All right! It does seem to be more logical to create indexes after the data is loaded, not during. Thanks for the insight. Take care, Dave Odom Relational Database Specialist Application Enabling Practice Arizona Management Consulting Tucson, AZ ----- OS2DBM CFORUM appended at 18:26:31 on 92/08/01 GMT (by IL36792 at OS2CUST) Subject: SQL String Concat Is there a string/substring concatenation facility in OS2 2.0 ES DBM similar to the "||" capability in OS/400 SQL? If not, how do we change portions of strings? An example is the following: UPDATE MYTABLE SET NAME='Mr. '||SUBSTR(NAME,8) WHERE NAME LIKE 'Mister%' changes title 'Mister' to 'Mr. ' in the name field. ----- OS2DBM CFORUM appended at 04:17:50 on 92/08/03 GMT (by CJNUSSE at DALVMIC6) Subject: SQL1042N - Unexpected System Error Ref: Append at 04:17:35 on 92/07/28 GMT (by CHALTAIN at FSHVMFK1) This sounds almost identical to a problem that I had after upgrading a 1.3 standalone database to Extended Services. I also reinstalled several times, to no avail, so I called the IBM Service number. They sent me a utility called RESETLOG, which is really for this error if you get it at a START USING database, not a STARTDBM. Since that didn't work, they recommended I try to reformat the disk. I really didn't want to do that, so they forwarded the problem to a database developer. He had me check to ensure that I had a net.acc on my disk, which I did. Then he had me unpack a new net.acc from the install disks. With a new net.acc, STARTDBM worked with no problems. Obviously, when you do this, you lose all your UPM userid definitions, but it was a corrupted net.acc causing all the problems. If you have a backup of a good net.acc, you might try that before unpacking a new one. Hope this helps, Connie Nusser Heartland Trading Area Services Center 8/672-6637 ----- OS2DBM CFORUM appended at 14:09:29 on 92/08/03 GMT (by UBIQUITY at AUSVM1) Subject: RDS PROCESSES Ref: Append at 22:48:44 on 92/07/31 GMT (by BOFA90 at OS2CUST) A new process model using hot processes is being looked into, but for now there is no way around the one agent process per client process requirement. Richard D. Hoffman ----- OS2DBM CFORUM appended at 14:10:53 on 92/08/03 GMT (by UBIQUITY at AUSVM1) Subject: Time to import 1M+ rows increases exponentially Ref: Append at 22:57:59 on 92/07/31 GMT (by DGODOM at LSAVMIC4) DBM was never intended as a copy of DB2, particularly at the physical level. If it resembles SQL/DS a little more at that level, it is only because of the relative simplicitly of both systems when compared to DB2. Richard D. Hoffman ----- OS2DBM CFORUM appended at 14:13:02 on 92/08/03 GMT (by UBIQUITY at AUSVM1) Subject: SQL String Concat Ref: Append at 18:26:31 on 92/08/01 GMT (by IL36792 at OS2CUST) Concatenation is not available in OS/2 DBM, but will be in a future release. There are workarounds from some applications of concatenation, but not the one you cite. Richard D. Hoffman ----- OS2DBM CFORUM appended at 14:50:36 on 92/08/03 GMT (by QSAEED at DALHQIC2) Subject:Logon dialog box by the use of UPMGLGN How can logon dialog box be brought up by using UPMGLGN? I have tried using 'USERID' and 'PASSWORD' as NULLs and thought it will force the logon screen to pop up since logon will fail. It only returns an invalid return code and I am not sure how to bring up the logon dialog box. Also, it has to be done from within the program. In reference to the same problem, I wonder how does QueryManager brings up the logon dialog box. Does anyone know??? Thanks in advance, Qaiser Saeed (TL: 421-8542) ----- OS2DBM CFORUM appended at 15:11:35 on 92/08/03 GMT (by VERSTEEG at UITVM1) Subject: Logon dialog box by the use of UPMGLGN Ref: Append at 14:50:36 on 92/08/03 GMT (by QSAEED at DALHQIC2) If you try to do a START USING DATABASE without being logged on, DBM will bring up the logon window automatically. In case you are calling DBM from a PM program, make sure you do this from a separate thread, otherwise PM cannot give focus to the logon window. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** GO OS/2 2.0 *** ----- OS2DBM CFORUM appended at 16:30:13 on 92/08/03 GMT (by CGNA106 at OS2CUST) Subject: Database manager crashing after maximizing Our team is experiencing DBM/query manager crashes when we run utilities from query manager,minimize query manager, and then maximize query manager . Once maximized, the process abends with the following: sys3175 a program generated an access violation at 197931b7 qrwq.dll 003 p1=0000010 p2=fffffff p3=xxxxxxxx p4=xxxxxxxx eax=0000000 etc...etc...etc.... Has this bug been identified, is their a fix out for this already? Steve Petruzzi ----- OS2DBM CFORUM appended at 18:15:08 on 92/08/03 GMT (by TCC3824 at OS2CUST) Subject: DBM 3rd Party Support tools Does anyone know of any 3rd party support tools for OS/2 Database Manager like the support tools available for DB2? (Platinum, BMC) Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 08:28:20 on 92/08/04 GMT (by VERSTEEG at UITVM1) Subject: DBM 3rd Party Support tools Ref: Append at 18:15:08 on 92/08/03 GMT (by TCC3824 at OS2CUST) Here are a couple of tools in that area: BACHMAN Bachman on OS/2 A5 INTERSOLV Repository Explorer A10 INVICTUS SYSTEMS CORP Data BOS 2 A7 INVICTUS SYSTEMS CORP Database Daemon -- The code on the right refers to the section in the OS/2 Application Solutions guide: G362-0002-01. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** GO OS/2 2.0 *** ----- OS2DBM CFORUM appended at 14:06:55 on 92/08/05 GMT (by CIGNA58 at OS2CUST) Subject: Cloning a Database Structure Ref: Append at 22:04:44 on 92/04/30 GMT (by XXHAYM01 at TORVMCOP) I have written a REXX procedure that does generate DDL for an entire Data Base Manager Data Base. The DDL generated, however, is in DB2 acceptable format. In other words, I generate tablespaces, storages groups, tables, indexes and referential integrity. You could easily modify this to generate DBM compatible format. Michelle Zaremskas ----- OS2DBM CFORUM appended at 20:33:48 on 92/08/05 GMT (by GSCHOI at RHQVM16) Subject: SQLCODE 1013 Have anyone experienced problem with erasing a local database due to the fact that the SQL00001 directory is in a different session. The Query Manager has cleanup all the files in SQL00001 but not removed the directory SQL00001. I try using RD afterward but not succeed. How can I clean up the database directory so I can define the database again using the same ALIAS. I have to use the same ALIAS because it comes with the product. Thank you. Grace S Choi ----- OS2DBM CFORUM appended at 22:14:30 on 92/08/05 GMT (by NAAO3IY at OS2CUST) Subject: SQLCODE 1013 Ref: Append at 20:33:48 on 92/08/05 GMT (by GSCHOI at RHQVM16) It is not logical that RD should fail on a truly empty directory. Either you have some kind of file-system problem (have you tried CHKDSK?), another session is still logged onto the directory (at the absolute worst, re-booting should fix that), or there is still something in that directory (have you tried dragging it to the shredder?). John Kennedy -- Hoechst Celanese, Bridgewater, NJ ----- OS2DBM CFORUM appended at 01:45:30 on 92/08/06 GMT (by CHALTAIN at FSHVMFK1) Subject: SQL1042N - Unexpected System Error Ref: Append at 04:17:50 on 92/08/03 GMT (by CJNUSSE at DALVMIC6) Thankyou! Thankyou! Thankyou! I too did not want to re-format my system, but everything was pointing in that direction. Your suggestion did the trick. I grabbed a NET.ACC from another machine in the office, and everything is fine! Again, thanks! Christopher J Chaltain ----- OS2DBM CFORUM appended at 13:56:54 on 92/08/06 GMT (by MJRYANT at NYCVMIC1) Subject: DOS application Enabler My customer has a OS/2 ES server, and wants his DOS applications to access databases on the ES 1.0 SErver. We are installing the DOS application enabler code on the DOS workstation. I am looking for someone who have code the program needed to catalog the database Also I need a list of product that can be used as a front end on the DOS. Please give my a call at 8-340-2764, if you can help... We are trying to get the customer up and running ASAP. Thanks... HAVE A GREAT DAY ----- OS2DBM CFORUM appended at 19:14:39 on 92/08/07 GMT (by IL04688 at OS2CUST) Subject: problem running SQLPREP We are having a problem running SQLPREP. It accepts a ".SQB" file and tries to process it, but the resulting output file is identical to the input file. This worked under OS/2 1.3. Any ideas ? Leo Tornow ----- OS2DBM CFORUM appended at 19:52:17 on 92/08/07 GMT (by IL03484 at OS2CUST) Subject: SQL30080N Using a remote database configuration, I am able to see the database listed under the Query Manager however cannot access the data whn opening the table. The message is QRW2272W, which refers to SQL30080N. Being new to this type of application, I have been looking in the manuals for information regarding remote database configuration and any other related data. And I'm missing the point as to how the import/export utility is tied in to this. Also, can you direct me where to look ON-LINE for this type of information? Tom Hobbs Bituminous Insurance Co. ----- OS2DBM CFORUM appended at 20:31:04 on 92/08/07 GMT (by UBIQUITY at AUSVM1) Subject: problem running SQLPREP Ref: Append at 19:14:39 on 92/08/07 GMT (by IL04688 at OS2CUST) It should still work. Are you sure you haven't introduced something new into the COBOL source, like a mismatched quotation mark or apostrophe? Richard D. Hoffman ----- OS2DBM CFORUM appended at 14:43:20 on 92/08/10 GMT (by TCSC121 at OS2CUST) Subject: SQLDA FLOATING POINT FORMAT I AM ATTEMPTING TO EXTRACT A FIELD THAT IS IN SCIENTIFIC FORMAT. I ISSUE AN FETCH MYCURSOR USING DESCRIPTOR :*MYSQLDA WHERE MYSQLDA->SQLVAR(I).SQLTYPE = 481 Q: WHAT DOES MYSQLDA->SQLVAR(I).SQLDATA ( UNSIGNED CHAR * ) POINT TO Q: HOW DO I DISPLAY THE VALUE RETURNED I WANT TO USE SPRINTF(VALUE,"%E",(FLOAT)*MYSQLDA->SQLVAR(I).SQLDATA); I AM GETTING THE WRONG ANSWER ANY IDEAS? DL DAVE LAUTA ----- OS2DBM CFORUM appended at 16:55:08 on 92/08/10 GMT (by UBIQUITY at AUSVM1) Subject: SQLDA FLOATING POINT FORMAT Ref: Append at 14:43:20 on 92/08/10 GMT (by TCSC121 at OS2CUST) You have the right idea but you're missing an important piece: *you* have to allocate space for the floating point variable to which SQLDATA points. So your code should look something like this: double MyFloat; short MyIndicator; sqlda *MySQLDA; /* allocate SQLDA */ MySQLDA->sqlvar(i).sqltype = 481; MySQLDA->sqlvar(i).sqllen = 8; MySQLDA->sqlvar(i).sqldata = &MyFloat; MySQLDA->sqlvar(i).sqlind = &MyIndicator; EXEC SQL FETCH MYCURSOR USING DESCRIPTOR :*MySQLDA; The value will now be returned in MyFloat. If the value is NULL, MyIndicator will be negative. Richard D. Hoffman ----- OS2DBM CFORUM appended at 10:12:02 on 92/08/11 GMT (by VERSTEEG at UITVM1) Subject: New!! Client/Server Programming with OS/2 2.0 I extracted this from the internal announcement by the authors (AV): Title: Client/Server Programming with OS/2 2.0 (Second Edition) Authors: Robert Orfali and Dan Harkey Description: 1112 pages, $39.95 Publisher: Van Nostrand Reinhold, New York (August, 1992). ISBN Number: 0-442-01219-5. IBM Mechanicsburg: G325-0650. We're, at last, happy to announce the second edition of our book "Client/Server Programming with OS/2 2.0." This edition contains over 600 new pages on OS/2 2.0's advanced client/server features. The first 200 pages are a "book within a book" and can be used as an introduction to OS/2 2.0 for non-programmers. This includes a detailed overview of the OS/2 2.0 client and server platforms-- including base OS/2 2.0, MMPM/2, Database Manager, DDCS/2, Communications Manager, TCP/IP for OS/2, LAN Server, and NetWare Requester for OS/2 2.0. We also compare OS/2 2.0 with other client/server platforms such as Windows 3.X, Unix, NT, and NetWare 3.1. The book includes 300 pages of working 32-bit OS/2 code. We develop programs that demonstrate how to effectively use OS/2 2.0's base services such as multitasking, multithreading, Named Pipes, and the new 32-bit sempahore model. Our BLOB olympics now run on top of OS/2's CPI-C/APPC, NetBIOS, Named Pipes, Sockets over TCP/IP, NetWare Requester, and LAN Server protocols. We now cover DDCS/2 in addition to the Extended Services Database Manager. Our TP1 benchmarks were converted to 32-bit OS/2. Over 200 pages are on programming PM, SOM, and the Workplace Shell (class libraries). We explain the benefits of Object-Oriented User Interfaces (OOUIs) for the creation of client front-ends. We gave an OOUI facelift to our Club Med application. You will be pleased with "pizzaz" added by the new PM/WPS controls such as folders and notebooks. Over 100 new illustrations and cartoons add some life and humor to the arcane technical jargon. We hope the book will continue to appeal to wide audiences ranging from novices to PC programmers programmers and MIS professionals. Most importantly, we hope the book will demonstrate to potential customers the power of OS/2 2.0 as both a client and server platform. The book shows that the OS/2 client/server power is here today! The book will make its debut next week at the "Windows and OS/2" show in Boston. You can order it now from Mechanicsburg (puborder: G325-0650). Bob Orfali Dan Harkey Anton Versteeg - ESAT PWS CoC - Uithoorn Netherlands ----- OS2DBM CFORUM appended at 12:35:16 on 92/08/11 GMT (by XXCDSX26 at TORVMCOP) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 10:12:02 on 92/08/11 GMT (by VERSTEEG at UITVM1) Anton: Tell the authors "Thanks!" This is one book I have been waiting for. I thought the first edition was one of the best OS/2 books ever and the best on EE. The new one should be interesting reading. Michael Harper - Cdn Depository for Securities, Ltd ----- OS2DBM CFORUM appended at 12:43:50 on 92/08/11 GMT (by TCSC121 at OS2CUST) Subject: MORE SQLDA FLOATINGPOINT PROBLEMS What I did to allocate the memory was: while ( i < mysqlda->sqld ) { mysqlda->sqlvar(i).sqldata = (unsigned char * ) malloc(mysqlda->sqlvar(i).sqllen); mysqlda->sqlvar(i).sqlind = ( short * ) malloc(mysqlda->sqlvar(i++).sqlind); } After the fetch using descriptor ... float *f; char value(64); f = mysqlda->sqlvar(i).sqldata; sprintf(value,"%E",*f); returns a value that is not the value that was stored ??? also for a sqltype value 0f 485 I get a length of 1285 what does this mean? DAVE LAUTA ----- OS2DBM CFORUM appended at 12:55:38 on 92/08/11 GMT (by VERSTEEG at UITVM1) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 12:35:16 on 92/08/11 GMT (by XXCDSX26 at TORVMCOP) Just forwarded your append to them. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** GO OS/2 2.0 *** ----- OS2DBM CFORUM appended at 13:52:09 on 92/08/11 GMT (by UBIQUITY at AUSVM1) Subject: MORE SQLDA FLOATINGPOINT PROBLEMS Ref: Append at 12:43:50 on 92/08/11 GMT (by TCSC121 at OS2CUST) Here are a few comments on your approach: > while ( i < mysqlda->sqld ) { I guess you've verified that i is initialized to 0. > mysqlda->sqlvar(i).sqldata = > (unsigned char * ) malloc(mysqlda->sqlvar(i).sqllen); This will get you into trouble for null-terminated strings and VARCHAR strings, where the number of bytes to be allocated are SQLLEN+1 and SQLLEN+2, respectively. It will also get you into trouble with DECIMAL fields (see below), but C is already in trouble with these (i.e., has no way to manipulate or display them), so you should probably substitute a double (SQLTYPE=481, SQLLEN=8). > mysqlda->sqlvar(i).sqlind = > ( short * ) malloc(mysqlda->sqlvar(i++).sqlind); I don't see how this allocates two bytes of storage for the indicator. Also, isn't it inefficient to be mallocating such small pieces of storage? Seems like it would be better to malloc an array of SQLD indicators outside the loop. > For a sqltype value 0f 485 I get a length of 1285. What does this mean? That's a DECIMAL field. The first byte is the precision, the second is the scale. So: 1285 = x'505', indicating DECIMAL(5,5). Richard D. Hoffman ----- OS2DBM CFORUM appended at 15:14:54 on 92/08/11 GMT (by TCSC121 at OS2CUST) Subject: MORE ON SQLDA FLOATING POINT Thank you for your response. First I have to admit that in the note I omitted the sizeof(mysqlda...sqlind) to obtain the malloc of the two bytes. I like your idea of allocating an array of null indicators and assigning the address in the loop. I am unclear what function the indcators provide. Thank you for explaining the correlation between 1285 and DEC(5,5) Do you have an example of converting the bytes to give the precision 0x0505. I still am not converting the floating point correctly and do need some further explanation. I am filling in the SQLDA structure with a describe statement that I built from a query to SYSIBM.SYSCOLUMNS This technique has kept me from coding many host variables. My intent is to write a routine which will extract all fields from any table and present it to MVS using APPC. I am real close but can't get it to work on SCIENTIFIC or DECIMAL. I am converting all values to ascii character strings to use ASCII to EBCIDIC conversion efficiently. Thank you for pointing out that VARCHAR needs to be two bytes bigger than sqlda->sqlvar.sqllen. That would have been a hard bug to find. DAVE LAUTA ----- OS2DBM CFORUM appended at 16:09:21 on 92/08/11 GMT (by UBIQUITY at AUSVM1) Subject: MORE ON SQLDA FLOATING POINT Ref: Append at 15:14:54 on 92/08/11 GMT (by TCSC121 at OS2CUST) > I am unclear what function the indcators provide. If you FETCH a NULL value, we set the corresponding indicator variable to a negative number. If the column is nullable (as indicated by an odd SQLTYPE), you should check the indicator variable after each FETCH to see if you have FETCHed a NULL value. > Do you have an example of converting the bytes to give the precision > 0x0505 (from 1285)? Precision = (int)(SQLLEN/256); Scale = (SQLLEN - Precision*256); e.g.: 1285/256 = 5 (precision); 1285-5*256 = 5 (scale) > I still am not converting the floating point correctly and do need some > further explanation. I think I see your problem. Don't use float: use double. What is the SQLLEN for your FLOAT fields? It should be 8. You didn't mention originally that you were doing this through MVS. MVS supports a four byte float, but we don't. If SQLTYPE IS 480 or 481 and SQLLEN is 4, change SQLLEN to 8 and make SQLDATA point to a double > SCIENTIFIC This is a QM term. Most DBM programmers call these numbers "FLOAT". > I am converting all values to ascii character strings to use ASCII to > EBCIDIC conversion efficiently. I hope you are not doing this yourself. DDCS converts from EBCDIC to ASCII automatically. Richard D. Hoffman ----- OS2DBM CFORUM appended at 16:20:21 on 92/08/11 GMT (by XXCDSX26 at TORVMCOP) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 12:55:38 on 92/08/11 GMT (by VERSTEEG at UITVM1) Anton, thanks. Michael Harper - Cdn Depository for Securities, Ltd ----- OS2DBM CFORUM appended at 17:28:19 on 92/08/11 GMT (by TCSC121 at OS2CUST) Subject: MORE SQLDA FLOATING POINT PROBLEMS To clarify you last note: I am performing this function on the workstation. After I fetch a row I convert it to EBCDIC and send it using the APPC api interface. We currently have on order DDCS but do not have it yet. I want the function to be able to perform as an export with out having to shell to OS. I could do this by performing an export, preprocessing the file and file transfering it to the host. I figured it would be more efficient to read each row, process it, and send it, all within the confines a a single process. I changed all references from float to double but I still am getting the wrong answer. When I try to allocate the pointer mysqlda->sqlvar(i).sqldata = ( double * ) malloc(sizeof(double)); I get the compiler error EDC0127:If the operands are pointers they must point to compatible types. EDC0140: Operand has type _Seg16 pointer to unsigned character. EDC0140: Operand has type pointer to double. (more) When I try to allocate the pointer mysqlda->sqlvar(i).sqldata = ( unsigned char * ) malloc(sizeof(double)); It compiles but what sqldata points to is not the correct type. the following produces incorrect results. Assuming mysqlda is initialized correctly with the use of DESCRIBE stmnt INTO :*mysqlda.Other fields are OK. double val; int i = 0; while ( i < mysqlda->sqld ){ switch ( mysqlda->sqlvar(i).sqltype ) { . . . case 481: { val = ( double )*mysqlda->sqlvar(i)->sqldata; val is not the same as what was stored through QM. Is it me or what ? Dave Lauta Time Customer Service OS/2 2.0 programmer ----- OS2DBM CFORUM appended at 20:36:12 on 92/08/11 GMT (by IL78568 at OS2CUST) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 12:55:38 on 92/08/11 GMT (by VERSTEEG at UITVM1) I completely agree with Michael Harper as to the value of the earlier book. I will be getting this one as soon as it appears in a local bookstore. With the earlier book, I had a frustrating experience trying to get the sample code. After trying unsuccessfully for several months to get it through our purchasing dept, I was told that it could not be acquired because of some technical procurement problem. I then ordered it myself and received it a couple of weeks later. Because I am so cheap, I was wondering if there was any alternative method of acquiring the new sample code (if not prohibited by any kind of contractual, technical, financial or practical consideration). E.g. having it available on the OS2 BBS. Anyway, I didn't think it would hurt to ask. Brooks McNeely - Martin Marietta Energy Systems, Inc. ----- OS2DBM CFORUM appended at 21:47:29 on 92/08/11 GMT (by SDAVIS1 at DALVMIC1) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 20:36:12 on 92/08/11 GMT (by IL78568 at OS2CUST) I went through the same frustration of trying to obtain the sample code diskette for the 1st edition of the book, and eventually found out that the publisher (VNR) has strict contractual guidelines that prevent distribution of the code through anyone but themselves (mail in the order form on the last page). I doubt that agreement has changed for the second edition. Steve Davis IBM Dallas ----- OS2DBM CFORUM appended at 22:45:14 on 92/08/11 GMT (by FCOC079 at OS2CUST) Subject: SQL30080N Ref: Append at 19:52:17 on 92/08/07 GMT (by IL03484 at OS2CUST) I'm sure you've found an answer by now, but in case not: SQL30080 is a catch-all sqlcode used when access to a remote database fails for communications reasons. Query Manager tends to cover up the useful in- formation for such failures. To find more information on this error code, use the DBM command line interface from any OS/2 command prompt, like this: c:\> dbm ? sql30080 To get more info about the failure, try this (where "dbname" is the remote database name): c:\> dbm start using database dbname This may return NETBIOS/APPC error information. I'm not sure I understand how import/export is involved in your question, but if you're using them to act on a table in a remote database, they're suscept- ible to the same error situations as any other program using SQL. Dave Boll ----- OS2DBM CFORUM appended at 03:57:28 on 92/08/12 GMT (by DBSWIFT at SJSVM28) Subject: 1992 Pan-European IDUG Conference ************************************************************************ International DB2 Users Group (IDUG) 1992 Pan-European Conference 21-24 September, 1992 Hotel Inter-Continental, Geneva, Switzerland ************************************************************************ The 1992 Pan-European International DB2 User Group (IDUG) conference is scheduled for September 21-24, 1992 in Geneva, Switzerland. An anticipated 500 DB2 and OS/2 Extended Services users will enjoy an unsurpassed technical education program. There are 2.5 days of 35 technical sessions, 3 keynote sessions, an advanced user panel, and an IBM panel. The speakers are a combination of users (mostly), consultants/vendors, and IBMers. There is an exhibit hall with over 30 companies showing their DB2-related products. ("Selling" is strictly prohibited in the technical sessions.) Keynote speakers Don Haderle, Chris Date, and Tony Percy highlight the program. - See the BBS News and Announcements for detail of the technical program. - For program information and registration call IDUG: Within Europe: 31 2503 28 802 (Hoofddorp, The Netherlands) FAX 31 2503 39 515 IDUG Headquarters: 312-644-6610 (Chicago, Illinois USA) or 312-527-6777 FAX 312-321-6869 - Conference Registration Cost: $995 U.S. dollars (USD) postmarked on or before 14 August 1992 and $1095 (USD) after 14 August Mike Swift - Santa Teresa Executive Briefing Center, San Jose, CA ----- OS2DBM CFORUM appended at 20:05:17 on 92/08/12 GMT (by IL78568 at OS2CUST) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 21:47:29 on 92/08/11 GMT (by SDAVIS1 at DALVMIC1) I suspected as much, but thanks for the information. Brooks McNeely - Martin Marietta Energy Systems, Inc. ----- OS2DBM CFORUM appended at 20:38:58 on 92/08/12 GMT (by IL87812 at OS2CUST) Subject: Database Manager Data Importing Hi there, Does anyone know of any application or utility that allows one to import data from specified ranges within a spreadsheet into database Manager. I know it's possible to import using the WSF format whereby the data is presented in a columnar format. Therein lies the problem, I don't want to rearrange the many spreadsheets we have,to allow the importing to take place. Thanks much, Paul Moran ----- OS2DBM CFORUM appended at 20:53:54 on 92/08/12 GMT (by GBFORNEY at WASVMIC5) Subject: Database Manager Data Importing Ref: Append at 20:38:58 on 92/08/12 GMT (by IL87812 at OS2CUST) 123 for OS/2 has a direct link to the EEDBM. It comes with version 1.1 of 123 for OS/2 and is called the Datalens. I have used it quite abit with 1.3.2 but not 2.0/ES1.0. Greg Forney bigred@vnet.ibm.com ----- OS2DBM CFORUM appended at 22:47:07 on 92/08/12 GMT (by XXNOVA24 at TORVMCOP) Subject: Database Manager Data Importing Ref: Append at 20:53:54 on 92/08/12 GMT (by GBFORNEY at WASVMIC5) It works on 2.0 \ES 1.0 DBM . I tried it. Regards, Geza Szivos NOVACOR Chemicals (403)-290-6583 NHO-32 801-7th Ave Calgary, Alberta, CANADA T2P 2N6 ----- OS2DBM CFORUM appended at 08:39:50 on 92/08/13 GMT (by VERSTEEG at UITVM1) Subject: New!! Client/Server Programming with OS/2 2.0 Ref: Append at 20:05:17 on 92/08/12 GMT (by IL78568 at OS2CUST) Here is the response from one of the authors: ================================================================= Anton, thanks for bringing this to our attention. The code cannot be put on a BBS because of legal copyright issues. However, it is going to be much easier to order. Orders can now be made by Telephone, Fax, or E-mail. Credit cards will be accepted. All orders will be mailed out the next day. Overnight delivery is available. Please feel free to post this info. I hope it will be much easier this time around. Bob Orfali ================================================================= Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** GO OS/2 2.0 *** ----- OS2DBM CFORUM appended at 14:10:25 on 92/08/13 GMT (by DANIELG at RIOVM1) Subject: USERID and Administrative Authority Colleagues, I'm new to DBM and don't have a manual nearby, so maybe you can answer the following: Is there no way to take away Database Authority from USERID? If it's possible, how do I do it? Thanks for your responses. It would be nice if you could respond directly to my logon DANIELG at RIOVM1. Daniel Godoy. Brasilia. Federal Gvt. ----- OS2DBM CFORUM appended at 14:18:37 on 92/08/13 GMT (by IL71329 at OS2CUST) Subject: SYTOS PLUS V1.32 for OS2 2.0 I have been using Sytos Plus v1.32 for backup and recoveries on a IBM 8590 OKF machine. Needless to say it is as fast as mud. I am testing a beta copy of SYTOS V1.35.12 and it works much better on the OKF machine but dies on our new 8590 OLF machine. Becky Epping Country Companies Ins. Bloomington, IL ----- OS2DBM CFORUM appended at 14:42:32 on 92/08/13 GMT (by XXCDSX26 at TORVMCOP) Subject: USERID and Administrative Authority Ref: Append at 14:10:25 on 92/08/13 GMT (by DANIELG at RIOVM1) Daniel: Go into the User Profile system and delete the ID. However, make sure you have a System Administrator ID defined otherwise you will lose that privilege. Michael Harper - Cdn Depository for Securities, Ltd ----- OS2DBM CFORUM appended at 16:38:13 on 92/08/14 GMT (by CHODGES at DETVMIC4) Subject: SYTOS with ES/2 DBM What release of SYTOS supports ES/2 DBM? Are there any other alternatives besides SYTOS which could be used for backup? Cathy Hodges, BO 153 ----- OS2DBM CFORUM appended at 11:56:46 on 92/08/17 GMT (by NJOY at HVTVM) --- Subject: USERID Authorisation I have used UPM to set authorisations for users, but when the user logs on, they cannot access any Queries set up by the administrator (USERID). ie if HELEN logs on & selects (from a menu) a query from the SAMPLE table, the error SQL0204N HELEN.SAMPLE is an undifined name. If HELEN logs on to a database in Query Manager, the tables and queries in that database are not even available. If the Qualifier is changed to USERID the tables & queries appear, but the same error is reported when a query is run. Does anyone have any clues or fixes please ? Nick Joy Havant, England ----- OS2DBM CFORUM appended at 13:13:35 on 92/08/17 GMT (by IL61500 at OS2CUST) Subject: DATABASE MGT TRAINING Hello, Can anyone recommend which IBM OS/2 Database Mgr class they found helpful for learning SQL programming under DB Mgr Ver 1.3? Thanks LOU BREIT, Dean Witter Reynolds ----- OS2DBM CFORUM appended at 14:24:42 on 92/08/17 GMT (by DVOGEL at DALVM3) Subject: USERID Authorisation Ref: Append at 11:56:46 on 92/08/17 GMT (by NJOY at HVTVM) In your SQL statments you will need to explicitly qualify the table names. For example if you have the following query coded today: SELECT * FROM STAFF you will have to change it to: SELECT * FROM USERID.STAFF Now anyone with the proper authorization will be able to run your query against the USERID.STAFF table. When you don't fully qualify the table name, DBM will use the currently logged on userid as the default qualifier. Don Vogel - Skill Dynamics an IBM Company ----- OS2DBM CFORUM appended at 15:34:31 on 92/08/17 GMT (by DBPARKER at SJSVM28) Subject: USERID Authorisation Ref: Append at 11:56:46 on 92/08/17 GMT (by NJOY at HVTVM) As you probably know, USERID is the default logon for UPM when the DBM is installed. Therefore, USERID owns everything. There are several ways around this for the other users. One is to add a parameter to the start Query Manager statement or ICON to use the correct Qualifier, or, create a default PRofile to do the same, or, to create a view with the user's id. George Parker ----- OS2DBM CFORUM appended at 15:36:44 on 92/08/17 GMT (by VERSTEEG at UITVM1) Subject: USERID Authorisation Ref: Append at 11:56:46 on 92/08/17 GMT (by NJOY at HVTVM) If the query was created under userid GEORGE, then the menu action that HELEN executes would have to be RUN QUERY GEORGE.SAMPLE Also note that when you save QM objects that are intended to be executed by others you'll need to save them with the 'share' option. (this is an option on the 'save' popup) Finally, you can use 'change qualifier for lists' whenever a list window is displayed, to change the list qualifier to GEORGE in my example. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000 OS/2 2.0 *** ----- OS2DBM CFORUM appended at 18:08:03 on 92/08/17 GMT (by INTC7P04 at DALVM41B) Subject: DBM STOPS WORKING AFTER A TIME. I have an 8580-161, 16M, running OS/2 2.0 with latest fixes, ES Comm. Mngr., Adv. LS LAN Req., TCP/IP 1.2.1, and of course ES DBM standalone and remote services. I issue a STARTDBM.EXE from the STARTUP.CMD immediatly after starting the LAN Req. and logging on to our local LAN Domain. Comm. Mngr. is started from the startup folder. The TCPSTART.CMD is called after the STARTDBM.EXE. As DBM is starting I get the three or four beeps and the message that the DBM proccessing is complete and the rest of the STARTUP.CMD finishes. I can then start Query Manager and work with the databases that are stored on my workstation. I currently do not access any remote DBs. The above scenario works fine for any number of IPL's during the week. But then on the next IPL, DBM will not start. No error messages, no nothing. The harddrive runs for 5 seconds or so, I DO NOT hear the three or four beeps, and the STARTUP.CMD stops dead. The window does not close, and the command listed for the window is STARTDBM.EXE. I can not close the window even with PSPM or KILLIT. The normal operation of the work- station does not appear to be affected. I have tried reordering the STARTUP.CMD. I have tried a START /C STARTDBM.CMD, no go. I have tried NOT starting the other services that I normaly run, same result. The only cure that I have found is to REINST the DBM, this is very tiresome. I have been doing this for 2 months now. I will appreciate any help. Thank you, Al Connor DALVM41B(INTC7P04) ProVantage Superlab, Dallas. ----- OS2DBM CFORUM appended at 13:04:30 on 92/08/18 GMT (by WINK at JAKVM001) Subject : OS/2 DBM implementation I hope I put this question in the right forum. My colleague here has several questions re: OS/2 DBM implementation. Appreciate very much any input. Thank you before hand. -------------------------------------------------------------------------------- My customer Bank EXIM is currently testing the DRDA on PS/2 and AS/400 level. They also decided to have Windows based applications for their DOS front end WS. They have several queries for OS/2-Windows. Would you be kind to help me on this ? Appreciate your support very much. Q : 1. The manuals stated that OS/2 application enabler supports Windows 3.0. Is Windows 3.1 supported ? Will IBM support new release of MS Windows? 2. It is also stated that Windows Database Client Applications must be written using Microsoft C Optimizing Compiler V.6. Microsoft has release V.7 . Is this supported ? My customer is actually coding his Windows program in Borland C++. Is it feasible to use Microsoft Compiler to code DBM routines, then link them with their Borland program ? 3. My customer also intend to use the Database Application Remote Interface (ARI) concepts to code the programs, which is supported in Windows. Do you have any working sample program to run ? WINK at JAKVM001 ----- OS2DBM CFORUM appended at 14:07:53 on 92/08/18 GMT (by UBIQUITY at AUSVM1) Subject: OS/2 DBM implementation Ref: Append at 13:04:30 on 92/08/18 GMT (by WINK at JAKVM001) The support statements to which you refer are really testing statements. We tested with Windows 3.0 and MS C 6.0, so we cannot assure you that the same tests would work with other versions. I do not know of any particular reason why you should not be able to use the later versions. However, if you do so, it will be at your own risk. Your note makes it seem as if your customer wants to use the ARI in connection with AS/400. This will not work. ARI is only supported for OS/2 servers. Richard D. Hoffman ----- OS2DBM CFORUM appended at 14:14:55 on 92/08/18 GMT (by VERSTEEG at UITVM1) Subject: OS/2 DBM implementation Ref: Append at 14:07:53 on 92/08/18 GMT (by UBIQUITY at AUSVM1) The Database Manager Programmers Guide and Ref. contains ARI sample code. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000 OS/2 2.0 *** ----- OS2DBM CFORUM appended at 19:24:45 on 92/08/18 GMT (by TCC3824 at OS2CUST) Subject: SYTOS with ES/2 DBM Ref: Append at 16:38:13 on 92/08/14 GMT (by CHODGES at DETVMIC4) I use sytos on my 1.3 environment. However, it does not work well with DBM. We have to make sure the DB is not being accessed when Sytos backs up the DB server. If you have a job running and sytos goes to backup the machine it will blow up the DB. This will most likely be the same with ES. However I have not been able to move to ES because of know problem with inserting >200,000 rows in a table. Still waiting on a fix for this. Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 21:45:42 on 92/08/18 GMT (by DGDANGEL at NYCVMIC1) Subject: SQL5122N received after migrating from 1.3 to 2.0. If someone has the TARRR Package or the UNPROT.CMD can you please send it to me. I have a client that has a database that is copy protected that we need to access. Thank you. DGDANGEL/NYCVMIC1 or DGDANGEL@VNET.IBM.COM Doug D'Angelo ----- OS2DBM CFORUM appended at 23:10:35 on 92/08/18 GMT (by GBFORNEY at WASVMIC5) Subject: SQL5122N received after migrating from 1.3 to 2.0. Ref: Append at 21:45:42 on 92/08/18 GMT (by DGDANGEL at NYCVMIC1) Done. Greg Forney bigred@vnet.ibm.com ----- OS2DBM CFORUM appended at 02:18:03 on 92/08/19 GMT (by LNK1SM3 at MARTLINK) Subject: DATABASE MGT TRAINING Ref: Append at 13:13:35 on 92/08/17 GMT (by IL61500 at OS2CUST) I will see what I can find and will respond in a couple of days. Thank you for using the OS2BBS. JAM ----- OS2DBM CFORUM appended at 11:18:37 on 92/08/19 GMT (by NJOY at HVTVM) --- Subject: USERID Authorisation Ref: Append by NJOY at HVTVM at 11:56:46 on 92/08/17 GMT. A note of thanks to the replies. Qualifying the Query with USERID.TABLE worked. Thanks again. Nick Joy. ----- OS2DBM CFORUM appended at 18:41:47 on 92/08/19 GMT (by WAK1015 at OS2CUST) Subject: QUERY MANAGER I JUST INSTALLED OS/2 2.0 AND DATABASE MANAGER FROM ES 1.0. THE INSTALLATION W ENT THROUGH WITH NO ERRORS. WHEN I TRY TO GET INTO QUERY MANAGER I GET A SYS20 70 ERROR. I HIT THE RADIO BUTTON FOR "DISPLAY REGISTER INFORMATION" AND I GET "SEGMENT COULD NOT DEMAND LOAD THE APPLICATION SEGMENT. QRWC->QRWQ IS IN ERROR. ETC."- SYS202. WHAT COULD BE THE PROBLEM? IF YOU NEED ANY OTHER INFORMATION PLEASE LET ME KNOW. I HAVE INSTALLED DATABASE MANAGER AND QUERY MANAGER ON OTH ER SYSTEMS BEFORE WITH NO PROBLEM. ----- OS2DBM CFORUM appended at 19:12:30 on 92/08/19 GMT (by WAK1015 at OS2CUST) Subject: QUERY MANAGER MONOSPACED FONTS HOW DO WE CHANGE THE FONT TO SYSTEM MONOSPACED IN THE QUERY MANAGER OF EXTENDED SERVICES? THERE IS AN OPTION IN EXT. SERVICES FOR DATABASE MANAGER: CONFIGURING SETUPS FO R DATABASES, WHICH HAS A "FONT" SETTING. BUT EVEN AFTER CHANGING AND SAVING TH IS, WHEN RETURNING TO THE QUERY MANAGER THE FONTS ARE STILL PROPORTIONAL. ----- OS2DBM CFORUM appended at 19:42:10 on 92/08/19 GMT (by VENDENA at DALVM41B) Subject: QUERY MANAGER Ref: Append at 18:41:47 on 92/08/19 GMT (by WAK1015 at OS2CUST) How much RAM is on your machine? If other programs are using RAM, try disabling them and then try running QM. Dena Laterza ----- OS2DBM CFORUM appended at 09:23:57 on 92/08/20 GMT (by VERSTEEG at UITVM1) Subject: QUERY MANAGER MONOSPACED FONTS Ref: Append at 19:12:30 on 92/08/19 GMT (by WAK1015 at OS2CUST) The QM proportional font cannot be changed. Sorry. Anton Versteeg ----- OS2DBM CFORUM appended at 09:25:30 on 92/08/20 GMT (by F17 at TELVM1) --- Subject: Unsuccessful Logon using RDS with APPN I am trying to set up a LAN with an OS2 DBM client and DBM Server communicating via APPN links. One workstation is defined to Communication manager as a Network Node and the other as an End Node. I succeeded to execute a CPI-C demo between the two workstations so I am quite confident that my CM configurator definitions are valid. I then successfully perform local logons for USERID (with the identical passwords) at both workstations and then execute STARTDBM at both workstations. MY problem arises when I issue START USING DATABASE DAVID where DAVID is defined as a remote database at workstation DAVID. UPM notifies me that I have an unsuccessful LOGON ATTEMPT at workstation DAVID. THe help gives several possible explanations. I feel the most likely possibility is "You are trying to access a remote workstation that does not exist or has not been defined". Here are my directory definitions on the client: NODE DIRECTORY: Workstation ALIAS = DAVID PROTOCOL=APPN NETWORK ID= ILIBM00 PARTNER LOGICAL UNIT=FTQCN03 Transmission SERVICE MODE =#BATCH Database Directory: Database ALias = DAVID DATABASE NAME = SAMPLE WORKSTATION ALIAS = DAVID DATAbase TYPE =OS2 DBM VER 3.00 Directory entry type = Remote There is an SNA LINK defined between the two workstations. No TP is defined for DATABASE MANAGER or UPM. Can any offer any ideas or point me in the right direction. Thank you David Berk ----- OS2DBM CFORUM appended at 11:18:52 on 92/08/20 GMT (by F17 at TELVM1) --- Subject: Unsuccessful Logon using RDS with APPN Ref: Append at 09:25:30 on 92/08/20 GMT (by F17 at TELVM1) I kept trying and made a bit of progress. I changed the node directory definition by using the the CONNECTION_NETWORK name of the server instead of the FQ_CP_NAME and apparently succeeded to perform a successful LOGON but received a communication manager error "0003-00000004" which "indicates that a conversation with the database server could not be allocated". I assume that I am missing some SNA configuration definitions so I repeat my request for some help in this area. Thanks David Berk ----- OS2DBM CFORUM appended at 13:34:51 on 92/08/20 GMT (by VERSTEEG at UITVM1) ..... OS2DBM CFORUM modified at 15:03:50 on 92/08/20 GMT (by VERSTEEG at UITVM1) Subject: Sytos for OS/2 2.0 Sytron just announced that their OS/2 2.0 version of Sytos will be available the end of this month. | PS. includes support for HPFS and EA's | standard disclaimers apply. (no ties etc.) Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000 OS/2 2.0 *** ----- OS2DBM CFORUM appended at 13:53:50 on 92/08/20 GMT (by MCCAULEY at DALVM3) Subject: DATABASE MGT TRAINING Ref: Append at 13:13:35 on 92/08/17 GMT (by IL61500 at OS2CUST) Lou, Skill Dynamics (the IBM Education Company) offers two courses on Database Manager Programming: P1048 and P1024. P1048 uses OS/2 2.0 and Extended Services. Public classes are regularly scheduled for P1048, and private classes (usually travelled to your location or your local IBM office) can also be arranged. P1024 uses Extended Edition 1.3, and is now only available as a private class. If you don't mind getting a few bits of information that you don't need, and working with OS/2 2.0 for your Base Operating System in class, you should probably just go ahead and take P1048, even if you are still working with 1.3 right now. Of course, if you have several people who need to take the course, it might be worthwhile to look into setting up a private class of either P1048 or P1024 for your company. Here are the dates on which we currently have P1048 scheduled for the rest of this year: 9/21-23, 10/12-14, and 11/11-13. Of course, your local IBM representative can help you with finding the most up-to-date schedule, location, and price information, and arranging a private class. Thanks, Angie McCauley Skill Dynamics(TM), an IBM Company Personal Systems Segment - OS/2 ----- OS2DBM CFORUM appended at 22:44:36 on 92/08/20 GMT (by FCOC079 at OS2CUST) Subject: Unsuccessful Logon using RDS with APPN Ref: Append at 11:18:52 on 92/08/20 GMT (by F17 at TELVM1) --- David, I think you'll need a TP definition at the DBM server so that incoming APPC attaches for DBM can be resolved. In the .NDF file on your DB server, add the following: DEFINE_TP SNA_SERVICE_TP_NAME(X'07',6DB) DESCRIPTION(SQLAPPLA Profile for DBM-RDS) FILESPEC(C:\SQLLIB\SQLCIAA.EXE) CONVERSATION_TYPE(BASIC) CONV_SECURITY_RQD(YES) SYNC_LEVEL(NONE) TP_OPERATION(NONQUEUED_AM_STARTED) PROGRAM_TYPE(BACKGROUND) RECEIVE_ALLOCATE_TIMEOUT(100); DEFINE_TP SNA_SERVICE_TP_NAME(X'07',6SN) DESCRIPTION(SQLSNMGR Profile for DBM-RDS) FILESPEC(C:\SQLLIB\SQLCNSM.EXE) CONVERSATION_TYPE(BASIC) CONV_SECURITY_RQD(YES) SYNC_LEVEL(NONE) TP_OPERATION(NONQUEUED_AM_STARTED) PROGRAM_TYPE(BACKGROUND) RECEIVE_ALLOCATE_TIMEOUT(100); I think you'll also need to go into Comm. Mgr. configuration on the server and set a conversation-security entry (under SNA feature profiles/SNA network definitions ...) which tells Attach Manager to go to UPM for incoming attach security checks. Dave Boll ----- OS2DBM CFORUM appended at 00:11:41 on 92/08/21 GMT (by UDSS013 at OS2CUST) Subject: QUERY MANAGER | "SEGMENT COULD NOT DEMAND LOAD THE APPLICATION SEGMENT. QRWC->QRWQ IS IN | | ETC."- SYS202. WHAT COULD BE THE PROBLEM? IF YOU NEED ANY OTHER INFORMAT | | PLEASE LET ME KNOW. I HAVE INSTALLED DATABASE MANAGER AND QUERY MANAGER | | ER SYSTEMS BEFORE WITH NO PROBLEM. | This isn't much of an answer, but I got that error message ONCE. I rebooted and the problem did not recur. Since I had no real diagnostics, I never Gary Murphy ----- OS2DBM CFORUM appended at 13:17:50 on 92/08/21 GMT (by WAK1015 at OS2CUST) Subject: QUERY MANAGER I REBOOTED MY MACHINE AND THE ERROR IS STILL THERE. I HAVE 17 MEG OF MEMORY AN D I AM RUNNING NOTHING ELSE EXCEPT QUERY MANAGER. ----- OS2DBM CFORUM appended at 13:32:06 on 92/08/21 GMT (by VERSTEEG at UITVM1) Subject: QUERY MANAGER Ref: Append at 13:17:50 on 92/08/21 GMT (by WAK1015 at OS2CUST) Is SQLLIB\DLL in your LIBPATH in CONFIG.SYS? Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000 OS/2 2.0 *** ----- OS2DBM CFORUM appended at 15:09:25 on 92/08/21 GMT (by EEBERT at STUTVM3) Subject: SQL1042N - Unexpected System Error Ref: Append at 01:45:30 on 92/08/06 GMT (by CHALTAIN at FSHVMFK1) We have the SQL1042N failure on two machines. It started on HPFS formated machines. At the first times we did formatting and reinstalling without detailed checks. At the last occurences we did CHKDSK /F:3 due to errors on SQL datasets and OS2 log files. On one machine we could not fix the logfiles i.e. all was fine after running it twice but booting OS/2 2.0 from the harddisk was already sufficient to cause allocation errors for the OS2 log. In this case we had to format the boot partition. For the other machine reinstalling OS/2, ES and all the application was sufficien t. One of the recommendations we got was to use FAT. We did and again the machine failed. CHKDSK does not display any errors. We exchanged net.acc as suggested. We still cannot start DBM. Of course we don't like the idea of formatting but what bothers more is that we do not understand what causes this failure. We did this job in the last week 3 times for 2 machines. Since we have similar installations with no failure we assume that the failure is related to the manner the machines are used. Both machines are used in a marketing area. One of the tasks is to demonstrate DBM with a User written GUI. Databases and tables are therefor created, bound and dropped very often. We are looking for some suggestions how we can prevent the failure. Up to now we got the failure only at STARTDBM after a cold start, never for a running machine. Who can help ? Ekkehard Ebert ----- OS2DBM CFORUM appended at 15:58:03 on 92/08/21 GMT (by DYEAGER at BCRVM1) Subject: Database Mgr integrity if system crashes? We are having an application developed for OS/2 that uses the database mgr for storing results of measurements taken from lab instruments. The app is being developed under OS/2 1.3 but will probably be used under 2.0 as well. This is important data. How possible is it for OS/2 DBM to corrupt my database files due to a power outage or some other unforeseen problem? We are asking the developers to do a commit at various points during the program execution, and I am willing to loose all data taken since the last commit. But, should I also be concerned that a system problem could leave me with an unusable database? Dave Yeager ----- OS2DBM CFORUM appended at 17:10:46 on 92/08/21 GMT (by GBFORNEY at WASVMIC5) ..... OS2DBM CFORUM modified at 17:33:14 on 92/08/21 GMT (by GBFORNEY at WASVMIC5) Subject: Database Mgr integrity if system crashes? Ref: Append at 15:58:03 on 92/08/21 GMT (by DYEAGER at BCRVM1) The only truly safe reply is to "Never say Never" and plan your installation accordingly. You can postulate things from the sublime to the ridiculous and evaluate the cost/benefit of protecting from same. Suppose a meteor strikes the office with the DBM server and reduces the machine to dust? But coming back to earth, the presence of "bugs" or "design shortcomings" (choice depends on your point of view!) has been studied alot in the area of recovery from abrupt system outages. A Lot of very good work has been done to harden the DBM from such problems. My professional interest is in using the DBM to store Pharmaceutical production records under FDA validation requirements and you can be sure that I applied alot of paranoia to my investigation. I got alot of great help from the DBM developers and the Boca lab both from OS/2 and PS/2 folks. My checklists (remember my paranoia!): 1) Use ES 1.0. (the latest and greatest keeps getting better and better) 2) Use a UPS. This should go without saying if you are truly mission- critical. 3) Use Forward recovery. Have the user exit back up the log files across a LAN to a remote machine (remember that meteor?). At this point, I really think someone is approaching my level of hysteria if they still feel uncomfortable, but short of relocating your machine to Iron Mountain, here's some more precautions you can consider: 4) Use a SCSI drive. They have a latency in their power-down that helps. 5) Use a FAT partition of at least 128Mb. This best matches the DBM's data model to the file system. 6) Use fixed length data. Avoid varchar *if* possible. Don't panic if not possible. There are also many things I see people do, that I question whether they understand what it is really buying them. RAID disks protect only from a physical disk crash. It does not protect from a system failure occurring elsewhere that catches the DBM in a compromising position. Inconsistent data is Inconsistent data. Same thing applies for disk mirroring. Mind you I have nothing against either and if you can afford them, be my guest. But a really safe system will use Forward recovery also making these two a convenience, not a necessity. Greg Forney bigred@vnet.ibm.com ----- OS2DBM CFORUM appended at 18:07:37 on 92/08/21 GMT (by DYEAGER at BCRVM1) Subject: Database Mgr integrity if system crashes? Ref: Append at 17:10:46 on 92/08/21 GMT (by GBFORNEY at WASVMIC5) Thanks for the tips. Here's my level of paranoia... 1. I am willing to accept the risk of catastrophic failures due to fires and/or meteors, thus can accept that the backup system is actually to a duplicate hardfile on the SAME PS/2 (LAN not required). 2. Do I need a UPS? The question in my mind becomes, "is there ANY time during normal ES/DBM operations that a power interrupt could result in a contaminated database?" If so, then UPS is needed. This brings to mind the comment from a Boca employee who was about to be moved from a window office and complained that if he couldn't see outside, he would have no way to predict when a storm was about to hit so wouldn't know how often to save up his VM file. Dave Yeager ----- OS2DBM CFORUM appended at 18:31:16 on 92/08/21 GMT (by GBFORNEY at WASVMIC5) Subject: Database Mgr integrity if system crashes? Ref: Append at 18:07:37 on 92/08/21 GMT (by DYEAGER at BCRVM1) You asked a fairly paranoid question in # 2 emphasizing ANY and using "could" so the answer to you is yes. But before you go get a UPS, consider that the odds of you getting bitten are similar to your machine falling prey to a direct bolt from above. Assuming that you have used Forward Recovery, you'll still be OK unless that fails too. Now that you have convinced yourself that maybe a UPS really isn't needed, go get one anyway. It's such a standard thing to do for data safety, you'd be foolish not to. Greg Forney bigred@vnet.ibm.com aka Chicken Little ----- OS2DBM CFORUM appended at 18:54:29 on 92/08/21 GMT (by LFISCHER at BLDVM1) Subject: Database Mgr Charting Facility We had been developing an OS/2 application which provides a business graphics charting facility for data stored in OS/2 Database Manager. The application uses the capabilities of CHRTAPI from OS/2 Tools. Work on our project has been stopped due to "changing business needs". I have been asked to see if there is any interest in funding the completion of this application. Most but not all of the functions of CHRTAPI have been implemented. Approximately four person months of effort is needed to complete the added functions and to develop a users' guide. If there is interest in funding such an effort please let me know with a note direct to me - LFISCHER at BLDFE2. Regards, Larry Fischer ----- OS2DBM CFORUM appended at 19:59:11 on 92/08/21 GMT (by SRPIE05 at OS2CUST) Subject: Book Manager Documentation for ES Does anyone know if there are softcopy pubs available for Extended Services? They were released for LAN Services but I have not seen them for ES yet. Thanks. Thanks Thane Smith - Salt River Project ----- OS2DBM CFORUM appended at 09:47:31 on 92/08/23 GMT (by F17 at TELVM1) --- Subject: Unsuccessful Logon using RDS with APPN Ref: Append at 22:44:36 on 92/08/20 GMT (by FCOC079 at OS2CUST) DAVID THANK YOU FOR YOUR REPLY David Berk ----- OS2DBM CFORUM appended at 14:33:12 on 92/08/24 GMT (by MRHI at CHVM1) --- Subject: SYS3175 error when creating an new database I installed the extended services of OS2 V2.0. Now, whenever I try to create a new database (using Query Manager or the restore command) a system error occurs: SYS3175: A program generated an access violation at xxxxxxx. SQLC.DLL 0003 The error keeps persisting after several deinstallations and re- installations of the database manager. Is there anyone who has encountered the same problem? Thanks, M. Rhiner, AD-Support Switzerland ----- OS2DBM CFORUM appended at 17:26:12 on 92/08/24 GMT (by EEBERT at STUTVM3) Subject: SQL1042N - Unexpected System Error Ref: Append at 15:09:25 on 92/08/21 GMT (by EEBERT at STUTVM3) it happened once more... We now did a reinst to remove DBM from drive C: and reinstalled DBM on drive D:. After booting STARTDBM already fails this indicates the something very important muist have been left over and not refreshed during the removal and reinstallation does this trigger any help ? Ekkehard Ebert ----- OS2DBM CFORUM appended at 18:55:10 on 92/08/24 GMT (by EICHLER at FSHVMCC) Subject: SQL-5122N ERROR MY QUERY MANAGER CRASHED DURING A DEL FILE IMPORT AND AFTER A REBOOT WOULD NOT ALLOW FOCUS TO BE BROUGHT TO THE LOGON PANEL. I RELOADED THE DATABASE MANAGER AND NOW NEED THE UNPROTECT PROGRAM TO USE MY DATABASE FILES. COULD SOMEONE PLEASE SEND A COPY OF THE UNPROTECT PROGRAM TO A DESPERATE SOUL AT FSHVMCC(EICHLER) THANK YOU!! ----- OS2DBM CFORUM appended at 18:55:34 on 92/08/24 GMT (by CHALTAIN at FSHVMFK1) ..... OS2DBM CFORUM modified at 14:15:49 on 92/08/25 GMT (by CHALTAIN at FSHVMFK1) Subject: sqlacall( SQLA_OPEN, .... using up file handles || Changing the number of maximum open files in the database || configuration panel did the trick. | I had a thought! Is it the case that whenever you do a "SELECT" from a | new table, a file handle is opened? If so, how can I close those | handles or get more than 20 file handles out of Microsoft C 6.0? I have found that the call sqlacall( SQLA_OPEN, 1, 0, 0, 0L); uses up an available file handle that the call sqlacall( SQLA_CLOSE, 1, 0, 0, 0L); does not free up! I am using a set of functions provided to me by another programmer in C. I tracked down the problem because as I loop around updating and querying the database, I would use up all of my file handles. The call to fcloseall() does not free up the handles, and does not return an error. The call to strerror( errno), gives me the message "No available file handles." (or something to that effect). Shouldnt this resource be freed up? Please let me know if I could provide more information. Unfortunately, I am a bit ignorant of this Database Manager programming, and I am not sure what information is pertinent! Thanks! Christopher J Chaltain ----- OS2DBM CFORUM appended at 20:30:20 on 92/08/24 GMT (by GBFORNEY at WASVMIC5) Subject: SQL-5122N ERROR Ref: Append at 18:55:10 on 92/08/24 GMT (by EICHLER at FSHVMCC) It's part of the TARRR package on the internal use only disk OS2TOOLS. Greg Forney bigred@vnet.ibm.com ----- OS2DBM CFORUM appended at 23:48:34 on 92/08/24 GMT (by KDROMREL at SFOVMIC1) Subject: SQL1042N - Unexpected System Error Ref: Append at 17:26:12 on 92/08/24 GMT (by EEBERT at STUTVM3) I believe I heard somewhere that SQL1042N's during a STARTDBM are primarily due to problems in the NET.ACC file. You may wish to restore this from a previously backed up version, or use the one located in IBMLAN/INSTALL (assuming you're using LAN Requester/Server). The folks in Defect Support can probably help make sure that you get the right stuff. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 00:01:40 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) Subject: Database manager crashing after maximizing Ref: Append at 16:30:13 on 92/08/03 GMT (by CGNA106 at OS2CUST) I looked in the problem database, and it does look like there is a problem similar to this. I suggest you call Defect Support (1-800-237-5511) to officially report the problem. Also mention to them that they might want to see if APAR JR06054 fixes the problem. I'm not sure when this fix will be available on a CSD/Service Packet. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 00:15:45 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) Subject: SQLCODE 1013 Ref: Append at 20:33:48 on 92/08/05 GMT (by GSCHOI at RHQVM16) I had a similar problem on OS/2 1.3. If you have an OS/2 Window open and are in directory SQL00001, then a Drop DB would fail and my catalog structure would be messed up. This problem has been fixed in OS/2 2.0. Once we changed directories back to the root directory, we were able to remove the directory (RMDIR) without any problem and I was then able to create new DB's, etc. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 00:24:55 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) Subject: SYS3175 error when creating an new database Ref: Append at 14:33:12 on 92/08/24 GMT (by MRHI at CHVM1) My customer also got SYS3175's in SQLC.DLL, but it was on the STARTDBM issued immediately after a STOPDBM. In their case it was because they had NetBios flowing over TCP/IP and the STOPDBM was not completing before the STARTDBM. When they waited 1 second between the STOPDBM and STARTDBM, then everything worked fine. From the situation you describe, your problem sounds different. Your best bet is probably to get a Trace and call Defect Support (1-800-237-5511). Kelvin D. Romrell ----- OS2DBM CFORUM appended at 00:29:34 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) Subject: SYTOS with ES/2 DBM Ref: Append at 16:38:13 on 92/08/14 GMT (by CHODGES at DETVMIC4) DB Mgr supports Backup to Disk without problem. If you want Backup to Tape, it is supported by a User Exit. 3 Sample User exits are provided with ES DBM including Sytos, Mountain, and Maynard. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 01:22:05 on 92/08/25 GMT (by BCHI040 at OS2CUST) Subject: DBM a Swapper *PIG* From the beginning, I have an IBM PS/2 M-80 with 12Mb Ram I open DBM and run a simple query like. SELECT * from tablename (with 5866 rows) And the swap file jumps from 2mb to anyware from 6 to 9 Mb on a simple query. And this is with no other applications running. When the swap file reaches around 8mb OS/2 will not allow me to open any other applications and reports that it is out of memory. 25mb set aside exclusively for the swap file) Then I exit Query manager and the swap file stays at it's current size, the only way that I have found to shrink the swap file is to shutdown and then I'm back to the default 2mb swap file. I should note that the only applications running are PULSE.EXE, SWAPPER.EXE and the OS2 clock program and I have reserved a 25mb partition for the swap file. I have installed the kernal fix to reduce swap file size. Is there anything else that can be done. Jerry Hittle, Hawaii Medical Service Ass'n ----- OS2DBM CFORUM appended at 07:16:17 on 92/08/25 GMT (by EEBERT at STUTVM3) Subject: SQL1042C - Unexpected System Error Ref: Append at 17:26:12 on 92/08/24 GMT (by EEBERT at STUTVM3) We have the solution for our case | We found it in a little booklet which comes with the product. Its title: Product Supplemental Information On page 13 are some possible causes for SQL1042C listed i.e. memory swapper space and system date. In our case the user had a DOS program which will only run if the system date is sometime last year. The user installed DBM and databases for the current date and later they changed the date to sometime last year. DBM will not start if the system date is before the installation date| Conclusion: before you blame OS/2 read the supplied info | Ekkehard Ebert ----- OS2DBM CFORUM appended at 10:55:06 on 92/08/25 GMT (by VERSTEEG at UITVM1) Subject: DBM a Swapper *PIG* Ref: Append at 01:22:05 on 92/08/25 GMT (by BCHI040 at OS2CUST) What are your SWAPPATH values in CONFIG.SYS? My swapper file can grow over 10 MB without any problem. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 13:57:55 on 92/08/25 GMT (by XXCDSX26 at TORVMCOP) Subject: DBM a Swapper *PIG* Ref: Append at 01:22:05 on 92/08/25 GMT (by BCHI040 at OS2CUST) Jerry: Yep, DBM+QM is a pig. The last time I looked was 1.3EE, then this combo to 6-8Mb to load on top of the operating system! Michael Harper - Cdn Depository for Securities, Ltd ----- OS2DBM CFORUM appended at 18:49:51 on 92/08/25 GMT (by BCHI040 at OS2CUST) Subject: DBM a Swapper *PIG* Ref: Append at 10:55:06 on 92/08/25 GMT (by VERSTEEG at UITVM1) SWAPPATH=E:\ 4096 2048 (on a 25Mb partition dedicated for the swap file) I don't have any problem with space for the swap file it when I exit DBM or try to run a DOS program while in DBM I run out of memory. Also when I do exit DBM the swap file does not get any smaller only rebooting will reduce the swap file and correct the out of memory Problem. I have had the swap file get as large as 16Mb while running DBM. I don't have any problems running QM or DBM the problem starts when I try to run other applications after DBM and I start getting out of memory errors. Jerry Hittle, Hawaii Medical Service Ass'n P.O. Box 860 Hon Hi 96808 ----- OS2DBM CFORUM appended at 20:24:54 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) Subject: DBM a Swapper *PIG* Ref: Append at 18:49:51 on 92/08/25 GMT (by BCHI040 at OS2CUST) I also have a Mod-80 w/ 12MB of memory. DBM, CM and several other apps do really bump up my swapper, but I have not had problems with being out of memory and not being able to open any other applications. Now that I have applied the Kernal fix, my swapper shrinks back down when I finish a task also. With CM up (2 3270 emulations running) and several of the productivity applets running my Swapper is at 9M. I then do a STARTDBM, START USING DATABASE, SELECT * from DATABASE (1400 records with 63 rows each) and my Swapper grows to 11M. At this point I'm still able to open new applications (e.g. Workframe/2) and my swapper grows to 12M. When the Select is done, I do a STOP USING and a STOPDBM. My Swapper shrinks back to 10M in less than 30 seconds. It didn't go back to 9M immediately, so there was probably some fragmentation or something. One this I noticed, was that while my Select was running, my CPU was going solid at 100% (with a very occasional dip). This would lead to applications taking longer to load and start, but they should start eventually. Hope this info is helpful. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 08:29:18 on 92/08/26 GMT (by NJOY at HVTVM) --- Subject: DATABASE MGT TRAINING Ref: Append by IL61500 at OS2CUST at 13:13:35 on 92/08/17 GMT. Hi, I firstly read an IBM booklet "IBM OS/2 Extended Edition Version 1.3 Database Manager Structured Query Language (SQL) Concepts", which told me most of what I needed to know. Then I attended a four day course called "IBM OS/2 Database Manager Programming for IBM" run by QA Training, Cecily Hill Castle, Cirencester, Gloucester, Gloucestershire GL7 2EF. Tel (0285) 655888. Tutor Geoff Drake. Run at IBM Havant. He taught me C too (a pre requesite for the course). He's good. This gave me the knowledge to set up a Database (from scratch) for our Failure analysis group, which is now proving very useful. Check with your training dept. Nick Joy. Havant, England. ----- OS2DBM CFORUM appended at 13:13:13 on 92/08/26 GMT (by VERSTEEG at UITVM1) Subject: DBM a Swapper *PIG* Ref: Append at 20:24:54 on 92/08/25 GMT (by KDROMREL at SFOVMIC1) I have exactly the same numbers as mentioned in the referenced append. Just a couple of wild guesses: 1. Are you sure 25MB is free? No hidden files? 2. Are you using HPFS for the SWAPPER.DAT partition? (I am using FAT) Perhaps there are lost/damaged clusters? Did you try CHKDSK on this partition? Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 09:41:19 on 92/08/27 GMT (by 83823530 at SPAVM1) Subject:SQL1042C My customer is running OS/2 2.0 and Extended Services 1.0. He was trying to delete 5.000 rows when the log files got full. His PS got hung so he started the PS again and increased the number of secondary logs from 2 to 10. When he restarted the affected Data Base he got a SQL1042C error. He was not using Forward Recovery and the data are critical.How can I help him?. Thanks in advance. Ana Martinez (83823530 at SPAVM1) ----- OS2DBM CFORUM appended at 12:38:49 on 92/08/27 GMT (by IL03484 at OS2CUST) Subject: Limit on number of Insertions Recently, I noticed a message (Subject: SYTOS with ES/2 DBM) indicating there is a limit on the number of rows which can be inserted. I would like to know more about this limit. For example, does the limit exist in OS/2 2.0? Does the limit apply to one transaction only? The limit indicated was >200,000 rows. Thanks Tom Hobbs Bituminous Insurance Co. ----- OS2DBM CFORUM appended at 14:49:24 on 92/08/27 GMT (by UBIQUITY at AUSVM1) Subject: Limit on number of Insertions Ref: Append at 12:38:49 on 92/08/27 GMT (by IL03484 at OS2CUST) There is no specific limit on insertions. The maximum size of a DBM table is 16,777,216 4K pages. Thus, for row sizes between 2003 and 4005 bytes, there can be no more than 16,777,216 rows. Smaller row sizes will allow for more than one row per page, with a suitably higher limit. In any case, 200,000 is at least two orders of magnitude too small. Richard D. Hoffman ----- OS2DBM CFORUM appended at 17:56:47 on 92/08/27 GMT (by KDROMREL at SFOVMIC1) Subject: SQL1042C Ref: Append at 09:41:19 on 92/08/27 GMT (by 83823530 at SPAVM1) There are several things that might cause this problem. From what you discussed, you most likely have some problem with your log files. I'm aware of three things you can try that might fix you up. 1) Go into the config tool and MOVE the logs. Then exit back out. Do a STOPDBM/STARTDBM (not sure if this is required). Then try to open the DB. Once things are working properly, you can move the logs back to their original directory. 2) If 1 doesn't work, try the RESETLOG command that comes with the TARRR package. It's available on the OS2Tools disk. 3) If that doesn't work, you can try restoring your logs from a backup (if you have a backup of the files, rather than a backup of the DB). 4) If none of that works, then call Defect Support (1-800-237-5511) and see if they have any additional ideas. Anybody else have some other ideas? If you look back under previous appends, I think you'll find several other people who have had the same problem, and what they did to fix it. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 21:02:01 on 92/08/27 GMT (by DINAHA at RALYDPD4) Subject: RDS to OS/2 2.0 Server Ref: Append at 20:49:16 on 92/07/22 GMT (by ERWIN at RHQVM16) I have put together a document on how to access a ES 1.0 OS/2 2.0 database server from both a ES 1.0 OS/2 2.0 client and a OS/2 1.3 client. I am using the defaults (NETBIOS from the 2.0 and SQLLOO from the 1.3). I will be glad to share that with you and welcome any comments as to its worth. Just drop me a line if you would like this. Thanks. ----- OS2DBM CFORUM appended at 11:35:26 on 92/08/28 GMT (by FOREMAN at GDLVM7) Subject: IMPORT What does QM IMPORT look for in a date field? I'm trying to import an ASC file with dates. I keep getting: SQL0180N the date/time string is not in the proper format. I have tried YYMMDD, YY/MM/DD MM/DD/YY and YYYYMMDD, all to no avail. I cannot find any documentation either on-line or hard-copy that explain what the program is looking-for, or how to tell it what to expect in the input. D. J. Foreman ----- OS2DBM CFORUM appended at 15:42:32 on 92/08/28 GMT (by VERSTEEG at UITVM1) Subject: IMPORT Ref: Append at 11:35:26 on 92/08/28 GMT (by FOREMAN at GDLVM7) These should all work with the default profile: 12-31-1991 1991-12-31 12/31/1991 Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 19:26:14 on 92/08/28 GMT (by IL12431 at OS2CUST) Subject: Evaluating contention performance Does DBS log lock contention events and/or other resource access events? I need a utility or function showing me the sum and average of record/table lock request conflicts. I have a business need for this information to determine DBM configuration parameters for our product. The current REXX functions at best show me current connections. Is there something available, either internally or on the market, that logs events as they happen? Dave Scheffer ----- OS2DBM CFORUM appended at 23:53:09 on 92/08/28 GMT (by IL78568 at OS2CUST) Subject: ES DBM Documentation I have finally gotten around to trying to set up up ES 1.0 DBM and DDCS/2 to access DB2, and code some simple accesses from OS/2. The amount of documentation I received with ES was a little intimidating, so I just got started this week. Firstly, I would think that some (most?) of this documentation could have been online. But what I find REALLY irritating is that various places in the documentation refer me to the ES 1.0 DBM Programming Guide and Reference. With all the other manuals that I doubt I will ever need to look at, one of the most (if not the MOST) important manual needed for using DBM is missing (an expensive extra cost item). Could someone explain the rationale for this packaging decision? I'm so paranoid, sometimes I think these things happen just to irritate me<g>. I did find a draft version from last year which was printed out locally for those of us in the EEP, but I find the omission from the GA package (misguided, irritating, parsimonious, incompetent, all of the above), take your pick. Brooks McNeely - Martin Marietta Energy Systems, Inc. ----- OS2DBM CFORUM appended at 16:31:51 on 92/08/29 GMT (by TCSC086 at OS2CUST) Subject: ES DBM Documentation Ref: Append at 23:53:09 on 92/08/28 GMT (by IL78568 at OS2CUST) Brooks, As a customer, I share your irritation. I also extend it to the COMM mgr guides, admin guides, etc. I think a better idea would be kits setup like: OS/2 2.0: the Base package and docs (if you can call them docs!) OS/2 2.0 AND Extended Services 1.0 END USER: All in one kit OS/2 2.0 AND Extended Services 1.0 DEVELOPMENT: The programming guides, the technical library, BBS numbers, EVERYTHING that is really needed when you begin development. OS/2 2.0 AND Admin Kit: Put Help Desk, Training materials, operation hints, etc in this one.NOT the programming guides! IBM has done a great job at spelling out the CUA User, Programmer, and Designer MODELS. Now if they would SHIP their products in a manner that conforms to those MODELS!!Instead I scan read.me, ipf,hlp, txt, ANYTHING to make sure I have the latest, greatest, or most appropriate documentation. Flame off. Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 12:10:50 on 92/08/31 GMT (by FOREMAN at GDLVM7) Subject: IMPORT Ref: Append at 15:42:32 on 92/08/28 GMT (by VERSTEEG at UITVM1) Thanks Anton. Are these documented anywhere? D. J. Foreman ----- OS2DBM CFORUM appended at 16:14:19 on 92/08/31 GMT (by FOREMAN at GDLVM7) Subject: handling tables I've just created 2 tables and a view that includes all of both tables (joined by a single column). What I have is: TABLE-a TABLE-b item# det1 det2 det3 item# det1 VIEW-1 item# TABLE-b/det1 TABLE-a/det2 det3 ... where det1 in TABLE-a is empty (due to my IMPORT actions). Is there some way I can get the TABLE-b/det1 col combined or moved into the TABLE-a/det1 such that the result is a true table, not a view? (Or is there some way to save the view as a true table, so I can delete TABLE-a and -b?) D. J. Foreman ----- OS2DBM CFORUM appended at 16:41:19 on 92/08/31 GMT (by VIEIRA at STLVM7) Subject: QRW2272W-0014 Attempting to access a remote database, the error QRW2272W with a rc=14 is returned. Both server and requester are running OS/2 2.0. I've referenced the related SQL30080N message and the Extended Services READ.ME file. I've increased the Maximum Sessions, Commands, and Names on both the server and requester to 150, 150, and 100, respectively. Still, the error persists. The server is both a LAN server and database server. I can successfully access a database on another server, though, so the problem would appear to be with the first server, not the requester. Any help would be appreciated. Davide B. Vieira ----- OS2DBM CFORUM appended at 17:09:25 on 92/08/31 GMT (by UBIQUITY at AUSVM1) Subject: handling tables Ref: Append at 16:14:19 on 92/08/31 GMT (by FOREMAN at GDLVM7) Create a table_c that looks just like table_a. Then: INSERT INTO TABLE_C (SELECT * FROM VIEW_1) If you want, you can then delete all the rows in table_a, insert the rows from table_c, and drop table_b and table_c. (This will automatically drop view_1). Richard D. Hoffman ----- OS2DBM CFORUM appended at 18:20:47 on 92/08/31 GMT (by FOREMAN at GDLVM7) Subject: handling tables Ref: Append at 17:09:25 on 92/08/31 GMT (by UBIQUITY at AUSVM1) Thanks Richard! Is it possible to do the insert directly into Table-a, from -b since the column with this data is empty? DO the column names need to match? What do I do if they don't? D. J. Foreman ----- OS2DBM CFORUM appended at 19:00:46 on 92/08/31 GMT (by UBIQUITY at AUSVM1) Subject: handling tables Ref: Append at 18:20:47 on 92/08/31 GMT (by FOREMAN at GDLVM7) Sorry, but you can only insert from a subselect. To do what you want, you would need to be able to update from a subselect. This is a known requirement, but not something which will available any time soon. Richard D. Hoffman ----- OS2DBM CFORUM appended at 19:02:57 on 92/08/31 GMT (by UBIQUITY at AUSVM1) Subject: handling tables Ref: Append at 18:20:47 on 92/08/31 GMT (by FOREMAN at GDLVM7) I forgot to answer your other question. The column names don't have to match. The first column from the SELECT will be inserted into the first column of the table, the second column into the second, and so on. Richard D. Hoffman ----- OS2DBM CFORUM appended at 19:45:42 on 92/08/31 GMT (by FOREMAN at GDLVM7) Subject: handling tables Ref: Append at 19:02:57 on 92/08/31 GMT (by UBIQUITY at AUSVM1) Thanks again Richard. How can I write the SELECT so that the columns don't have to line up. My example was, unfortunately, over-simplified. The column I want to overlay is not the 1st column in Table-a, but it is the 1st column in Table-b. Also, is there some sort of syntax like: INSERT INTO col3 OF TABLE_A (SELECT col2 FROM TABLE_B) ? D. J. Foreman ----- OS2DBM CFORUM appended at 20:48:36 on 92/08/31 GMT (by KDROMREL at SFOVMIC1) Subject: QRW2272W-0014 Ref: Append at 16:41:19 on 92/08/31 GMT (by VIEIRA at STLVM7) I've seen at least two other causes of this error: 1) StartDBM has not been issued at the Server when Start Using is issued from the Client 2) The catalog structure was incorrect. In our case, the Server nname that we included in our Catalog Workstation command did not match the actual nname at the server (this can be checked by bringing up the Config Tool on the Server, selecting Change Database Manager, and then checking the first parameter - Workstation name or nname. Anybody else seen anything else? Kelvin D. Romrell ----- OS2DBM CFORUM appended at 21:57:55 on 92/08/31 GMT (by UBIQUITY at AUSVM1) ..... OS2DBM CFORUM modified at 14:46:53 on 92/09/01 GMT (by UBIQUITY at AUSVM1) Subject: handling tables Ref: Append at 19:45:42 on 92/08/31 GMT (by FOREMAN at GDLVM7) The syntax for insert from subselect is: INSERT INTO <table> (<col>, <col>, ...) (<select stmt>) If the columns in the select list match those in <table>, you may omit the list of columns. For example: I have tables X (A, B, C) and Y (C, A, B) and want to copy Y into X. I can either: INSERT INTO X (C, A, B) (SELECT * FROM Y) |oops or INSERT INTO X (SELECT A, B, C FROM Y) The parentheses around the select statement may be optional, but I always put them in (that way I don't have to remember when they are optional). Richard D. Hoffman ----- OS2DBM CFORUM appended at 08:56:45 on 92/09/01 GMT (by EDWARDG at ASICVM1) Subject: 1.3 EE requestor talking to 1.3 ES server I am having trouble getting RDS working between a requestor running OS/2 1.3 EE and a server running os/2 1.3 ES. I believe this configuration is possible? I am deep up LU's and PU's and whether the server should be an End-Node or a Network-Node ? Has anyone got any configuration files for this setup they could send me? Thanks Gabrielle Edwardes ----- OS2DBM CFORUM appended at 11:48:30 on 92/09/01 GMT (by FOREMAN at GDLVM7) Subject: handling tables Ref: Append at 21:57:55 on 92/08/31 GMT (by UBIQUITY at AUSVM1) So, if I interpret this correctly, I could: INSERT INTO X (A, B, C) (SELECT M, N, O FROM Y) D. J. Foreman ----- OS2DBM CFORUM appended at 14:47:32 on 92/09/01 GMT (by UBIQUITY at AUSVM1) Subject: handling tables Ref: Append at 11:48:30 on 92/09/01 GMT (by FOREMAN at GDLVM7) Right! Richard D. Hoffman ----- OS2DBM CFORUM appended at 15:06:42 on 92/09/01 GMT (by VENDENA at DALVM41B) Subject: QRW2272W-0014 Ref: Append at 16:41:19 on 92/08/31 GMT (by VIEIRA at STLVM7) Did you increase SESSION, NAMES, and COMMANDS on both the client and the server? If the request seems to be getting to the server (takes a little time, server's hard drive light blinks), then the client's NETBIOS resources are probably ok, but the server's need to be increased. Hope this helps. Dena Laterza - OS/2 Application Assistance Center, Dallas ----- OS2DBM CFORUM appended at 15:13:51 on 92/09/01 GMT (by FMMARTI at CHGVMIC1) Client Application Enablers Does anybody have a list of front end tools that will work with these enablers in a DOS or Windows e3nvironment? Also, does anyone know if there is better documentation dor the use of these enablers than: Guide to Database Manager Client Application Enablers (S04G-1114) If anyone can help please contact me at: 8/261-5142 FMMARTI at CHGVMIC1 Thanks- Frank Martin ----- OS2DBM CFORUM appended at 15:48:39 on 92/09/01 GMT (by FOREMAN at GDLVM7) ..... OS2DBM CFORUM modified at 11:27:14 on 92/09/29 GMT (by FOREMAN at GDLVM7) Subject: handling tables Ref: Append at 14:47:32 on 92/09/01 GMT (by UBIQUITY at AUSVM1) Thanks Richard. That helps a lot. I now have a working table, with everything in it that I need. | Additional comments deleted by appender. D. J. Foreman ----- OS2DBM CFORUM appended at 20:22:30 on 92/09/01 GMT (by TCC3824 at OS2CUST) Subject: Unsuccessful Logon using RDS with APPN Ref: Append at 22:44:36 on 92/08/20 GMT (by FCOC079 at OS2CUST) Where did you find the doc on how to set up the TP for RDS and APPN? Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 20:28:32 on 92/09/01 GMT (by TCC3824 at OS2CUST) Subject: Limit on number of Insertions Ref: Append at 12:38:49 on 92/08/27 GMT (by IL03484 at OS2CUST) There is a problem with ES DBM when inserting > 190,000 rows into a table. I reported the problem 2 month ago and I am still waiting for the fix. It is problem #4x632 if you want to get on the interested parties list. Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 20:41:17 on 92/09/01 GMT (by TCC3824 at OS2CUST) Subject: ARI and C SET/2 FYI!! As of 9/1/92 there is a bug with DBM ARI and C SET/2. The following PTR is being worked on by IBM. R: We have determined that there is a problem with DBM. Currently there is a PTR 4N00077 opened with development to provide a fix. Please contact your local IBM Support office and they will send out the fix as soon as it is ready. Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 01:03:17 on 92/09/02 GMT (by SJENNING at DETVMIC4) Subject: Problems with binding to a local database My customer is having a problem binding a bind file to a local database. When the SQLBIND command is issued, a message is written indicating the bind process has occurred. After this, the system locks up - No commands can be entered by the keyboard. The system must be rebooted. Has anyone experienced this problem? Thanks Suzanne Jennings IBM - SE Detroit ----- OS2DBM CFORUM appended at 03:46:59 on 92/09/03 GMT (by AUWHENRY at HKGVM8) Subject: Importing non-del ASCII to DB via DBM I encountered the following error message when importing a non-delimited ASCII file into an OS/2 ES database table using the DBM SQL command: DBM IMPORT TO edp FROM c:\test\test.dat OF ASC REPLACE INTO test MESSAGES c:\test\dbm.msg Error message : SQL3400N. The error message indicates that I need to specify the column location. Can anyone tell me how I can specify the location using the DBM IMPORT command without writing any C or REXX program ? Thanks. ----- OS2DBM CFORUM appended at 12:24:39 on 92/09/03 GMT (by TGILES at HVTVM) - Subject: Changing ENTIRE Database Code Page Ref: None I have to ask this again since IT'S AN URGENT REQUIREMENT and previous answers aren't completely satisfactory. I have a database on one machine with codepage 437 and wish to change it to codepage 850. I know about Import/Export, but haven't found how to specify FORCEIN, and the OS/2 2.0 SELECT Parameter restricts the operation to tables. What I need to do is convert THE ENTIRE DATABASE. Could someone outline the steps necessary to perform this task. Trevor Giles, Havant Site x4245 ----- OS2DBM CFORUM appended at 13:52:09 on 92/09/03 GMT (by MOODY at BLDVMA) - Subject: Resetting DBM Logon Password Can anybody out there tell me how I can reset the Logon Password so that I can get to the existing databases? Jim Moody BLDVMA(MOODY) Tie 263-9228 Boulder, Co ----- OS2DBM CFORUM appended at 18:32:46 on 92/09/03 GMT (by FOREMAN at GDLVM7) Subject: Resetting DBM Logon Password Ref: Append at 13:52:09 on 92/09/03 GMT (by MOODY at BLDVMA) Try logging on as: userid=USERID password=PASSWORD assuming you haven't deleted it already. D. J. Foreman ----- OS2DBM CFORUM appended at 19:23:13 on 92/09/03 GMT (by ROBERT at TOROLAB4) Subject: IMPORT Ref: Append at 12:10:50 on 92/08/31 GMT (by FOREMAN at GDLVM7) A detailed description is contained in the SQL Reference, under the heading 'Data Types', pages 18 through 22. Note that table 3 on page 22, lists valid and default date formats for your country. The formats are described in table 1 on page 20. Robert Begg ----- OS2DBM CFORUM appended at 19:32:28 on 92/09/03 GMT (by ILLP099 at OS2CUST) Subject: Packed Decimal What compiled languages available for OS/2 2.0 have a data type which is compatible with the DECIMAL data type of Database Manager? Are there any extensions to IBM "C" which will accomodate DECIMAL? ----- OS2DBM CFORUM appended at 19:35:20 on 92/09/03 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Documentation Ref: Append at 16:31:51 on 92/08/29 GMT (by TCSC086 at OS2CUST) Hi, I'm a writer for the next release of the OS/2 Database Manager. We have been following this forum, and thought it was time to say hello. I would like to thank the submitters of the two referenced appends for taking the time to express there opinions/fustrations about ES DBM Documentation. Your comments are well noted, and we encourage all readers of this forum to comment on the documentation. Robert Begg Toronto Laboratory ----- OS2DBM CFORUM appended at 20:22:51 on 92/09/03 GMT (by FOREMAN at GDLVM7) ..... OS2DBM CFORUM modified at 11:14:58 on 92/09/04 GMT (by FOREMAN at GDLVM7) Subject: IMPORT Ref: Append at 19:23:13 on 92/09/03 GMT (by ROBERT at TOROLAB4) Thanks Robert. That'l help me next time. D. J. Foreman ----- OS2DBM CFORUM appended at 21:19:29 on 92/09/03 GMT (by FMMARTI at CHGVMIC1) Subject: Client Application Enablers Hello all- I was wondering if anyone has used the Client application enablers that are available for ES 1.0. I am trying to demo to the customer that ES supports these environments, however, all I have found is a very small document about how to use these enablers. Is there anyone that has any info to share? Is there any better documentation? Also, does anyone have the DOS or WINDOWS code that is required to catalog the databases? If you are running OS/2 (with DOS and WINDOWS) do you even need this code(since you can catalog a database with QM)? When I logon to the database with the SQLLOGON2 command, it will except anything that I enter, and when I try to run the STARTDRQ command I get a SQL1042C error. Any suggestions? If anyone has anything to share please contact me at: 8/261-5142 or FMMARTI at CHGVMIC1 Thanks - Frank Martin ----- OS2DBM CFORUM appended at 06:48:38 on 92/09/04 GMT (by NURMELA at HEKVM) Subject: Unsuccessful Logon using RDS with APPN Ref: Append at 20:22:30 on 92/09/01 GMT (by TCC3824 at OS2CUST) I want to know the answer, too. I have been looking for that information in all the OS/2 manuals I have (about 1.5 shelf meters). Jouni Nurmela Finland ----- OS2DBM CFORUM appended at 06:53:10 on 92/09/04 GMT (by NURMELA at HEKVM) Subject: 1.3 EE requestor talking to 1.3 ES server Ref: Append at 08:56:45 on 92/09/01 GMT (by EDWARDG at ASICVM1) After a long struggle I got ES to ES APPC connection working (adding the TP definitions in the server did the trick). I am still out of luck with EE to ES APPC connection. If somebody has got it working, please, share your knowledge with the rest of us. Jouni Nurmela Finland ----- OS2DBM CFORUM appended at 10:51:50 on 92/09/04 GMT (by VERSTEEG at UITVM1) Subject: IMPORT Ref: Append at 20:22:51 on 92/09/03 GMT (by FOREMAN at GDLVM7) It might not be that obvious but the import utility is a DBM utility, not a QM utility. All QM provides is a front-end to that utility. Any checking, converting, etc. happens in DBM components. This is one of the reasons why REXX is such a good language to invoke these utilities, as any REXX overhead, as compared to compiled code, will be minimal, because 99% of the time is spent within DBM. A Master index would be nice though, I agree. Robert? Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 16:11:32 on 92/09/04 GMT (by 62493274 at EHONE) Subject: SQL1042 Error and Data Change Hello, My customer has installed OS/2 DBM and its production databases without configuring the OS/2 system date. When we set the correct date, DBM failed with SQL1042 errors (it took us hours to find how why - until I came back to my office and looked in this forum. I now see it's in the manual 'Product Supplemental Information' - but who will look into this manual ? Shouldn't it be instead with the online message information ??) We corrected the situation by going back to the default date - which in fact is the year 2000. The customer however wants to set the correct date. How can we set the date to 1992 without losing DBM and its databases ? (we already tried to remove and reinstall DBM, but it's not enough) Best regards, Pierre Willems - IBM Belgium ----- OS2DBM CFORUM appended at 18:47:49 on 92/09/04 GMT (by XXNOVA24 at TORVMCOP) Subject: ES DBM Documentation Ref: Append at 19:35:20 on 92/09/03 GMT (by ROBERT at TOROLAB4) Robert, DBM from Toronto? I taught it is comming from somewhere Austin.Anyway, Will we get a nice PM installation , Query manager for the next release? When will it be 32 bit (incl performance and API calls?) Can we get a few PM-C/set2 , some REXX and some SOM examples in the Toolkit for calling the DBM ? Regards, Geza Szivos NOVACOR Chemicals (403)-290-6583 NHO-32 801-7th Ave Calgary, Alberta, CANADA T2P 2N6 ----- OS2DBM CFORUM appended at 21:38:10 on 92/09/04 GMT (by NAAO3IY at OS2CUST) Subject: Packed Decimal Ref: Append at 19:32:28 on 92/09/03 GMT (by ILLP099 at OS2CUST) SQL and the DBM can automatically perform the conversion for you, so you can just make the DECIMAL fields double or long double in C. That introduces a small possibility of a rounding error, but of course that would be true whether you were using DBM or not. I believe MicroFocus COBOL (which is IBM's official choice of COBOL for OS/2) should support DBM SQL DECIMAL. There is supposed to be an IBM PL/I compiler for OS/2, based on the same technology as the C-Set/2 compiler, announced during the month of September. That should probably have decimal support, and when DBM gets around to supporting it (maybe sooner, maybe later, maybe it's already there and undocumented -- I don't know), that should work. I'm not an IBMer, though. John Kennedy -- Hoechst Celanese, Bridgewater, NJ ----- OS2DBM CFORUM appended at 14:09:36 on 92/09/08 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Documentation & Future Releases Ref: Append at 18:47:49 on 92/09/04 GMT (by XXNOVA24 at TORVMCOP) Geza, Yep, OS/2 DBM is now owned by Toronto, recently moved from Austin. (We also own SQL/DS, the VM database) Please don't ask any questions about the future!! I can't answer them, ... but Please tell me what you think should be in future releases, all will be considered when making decisions. RE: Examples, this is a known requirement. I suggest that you bug your IBM Rep, for any example sets that may be available internally ( There are lots of good REXX ones). There is an OS2DEV forum on Compuserve, with a growing DBM section, examples may appear there also. *** I would like to hear from anyone reading this forum, how you *** are using DBM and what types of examples would be most useful. *** Reply directly to me if there is no added value for this forum. Robert Begg ----- OS2DBM CFORUM appended at 14:22:06 on 92/09/08 GMT (by ROBERT at TOROLAB4) Subject: Packed Decimal Ref: Append at 21:38:10 on 92/09/04 GMT (by NAAO3IY at OS2CUST) The DBM Programming Guide & Reference contains a "Supported SQL Data Types" section for each Host language chapter. Robert Begg ----- OS2DBM CFORUM appended at 19:40:12 on 92/09/08 GMT (by NBLKCY0 at OS2CUST) Subject: Import/Export QM Objects? In Query Manager there are facilities to import and export objects such as panels, forms, queries. This leads me to believe there is an API available for performing these functions. I have found nothing in any documentation that indicates how this can be done through REXX or a C program. Has anyone done this or found a utility that will do this? My need is to migrate objects from a test database to a production database without a lot of manual work. John Wilson - Citizens Fidelity Bank ----- OS2DBM CFORUM appended at 20:07:56 on 92/09/08 GMT (by GBFORNEY at WASVMIC5) Subject: Import/Export QM Objects? Ref: Append at 19:40:12 on 92/09/08 GMT (by NBLKCY0 at OS2CUST) What you don't see from Query Manager is the table called QRWSYS.QRWSYS_OBJECT You can export and import this one table from either C or REXX. Everything defined within QueryManager is contained with-in it. Greg Forney bigred@vnet.ibm.com ----- OS2DBM CFORUM appended at 01:56:53 on 92/09/09 GMT (by KDROMREL at SFOVMIC1) Subject: Changing ENTIRE Database Code Page Ref: Append at 12:24:39 on 92/09/03 GMT (by TGILES at HVTVM) Try this: - Create a new database with cp 850 - Access your old DB using QM under cp 437 - Export all tables to IXF format. - If you have QM objects also export QRWSYS.QRWSYS_OBJECT from the QM command line. - CHCP 850 - Start QM and open the new database - Select Profiles from the main menu and set 'Compare code page on import' to No. - Save and activate the profile. - Import all tables It's worked for me. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 10:36:32 on 92/09/09 GMT (by 86495750 at EHONE) Subject: Porting of mainframe reports and queries I have a customer starting out on the downsizing road. He likes DBM very much but complains that one of his main requirements is the porting of his existing QMF reports and queries to QM. Is it really such a hastle to do this porting? and are there not perhaps tools available to help out? Jonathan ----- OS2DBM CFORUM appended at 12:54:28 on 92/09/09 GMT (by DINAHA at RALYDPD4) Subject: Resetting DBM Logon Password Ref: Append at 13:52:09 on 92/09/03 GMT (by MOODY at BLDVMA) I got this from ASKQ on HONE. We tried once and it worked successfully. Of course, this was with OS/2 1.3. I am now at OS/2 2.0 and ES 1.0 and have not had an occasion to use. Perhaps this will help. Better than recreating a large database. ---------- ---------- ---------- --------- ---------- ---------- We were able to reset the workstation UPM default id by rebuilding the MUGLIB directory. We booted the workstation with the install the MUGLIB directory. We booted the workstation with the install diskette, ESC to the a:> prompt, changed drive and set MUGLIB as the default directory. We deleted all the files except SYSLEVEL.MUG, copied UNPACK.EXE from diskette 1, and unpacked the UPM, MUG & LOG files from diskette 6. The files that were not in the original group of 13 in the MUGLIB directory were erased and the workstation was booted. When we tried to access OS/2 Database Manager, we used the default USERID/PASSWORD combination and it worked this time. We could get to the databases with no problem and did not loose any access privileges. We were also able to sign on to the LAN Requester with the different LAN id/password and all worked well. ----- OS2DBM CFORUM appended at 22:06:08 on 92/09/09 GMT (by MBCSQ11 at OS2CUST) Subject: 1.3 EE requestor talking to 1.3 ES server Ref: Append at 08:56:45 on 92/09/01 GMT (by EDWARDG at ASICVM1) Do you have this working yet? We are running a CASE tool, Excelerator Series II, which uses a Database Manager database on a server for concurrent data access. We have a mixture of just about every combination of 1.3EE, 2.0, 1.0ES, etc... Not having any manuals or training classes available at the time I needed to do this, I simply set up the simply like this: Configure the database server with 1.3EE and 1.0ES. As part of this process, you will be defining a CM configuration file which includes the "old" RDS method - namely, the LU1, LU2, SQLLOO method. Then apply 1.0ES. The install process will remove the EE component but will migrate the configuration file so that support for implicit lu partners looking for LU2 and transmission service mode SQLLOO will succeed. Now you will have covered the EE requesters. As for the ES requesters, we set up a server machine as a network node to do the intelligent APPN routing stuff. We defined each ES requester to that server and got an active CM link going. (We also had to define each ES requester as END-NODE with NETWORK-NODE server to get the requester link up). Have your database server also as an end-node to the network-node. Now you should be able to support the ES requesters also!! Brian Treptow Senior Technical Analyst, Miller Brewing Company ----- OS2DBM CFORUM appended at 20:29:17 on 92/09/10 GMT (by IL71329 at OS2CUST) Subject: es 1.0 database backup fails I'm using a userexit called from DBM to backup databases. If the backup fails because a tape is not mounted or someone is logged on, etc the backup pending f lag is set. Is there a way to turn off this flag without completing another bac kup? Becky Epping Country Companies Ins. Bloomington, IL ----- OS2DBM CFORUM appended at 09:35:24 on 92/09/11 GMT (by 62449439 at EHONE) Subject: How to change country code for a Database Is it possible to change the country code or to backup and restore this database with another country code. The database was created on a PS/2 with country code=044 but we have now to use it on other PS/2 with country code=032. I know that the DB country code information is kept in the SQLCON file but I don't know how to change the information. ----- OS2DBM CFORUM appended at 09:37:11 on 92/09/11 GMT (by 62425865 at EHONE) Subject: Query Manager for GRAPHIC Using the Database Manager under OS/2 V2, I tried to display a graphic after execution of a query. The installation is OS/2 V2 & Extend. Serv. (no tools or anything else) I got the following message (no message number) 'The system could not load the graphics program' 'or the graphics interface module because it is not' 'installed correctly.' Do I need a complementary program/interface .... ? Could somebody explain what do I need to do to solve this problem ? Thanks in advance for any help. P. de Theux (DETHEUX @ BRUVMIS1) ----- OS2DBM CFORUM appended at 09:38:13 on 92/09/11 GMT (by ADAMSK at DUBVM1) SUBJECT: Dos Remote W/S - Link Errors I am currently recompiling some OS/2 SQL C code for running under DOS, accessing a remote OS/2 ES DBM server via Netbios connection, but I am having problems with the PCDRSTAT.LIB file. I am using IBMC/2 ver 1.1. When linking, I include the PCDRSTAT.LIB file and LLIBCE.LIB which comes with IBMC/2. Initially I got a lot of Link errors, (Symbols defined more than once), and I am asked for LLIBCA.LIB, which I do not have. If I specify the Link Option /NOD (No default Libraries), I get 12 unresolved externals, for the PCDRSTAT.LIB file. It looks like I need the LLIBCA.LIB file, but that is not installed with C2. Has anyone any suggestions, or answers to my problem. If more information is needed please ask. Best regards, Kevin Adams (adamsk at dubvm1) ----- OS2DBM CFORUM appended at 09:40:50 on 92/09/11 GMT (by 62449439 at EHONE) Subject: How to get data from the DB in an query manager procedure ? Is there a way to get a variable from the DB and assign his value to a local or global variable without using a panel and without using a REXX program, only using the query manager features ? ----- OS2DBM CFORUM appended at 11:20:29 on 92/09/11 GMT (by JBRAUER at STUTVM3) ..... OS2DBM CFORUM modified at 11:35:58 on 92/09/11 GMT (by JBRAUER at STUTVM3) Subject: Query Manager for GRAPHIC Ref: Append at 09:37:11 on 92/09/11 GMT (by 62425865 at EHONE) | Note: The original author of this Q+A is Anton Versteeg. *** QUESTION *** How can I enable the 'Graph' option on a report in Query Manager? *** ANSWER *** The Graph Option isn't supported by Query Manager directly. Vendors can develop an adequate SW product and link it to Query Manager under QM's Graph menu item. Thus, this Vendor Graph product has to be purchased separately. The only package currently available is Perspective for OS/2 by Three D Graphics. phone: (213) 459-7949 For more info see the Personal Systems Developer, Summer 1989 issue. ____________________________________________________________ Joachim Brauer, IBM I/S Applications M&S, Ehningen (Germany) ----- OS2DBM CFORUM appended at 11:34:52 on 92/09/11 GMT (by JBRAUER at STUTVM3) Subject: How to get data from the DB in an query manager procedure ? Ref: Append at 09:40:50 on 92/09/11 GMT (by 62449439 at EHONE) The following example, originally an answer to another problem, but also retrieving data from a table into a procedure variable, should give you an idea how to do it in QM. Pitfall: A panel is a prereq to achieve it in QM. Note: The original author of this Q+A is Anton Versteeg. *** QUESTION *** How can I add records to a table using QM panels and automatically sequence numbers? *** ANSWER *** That should be possible using QM panels and procedures: Suppose we have a column SEQNO in TABLE TAB1. /* Main procedure */ 'RUN QUERY MAX (REPORT=NO' /* SELECT MAX(SEQNO) FROM TAB1 */ 'SAVE DATA AS TEMP (CONFIRM=NO REPLACE=YES' 'RUN PANEL MAXTEMP (MODE=CHANGE' /* GET MAX INTO GLOBAL VAR */ 'RUN PANEL ENTRY (MODE=ADD' /* DO THE ACTUAL DATA ENTRY */ Panel MAXTEMP is defined on the temporary table TEMP created by save data. Use the Default panel definition and add an initial search query name that points to a query that does a SELECT * FROM TEMP In the panel rules add a procedure for change. This procedure is called before the panel is displayed and should do: /* TEMP proc */ 'GET CURRENT (N=FIELD1' 'SET GLOBAL (NEXT=N' 'QUIT PANEL' Panel ENTRY is defined on the table TAB1. It should have an initial procedure for Add (in panel rules). This procedure will get control before the panel is displayed: /* Add instance rule */ 'GET GLOBAL (N=NEXT' N=N+1 'SET GLOBAL (NEXT=N' 'SET CURRENT (FIELD2=N' Note: This works only in a single user environment. In a multi-user environment, you cannot save the sequence number in a global variable. ____________________________________________________________ Joachim Brauer, IBM I/S Applications M&S, Ehningen (Germany) ----- OS2DBM CFORUM appended at 13:17:38 on 92/09/15 GMT (by TCSC121 at OS2CUST) Subject: C/Set 2 and Database Manager Ref: Append at 21:33:55 on 92/06/02 GMT (by VENDENA at DALVM41B) Is there something undocumented ? I thought I was progressing but now I am confused. I'm willing to look at anything at this point. Other than ES32TO16 are there more special stuff for C/set 2 and DBM ? Dave Lauta Time Customer Service ----- OS2DBM CFORUM appended at 14:18:35 on 92/09/15 GMT (by FCOC079 at OS2CUST) Subject: C/Set 2 and Database Manager Ref: Append at 13:17:38 on 92/09/15 GMT (by TCSC121 at OS2CUST) Following is one way to invoke the C-Set/2 compiler for a program which has SQL statements in it and makes DBM API calls: ICC.EXE /DES32TO16 /O /Ge- /Gt /C .\$*.c The "/Gt" is for tiled memory (keeps memory objects from crossing 64-k bound- aries. Also, if you're making DBM API calls (other than those generated by SQLPREP), make sure that pointers passed to DBM are of type "_Seg16". I did have trouble with the migration libraries, so I didn't use them, but did a #define far FAR after including the headers to make things compile ok. Dave Boll ----- OS2DBM CFORUM appended at 19:23:35 on 92/09/16 GMT (by KUSTERER at MANVM1) Subject: Dos Remote W/S - Link Errors Ref: Append at 09:38:13 on 92/09/11 GMT (by ADAMSK at DUBVM1) Kevin, I think I know what your problem is and I don't think you'll like the answer. I was trying to do exactly the same thing that you are, that is, generating C code for DOS with C/2. The first thing I ran into was the missing LLIBCA.LIB. C/2 does contain this library, you just have to specify using the Alternate floating point stuff as opposed to the Emulated stuff (hence the A instead of the E) when you build your combined libraries. BUT... this still didn't fix the problems. I still got the unresolved externals in PCDRSTAT.LIB just like you did. The only thing I found to fix it was to use version 6 of the C compiler from Microsoft, like the documentation says to, and, poof, everything works great. Joe Kusterer ----- TEAM OS/2 Northern VA ----- FSC Manassas ----- OS2DBM CFORUM appended at 13:56:15 on 92/09/17 GMT (by ERICKSON at TDCSYS3) Subject: Database Mgr Performance Ref: Append at 13:40:11 on 92/06/02 GMT (by VERSTEEG at UITVM1) Earlier in the referenced append, the "Comprehensive Database Performance for OS/2 2.0's Extended Services" manual (ISBN 0-442-01325-6) was referenced with an IBM publications number "G362-0012". This number is not valid in the PUBORDER system within the USA. Was it omitted from our system accidentally, have I waited too long and had the publication go out of stock, or is there another number valid within the USA? Thanks, Marc R. Erickson ----- OS2DBM CFORUM appended at 14:29:55 on 92/09/17 GMT (by MALKEMUS at TOROLAB3) Subject: Database Mgr Performance Ref: Append at 13:56:15 on 92/09/17 GMT (by ERICKSON at TDCSYS3) None of the above! It's not in print yet. Due this month, last I heard. I don't know how long it will take for puborder to have it, once the book is published. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 15:14:32 on 92/09/17 GMT (by F079128 at DCTVM3) Subject: Computer Asset Inventory Has anyone heard of an application, using OS/2 DBM, that allows inventory management of a company computer assets ? Thanks in advance, Nicolas Polin - IBM France - (33) 1.49.05.61.51 ----- OS2DBM CFORUM appended at 15:53:31 on 92/09/17 GMT (by FRMLSPA at OS2CUST) Subject: Limit on number of Insertions Ref: Append at 20:28:32 on 92/09/01 GMT (by TCC3824 at OS2CUST) Is this a problem of a limit to the number of insertions prior to a commit? Is your app trapping? I've run into a problem during imports where if the logs fill, it traps. Expanding the logs corrected the problem. We've run some pretty big imports. Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 16:03:19 on 92/09/17 GMT (by XXNOVA24 at TORVMCOP) Subject: Computer Asset Inventory Ref: Append at 15:14:32 on 92/09/17 GMT (by F079128 at DCTVM3) Nop. But we (I) have to create one in less than two months.<g> Geza Szivos NOVACOR Chemicals (403)-290-6583 NHO-32 801-7th Ave Calgary, Alberta, CANADA T2P 2N6 ----- OS2DBM CFORUM appended at 16:32:18 on 92/09/17 GMT (by FRMLSPA at OS2CUST) Subject: sqlacall( SQLA_OPEN, .... using up file handles Ref: Append at 18:55:34 on 92/08/24 GMT (by CHALTAIN at FSHVMFK1) I had this problem with my DBM programs using MS C 6.0's fopen() and fprintf() functions. My programs worked fine with EE 1.3, however, ES 1.0 seemed to take a couple more file handles. My problem was that when my app first started, I could open and close files (to write messages to app log files), however, after I performed a second commit (every 5000), DBM sucked up the rest of the 20 available file handles. I increased the DBM parameter for file handles an app can have to no avail. Then I searched Equal and found this same problem. The problem is that DBM uses close to or all of 20 file handles. MS' fopen() function can only work with 20 file handles. There is no way to set more than 20. The recommendation was to use DosOpen() instead of fopen() and DosWrite() instead of fprintf(). If you do this, the default is 20, but you can perform a DosSetMaxFH() function at the top of your code and set it to 40 or something prior to opening and closing files. This does work for me. I just perfer fprintf() to DosWrite(). Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 16:37:55 on 92/09/17 GMT (by TCC3824 at OS2CUST) Subject: Limit on number of Insertions Ref: Append at 15:53:31 on 92/09/17 GMT (by FRMLSPA at OS2CUST) I blow up on running an insert job. I commit every 1,000 rows. It blows up after about 190,000 rows. (table has 800,000 in a 1.3 table). IBM says it is an index bug. Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 17:02:46 on 92/09/17 GMT (by FRMLSPA at OS2CUST) Subject: Limit on number of Insertions Ref: Append at 16:37:55 on 92/09/17 GMT (by TCC3824 at OS2CUST) Can you drop the index and re-add it after the import? We have some tables of that size and haven't encountered any problems except the logs filling. We also got a trap when an insert attempted to put a larger value into a column than the column was defined for (somebody interpreted 8,3 as PIC(8.3)) Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 17:11:06 on 92/09/17 GMT (by FRMLSPA at OS2CUST) Subject: Import/Export QM Objects? Ref: Append at 19:40:12 on 92/09/08 GMT (by NBLKCY0 at OS2CUST) Not only can you export and import the QRWSYS.QRWSYS_OBJECT to backup and/or move all of the QM objects from one DB to another, we've been able to "merge" some or all of the QM objects from one DB with another. You can merge the entire set of QM objects by importing the exported QRWSYS_OBJECT table with APPEND into the target DB. You can merge selected pieces by writing a query to insert into a temp table only those objects matching criteria specified with a where clause. Then export the temp table and import with append. You can also move objects from one qualifier to another by either updating the exported temp table changing the qualifier and then import with append, or (IBM doesn't recommend this one because users could be in it) perform an update directly on the QRWSYS_OBJECT table changing the qualifier. All of these scenarios have worked for us. Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 20:02:39 on 92/09/17 GMT (by FMMARTI at CHGVMIC1) Subject: September issue of PC Magazine Hello all- Has anyone read or been approached about the September issue of PC Magazine? There is a comparison of workstation databases, and the OS/2 DBM does not look all that great. Does anyone know of where I could find some information that would help me answer customer concerns over this article. Thanks Frank Martin 8/261-5142 FMMARTI at CHGVMIC1 ----- OS2DBM CFORUM appended at 18:02:52 on 92/09/18 GMT (by IL78568 at OS2CUST) Subject: EXPLAIN Tool I have seen several references concerning the use of the EXPLAIN tool, which end with the admonition to "be sure to use the July version of the EXPLAIN tool". The last time I saw this was on IBMLink during the last two days. Is there a later version of the tool than the ES 1.0 GA version, or is this a reference to July 1991 before EXPLAIN was included in ES? If there is an updated version, could it be included for download here? Brooks McNeely - Martin Marietta Energy Systems, Inc. ----- OS2DBM CFORUM appended at 23:15:53 on 92/09/19 GMT (by HNDERSON at AUSVM8) ..... OS2DBM CFORUM modified at 21:06:07 on 92/09/28 GMT (by HNDERSON at AUSVM8) Subject: EXPLAIN Tool Ref: Append at 18:02:52 on 92/09/18 GMT (by IL78568 at OS2CUST) Brooks, I will check with one of the authors of this package who is in Austin, if she gives her okay, we will attempt to make it down- loadable from this BBS. | |The EXPLAIN package is included with the EXTENDED SERVICES diskettes | | __ __ ___ __ __ _ _ | |_| | / \ | \| | | |./ / Hank Henderson HNDERSON at AUSVM8 | _ | / _~_ \ Sincerely | . < Staff OSS to OS/2 BBS (TEAMOS2) |__| |__| /_/ \_\ |__|\__| |_| \_\ Tie:8-793-8647 Austin, Texas LNK1SM7 @ IBMLINK - OS/2 BBS ----- OS2DBM CFORUM appended at 03:53:23 on 92/09/20 GMT (by XXNOVA24 at TORVMCOP) Subject: EXPLAIN Tool Ref: Append at 23:15:53 on 92/09/19 GMT (by HNDERSON at AUSVM8) Thanks, Hank. Couls you do the same thing with the SnapDump/2 ? (it was on FTN before and it's in OS/2 dev now ). Geza Szivos NOVACOR Chemicals (403)-290-6583 NHO-32 801-7th Ave Calgary, Alberta, CANADA T2P 2N6 ----- OS2DBM CFORUM appended at 21:29:39 on 92/09/20 GMT (by HNDERSON at AUSVM8) Subject: EXPLAIN Tool Ref: Append at 03:53:23 on 92/09/20 GMT (by XXNOVA24 at TORVMCOP) Geza, and All, I'll see if it is available and post it if ok. __ __ ___ __ __ _ _ | |_| | / \ | \| | | |./ / Hank Henderson HNDERSON at AUSVM8 | _ | / _~_ \ Sincerely | . < Staff OSS to OS/2 BBS (TEAMOS2) |__| |__| /_/ \_\ |__|\__| |_| \_\ Tie:8-793-8647 Austin, Texas LNK1SM7 @ IBMLINK - OS/2 BBS ----- OS2DBM CFORUM appended at 02:17:16 on 92/09/21 GMT (by JWILK at SYDVM1) - Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation I am trying ever so hard to get a DOS application to access an ES Database, which resides on the same workstation. I am however unsure as to wether I have the appropriate S/W and/or H/W..... Question 1) Do I need to have ES with Database Server to get this to work at all ?? Question 2) Do I need to be physically on a LAN to get this to to work, even when I am physically going to the same workstation ?? I guess I'm asking how NETBIOS operates in this environment, ie from a DOS VDM through to an OS/2 process. Does the DOS Netbios VDD go out on a 'real' LAN adapter ??? Question 3) This is related to question 2), but how should I code up the DB catalog function, local or remote ??? Question 4) This is also related to question 2), what should I use as my netbios workstation names, for DOS requestor and OS/2 server, these have to be unique but how to I route my netbios to the 'same' workstation ??? Thanks for any help...... John Wilkinson IBM New Zealand ----- OS2DBM CFORUM appended at 12:54:47 on 92/09/21 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Ref: Append at 02:17:16 on 92/09/21 GMT (by JWILK at SYDVM1) Your question has been partially answered in an internal forum. I will answer what I know, and will post your question there, and a full answer here. (unless someone beats me to it). Yes, what you ask is possible. (I'm going to try it myself) The OS/2 DBM must be a server, and physically on a lan. The request from the DOS session will be sent out on the lan, and the OS/2 server will receive them. Yes, catalog the database on DOS as remote. (Actually on DOS the type is ignored on the catalog call since it has to be remote). What I am unsure about is how you set up the DOS NETBIOS Name etc. Better answer to follow. Robert Begg ----- OS2DBM CFORUM appended at 16:39:38 on 92/09/21 GMT (by TCSC086 at OS2CUST) Subject: VARCHAR confusion in C All, After tromping through the ES Host Language ref for DBM, I came out more confused about type (460,461) VARCHAR than I was BEFORE I read the manual.(Chapter 4 - C Language is my source) If a TABLE has a column defined VARCHAR(n), then is the value returned to the host variable null terminated? (460,461) If a TABLE has a column defined CHAR(n), is the returned value null terminated? (452,453) If you use the SQLDA struct, is the value NULL terminated for either? It does not seem to make any difference if host var declarations are array or pointer. Does it? Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 18:29:27 on 92/09/21 GMT (by UBIQUITY at AUSVM1) Subject: VARCHAR confusion in C Ref: Append at 16:39:38 on 92/09/21 GMT (by TCSC086 at OS2CUST) The use of a C null-terminator is dependent on your host declaration, not on the SQL data type of the source data. If your variable is declared as "char xìn┘" (hope you see square brackets there), the result will be null-terminated unless n=1. In an SQLDA, there are specific data types (460 or 461) which indicate that a null-terminator is desired, again irrespective of the source data. The alternative to null-terminated data in C is the simulared varchar host variable (a structure consisting of a short integer followed by an array of char). You can also use unterminated strings by specifying data types 452 or 453 in an SQLDA. Richard D. Hoffman ----- OS2DBM CFORUM appended at 19:24:13 on 92/09/21 GMT (by JWILK at SYDVM1) - Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Thanks for the answer so far, I eagerly await the full success story.... John Wilkinson ----- OS2DBM CFORUM appended at 19:45:58 on 92/09/21 GMT (by TCSC086 at OS2CUST) Subject: VARCHAR confusion in C Ref: Append at 18:29:27 on 92/09/21 GMT (by UBIQUITY at AUSVM1) Richard, Thanks for the extremely clear replay. I needed it! (I hadn't evenlogged off yet!) Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 19:55:13 on 92/09/21 GMT (by TCSC086 at OS2CUST) Subject: VARCHAR confusion in C Ref: Append at 18:29:27 on 92/09/21 GMT (by UBIQUITY at AUSVM1) Richard, Not believing in Free Lunches, is there any downside or cost to using VARCHAR that would make CHAR the better choice? Thanks again! Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 20:43:15 on 92/09/21 GMT (by UBIQUITY at AUSVM1) ..... OS2DBM CFORUM modified at 18:11:53 on 92/09/22 GMT (by UBIQUITY at AUSVM1) Subject: VARCHAR confusion in C Ref: Append at 19:55:13 on 92/09/21 GMT (by TCSC086 at OS2CUST) VARCHAR costs four extra bytes per item. This means that if the field | is really fixed length (e.g., social security number, phone number, employee serial, etc.), VARCHAR will add unnecessary space. If the field is "close" to fixed length (e.g., radio station call letters -- always either three or four bytes long), it will still be cheaper to use CHAR in terms of space, but deleterious in terms of programming. As a database purist, I say that *only* truly fixed fields should be CHAR, but I admit that this rule might be relaxed in the case of severe space restrictions. Richard D. Hoffman | four, not two, extra bytes. I knew that, really. ----- OS2DBM CFORUM appended at 21:57:10 on 92/09/21 GMT (by TCSC086 at OS2CUST) Subject: VARCHAR confusion in C Ref: Append at 20:43:15 on 92/09/21 GMT (by UBIQUITY at AUSVM1) Thanks again Richard! (Do you live on here too!<g>) To summarize, VARCHAR is really a space conservation option when the field length is *truly* unknown or vague. DECLARE section determines how I will see it (or get it). I **hate** >fluffing< arrays - pointers are just so *convenient*. Lazy where I can be...thanks again... Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 04:46:41 on 92/09/22 GMT (by JWILK at SYDVM1) - Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Hi again, I have now managed to get a database cataloged on my DOS requestor VDM. I am know having problems accessing that database, I'm getting a 30080, signifying a comms error, I'm not sure what the reason code is, I need change my program to return that !!! I'm wondering if anyone has any pearls of wisdom as to what the common problems are.... Thanks in advance John Wilkinson ----- OS2DBM CFORUM appended at 13:02:12 on 92/09/22 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Ref: Append at 02:17:16 on 92/09/21 GMT (by JWILK at SYDVM1) The better answer 1. Yes 2. Yes, yes. 3. The DOS DB Req. allows remote catalog only. 4. Ensure that the DOS DB Req. name (DBDRQLIB.CFG) and OS/2 DBM server names are unique. A conversation is established between these names, that just happen to reside on the same machine. Lance Amundsen |I am trying ever so hard to get a DOS application to access |an ES Database, which resides on the same workstation. I am however |unsure as to wether I have the appropriate S/W and/or H/W..... | |Question 1) Do I need to have ES with Database Server to get this | to work at all ?? |Question 2) Do I need to be physically on a LAN to get this to | to work, even when I am physically going to the same | workstation ?? | I guess I'm asking how NETBIOS operates in this environment, | ie from a DOS VDM through to an OS/2 process. Does the | DOS Netbios VDD go out on a 'real' LAN adapter ??? | |Question 3) This is related to question 2), but how should I code | up the DB catalog function, local or remote ??? |Question 4) This is also related to question 2), what should I use | as my netbios workstation names, for DOS requestor and | OS/2 server, these have to be unique but how to I route | my netbios to the 'same' workstation ??? Robert Begg ----- OS2DBM CFORUM appended at 13:15:45 on 92/09/22 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Ref: Append at 04:46:41 on 92/09/22 GMT (by JWILK at SYDVM1) I spent some time yesterday looking into this (see the answer I posted from your original append). I had more problems getting the correct math libraries than I did with the DBM part. It sounds like you havn't got the netbios part setup correctly... 1st, this topic is covered in the Guide to DBM Appendix H-2. Note this is specific to running Dos Req. from a os2-dos session. 2nd, the netbios nodename you need to connect to is the NNAME specified with the configuration tool. Update the DBDRQLIB.CFG file like the manual says, the dos node name just needs to be unique. Ensure that you have netbios support installed. Try testing from another OS2 client if possible. Robert Begg ----- OS2DBM CFORUM appended at 14:34:03 on 92/09/22 GMT (by JASSALT at BETVMIC5) Subject: Dos Client Help Hi Everyone, My Dos client Program has bad data coming back from the FETCH. In my C program I do the Catalog Database successfully, then I open The database (OK), then I declare Cursor (OK) then I open Cursor (OK) and I do a fetch (OK) also I get the five records that I am expecting however the data coming back to me is garbage. The selected smallints, and decimal fields have Zeros, and the character selected fields have garbage in them. I dont know what, I forgot to define/Configure and the documentation leaves me stranded. I'm not sure if maybe its my compile switches or what. Any help at this point would be greatly appreciated, from anyone out there. Thanks ..... Thakur Jassal ----- OS2DBM CFORUM appended at 06:41:38 on 92/09/23 GMT (by JWILK at SYDVM1) - Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Well, I'm now past the comms errors, or so it seems, I'm now getting another error (and rather annoyed...). I'm now getting the infamous 1042 error, on a start using DB. Everything on the OS/2 side works fine (ie logging on, accessing the database etc). When am I actually going to DBM, the speed at which this returns implies it's not getting past the requestor code ??? I have now set this up on another PS/2, and have got to the same point as on the other machine, up until my last attempt.... now on this workstation I get a 1042 at the sqllogn2 point, I think I'm about to go crazy here (or go to Gupta........) John Wilkinson ----- OS2DBM CFORUM appended at 12:16:32 on 92/09/23 GMT (by ROBERT at TOROLAB4) Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Ref: Append at 06:41:38 on 92/09/23 GMT (by JWILK at SYDVM1) Did you: Update the DBDRQLIB.CFG file? (used a different nname than os2 dbm) Catalog the database name and the nname of the OS/2 dbm? Run startdrq? Robert Begg ----- OS2DBM CFORUM appended at 05:29:47 on 92/09/24 GMT (by NAAO3IY at OS2CUST) Subject: VARCHAR confusion in C Ref: Append at 21:57:10 on 92/09/21 GMT (by TCSC086 at OS2CUST) Remember that VARCHAR is a necessity if you want expressions with concatenations in them to come out right (assuming that varying-length is "right" for the job). John Kennedy -- Hoechst Celanese, Bridgewater, NJ ----- OS2DBM CFORUM appended at 13:21:08 on 92/09/24 GMT (by MBCSQ11 at OS2CUST) Subject: Computer Asset Inventory Ref: Append at 15:14:32 on 92/09/17 GMT (by F079128 at DCTVM3) Yes and No. We created our own but also used LMU/2 for some: If you use Extended Services, there is a QMC.EXE program in the SNAPDUMP.ZIP file. QMC basically "dumps" our CMOS into a flat file. Originally we used this in conjunction with a REXX program to get information about each machine and load it into a DBM database. For DOS machines of course, other programs had to be used ... Since then, we started using Lan Management Utilities/2, which allows a LAN administrator to run a program ON a client workstation. One of the programs is a QUERYVPD which dumps out system information from DOS and OS/2 systems. Once installed on each client machine, we can use LMU/2 to run a command file from a shared drive on the LAN which executes the QUERYVPD. LMU/2 creates its own DBM database on a server. The queryvpd program running from each client workstation passes system information along via named pipes to the server which then inserts the data into a DBM database. We then built maintenance panels and reports in Query Manager. QM may be a bit crude in some points, but you can generate screens/reports in a very short amount of time ... Brian Treptow - Miller Brewing Company, Milwaukee WI ----- OS2DBM CFORUM appended at 14:32:14 on 92/09/24 GMT (by WJLUCAS at NYCVMIC1) Subject: OS2 DB DB-Library compatability Ref: Append from Wjlucas at NYCVMIC1 Has anyone looked at creating a set of DLL's for OS2 DBM that will support the DB-Library API issued by many of the Windows 3.0 tools? MicroDecisionware is currently doing this for DB2 in their Gateway product. This would allow all the Windows fron end tools that talk to Microsoft's SQLServer to transparently access OS2DBM and by default DDCS/2. ----- OS2DBM CFORUM appended at 16:19:38 on 92/09/24 GMT (by UBIQUITY at AUSVM1) Subject: VARCHAR confusion in C Ref: Append at 05:29:47 on 92/09/24 GMT (by NAAO3IY at OS2CUST) Yeah. Too bad DBM doesn't support concatenation. :-) Richard D. Hoffman ----- OS2DBM CFORUM appended at 16:37:38 on 92/09/24 GMT (by IL03484 at OS2CUST) Subject: A Clean Way to define SQL host vars globally across several C Pgms. (no text entered) ----- OS2DBM CFORUM appended at 18:31:53 on 92/09/24 GMT (by TCC3824 at OS2CUST) Subject: Limit on number of Insertions Ref: Append at 17:02:46 on 92/09/17 GMT (by FRMLSPA at OS2CUST) I receive a fix 9/23/92 that was supposed to fix the problem but it did not fix the problem. Inserted 183,000 rows and the insert program locked up. The index was about 10.5 meg when it stopped. I'll try inserting to the table without an index and then create it. Will let you know. How big are the Indexes on your tables? You are using ES database manager? Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 20:53:11 on 92/09/24 GMT (by JWILK at SYDVM1) - Subject: ES DBM Access from DOS VDM on same OS/2 V2 Workstation Robert, I thought I had appended a reply yesterday, but it appears to have been lost ??? Yes we have ensured that the CFG is OK, we initially got NetBIOS errors which we are now over (we increased SQLSIZE). We are know at a point of 1) On one machine we get a 1042 when we attempt to open a database (ie we have successfully logged on/started the client services and cataloged the database) 2) On another machine I used to be able to at least log on and start the client services, but now I get a 1042 for everything I try and do !!!! I will admit to fooling around with a sample windows DBM pgm I have and since then things have been astray..... Can you explain a couple of things... 1) When exactly does the DOS client services interact with DBM and UPM on the OS/2 side, logon ??? startup ?? catalog ?? ... START USING must obviously, but what interaction b4 this ?? 2) When I do a logon and startup in a DOS VDM is this just for this DOS session or all DOS sessions on the W/S. It appears to me that its for all sessions, cos when I started playing with my windows app, I appeared to be logged on already !!! 3) Assuming I must logon and startup in a Windows session, how under WIN-OS2 do I startup SQLLOGN2 and STARTDRQ, I can't get to a DOS session under WIN-OS2, and when I try to run them from the command line under Windows Program Mgr, I get an error saying this must be run from a DOS or OS/2 cmd line !!!! Thanks again for your help John W ----- OS2DBM CFORUM appended at 23:18:11 on 92/09/24 GMT (by SGKILPAT at NYCVMIC1) Subject: Database Sizing Tool Is there a tool available which will allow me to predict the hard disk requirements for an OS/2 database? Regards, Sandy Kilpatrick ----- OS2DBM CFORUM appended at 00:06:21 on 92/09/25 GMT (by IL78568 at OS2CUST) Subject: VARCHAR confusion in C Ref: Append at 05:29:47 on 92/09/24 GMT (by NAAO3IY at OS2CUST) I think the proper way to handle this problem is by including some kind of trim function (TRIM, LTRIM, RTRIM maybe) in the SQL implementation. Then VARCHAR doesn't have to be used inappropriately. Brooks McNeely - Martin Marietta Energy Systems, Inc. ----- OS2DBM CFORUM appended at 03:27:00 on 92/09/25 GMT (by HOPKINS at AUSVM8) Subject: Computer Asset Inventory Program coming... Ref: Append at 15:14:32 on 92/09/17 GMT (by F079128 at DCTVM3) See the upcoming LMU/2 CFORUM when it's available (next week?) Lan Managment Utilities for OS/2 . Works very well. We use it here locally to track machines, types, adaptors, drives, RAM...... It's got it all. See your local Marketing Rep for more details on the product announcement. Ken Hopkins, OS/2 Software Service and Support. ----- OS2DBM CFORUM appended at 16:49:39 on 92/09/25 GMT (by TCSC086 at OS2CUST) Subject: DBM API pointers The DBM Routine GET NEXT DATABASE DIRECTORY ENTRY states that: (C syntax): "Pointer to the address of the database directory entry info buffer. The address of the buffer is returned in this variable." The parm is defined : struct sqledinfo **buffer_address; So the who call is short sqledgne( unsigned short handle, struct sqledinfo **buffer_address, struct sqlca *sqlca) I take this to mean that > I < should declare: struct sqledinfo *myPointer and pass the call &myPointer (Pointer to Pointer) I have tried this every way I can, including explicit use of SQL_POINTER (alias _Seg16). I am aware of the ES32TO16conventions and linkage. I make other Routine calls and they are successful (such as Open Dir Scan). I can't get it to work for this call. What am I missing or doing wrong! Help! Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 18:35:50 on 92/09/25 GMT (by XXRBNKB2 at TORVMCOP) Subject: DBM API pointers Ref: Append at 16:49:39 on 92/09/25 GMT (by TCSC086 at OS2CUST) Dan: I have a program that does what you are trying to do. Like you, we have USHORT Handle, Count; struct sqledinfo *Info; sqledops('0', &Handle, &Count, &sqlca ); while ( i < Count && sqlca.sqlcode == 0) sqledgne ( Handle, /* note no & symbol */ &Info, &sqlca ); strncpy ( chzAlias, Info->alias, 8); Hope this helps. Mark Christmas Royal Bank of Canada (416) 348-5147 ----- OS2DBM CFORUM appended at 19:04:55 on 92/09/25 GMT (by TCSC086 at OS2CUST) Subject: DBM API pointers Ref: Append at 18:35:50 on 92/09/25 GMT (by XXRBNKB2 at TORVMCOP) Mark, Thanks for replying. Your code sample is functionally the same as my code. However, in my case, I do not receive back an initialized structure. Rather, the pointer is set to an invalid address. Are you linking with the Migration libraries by any chance? I am using the recommended compile options and ES32TO16 define. My library linkgroup is SQL_DYN + DDE4MBS + OS2386. If you could post your make options (anyone!) it would help me track this down. Your code clearly demonstrated exactly how I thought the Routine worked. Now I hunt through my comp&link options. Thanks again, Dan Lundy Time Customer Service, Inc. Tampa, Fl ----- OS2DBM CFORUM appended at 12:47:42 on 92/09/28 GMT (by JHAGAN at CLTVMF) Subject: SQL1022C error message using RDS. Environment: Client machine is running OS/2 2.0 with ES 1.0. Server is running OS/2 1.3 (latest CSD) with ES 1.0. Connection is NETBIOS. I have created a table with the following columns defined: COL1 INTEGER NOT NULL, COL2 SMALLINT NOT NULL, COL3 CHAR(10), COL4 CHAR(10), COL5 CHAR(10), COL6 INTEGER, COL7 INTEGER, COL8 INTEGER, COL9 CHAR(4), COL10 VARCHAR(40), COL11 LONG VARCHAR, COL12 LONG VARCHAR, COL13 LONG VARCHAR, COL14 LONG VARCHAR, COL15 LONG VARCHAR, COL16 LONG VARCHAR, COL17 DECIMAL(10,2) NOT NULL. When I issue the statement 'SELECT * FROM TABLE' I receive the subject error message in response. However, if I remove one of the LONG VARCHAR columns the select statement will work. I also know that if I create this table locally on the client machine that the select works, and if I issue the select at the server machine it also works. I only get the error when the database is on the server and I issue the select from the client. Because of this I assumed that the problem is in the Database Configuration at either the client machine or the server machine, but nothing I've tried has worked. Does anyone have any idea what I need to change to get this to work. (Not having all six LONG VARCHAR columns is not an option, the "customer" actually wants COL10 to also be a LONG VARCHAR column.) Thanks, John Hagan ----- OS2DBM CFORUM appended at 13:52:44 on 92/09/28 GMT (by BILLMC at LEXVM2) Subject: Rollback or Commit after softcrash? OS/2 2.0 Database manager now does a COMMIT to the database if an error(softcrash)occurs. 1.3 would remove the data from the database when DBM was re-initialization. It appears that ROLLBACK code upon error doesn't work Is 2.0 supposed to rollback? ----- OS2DBM CFORUM appended at 14:27:40 on 92/09/28 GMT (by IL03484 at OS2CUST) Subject: SQL DECLARE CURSOR FAILING We are encountering a problem consistently, which is DECLARE CURSOR failing. This happens despite the syntax for DECLARE CURSOR being correct. This seems to occur in a sort of unpredictable and random manner. In the process of our determining what caused the error and to overcome we added a EXEC SQL COMMIT WORK statement just prior to DECLARE CURSOR statement and found DECLARE CURSOR statement worked. However, logically we are not in a position to COMMIT the work at that point. The SQLCA.SQLCODE returned was +100 with a SQLCA.SQLSTATE of 02000 when DECLARE CURSOR failed. We could not attach any reasonable meaning to the error messages in the context of what we have. We would appreciate if somebody can throw any light on this. Thanking You. Perepa Bhargav Perepa Bhargav ----- OS2DBM CFORUM appended at 16:02:20 on 92/09/28 GMT (by MALKEMUS at TOROLAB3) Subject: SQL DECLARE CURSOR FAILING Ref: Append at 14:27:40 on 92/09/28 GMT (by IL03484 at OS2CUST) DECLARE CURSOR is not an executable statement. Could it be that there is a FETCH before the DECLARE, and an SQLCODEof +100 was left over from the FETCH and tested after the "execution" of the DECLARE? A COMMIT stuck in between would clear it back to zero. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 19:14:39 on 92/09/28 GMT (by ROBERT at TOROLAB4) Subject: DBM API pointers Ref: Append at 19:04:55 on 92/09/25 GMT (by TCSC086 at OS2CUST) Dan, I don't have a make file handy to post ( I have one at home ). But, (I'll try the shotgun approach) are you using the /D compile option, or using a #define for ES32TO16 ? Use /DES32TO16. If count is > 0, and the get next dir didn't return an error in SQLCODE (sqlca.sqlcode), then the pointer must be getting stomped on. Maybe the handle (pushed last on stack when passed), is stomping the sqledinfo pointer? How did you conclude the pointer is garbage? Runtime error (storage violation), or garbage in structure? Are you dereferencing the structure correctly? (I spent too long looking at a bug where the SQLCODE in a printf overwrote the string pointer from the host variable. I saw garbage, and assumed the pointer was invalid. It was valid when passed, but the printf %d should have been %ld ...) Robert Begg ----- OS2DBM CFORUM appended at 19:22:02 on 92/09/28 GMT (by ROBERT at TOROLAB4) Subject: SQL1022C error message using RDS. Ref: Append at 12:47:42 on 92/09/28 GMT (by JHAGAN at CLTVMF) The error indicates a memory shortage. The cause and action indicate that a remote procedure variable cannot exceed 4k. Its unclear if remote means remote access or an ARI procedure, but it seems that it hit a memory limit somewhere. This is a limit for remote only, probably the blocking size. So while I await a better answer, try increasing the block size in the configuration. Robert Begg ----- OS2DBM CFORUM appended at 17:33:56 on 92/09/29 GMT (by EVANDROP at RIOVM1) Subject: Borland C++ acessing DBM Ref: NO REF Is there any way to access Database Manager using Borland's compiler? I know that the libraries are binary incompatible with Borland OBJ files. Should I use only Microsoft's compiler? I'm using Borland C++ 3.1. Thanks in advance. Evandro Paes dos Reis. ----- OS2DBM CFORUM appended at 17:41:11 on 92/09/29 GMT (by KLIGERMN at TOROLAB3) Subject Workstation Database Manager FTN - 10-15-92 Passing on some information. Gene Kligerman ========================================================================= Wanted you all to know that the Toronto Lab will be presenting a Workstation Database Trends & Directions on October 15, 1992. The Presentor will be Jeff Fisher who many of you know from his earlier life at the Dallas Support Center. Jeff will be talking about where IBM will be going with their plans for both the OS/2 32 bit and AIX Database Managers. In addition, Jeff will also be touching on the evolving DDCS/2 DRDA gateway. This FTN session will be an open session....Both Customers & IBM'ers can attend .....therefore you should assume that we will not be disclosing any confidential information but we will be sending a message that Toronto is proceeding ahead and forcefully with the development of the Workstation DBM Products. If you've had questions about IBM's committment to the OS/2 and AIX DBM's this is the FTN that you need to be attending......... Check your local FTN scheduling for the time & the place........ ----- OS2DBM CFORUM appended at 17:41:55 on 92/09/29 GMT (by XXRBNKB2 at TORVMCOP) Subject: DBM API pointers Ref: Append at 19:04:55 on 92/09/25 GMT (by TCSC086 at OS2CUST) Dan: I must confess that we produced our executable using MS C 6.0. The libraries I linked in were os2 llibce sql_dyn and upm (for logon purposes). Sorry this doesn't help you out with the C Set/2 stuff. Mark Christmas Royal Bank of Canada (416) 348-5147 ----- OS2DBM CFORUM appended at 17:53:21 on 92/09/29 GMT (by IL65077 at OS2CUST) Subject: Student Records Database This question also posted on the ISTHERE forum. Does anyone know of a student records and course registration database package that uses OS/2 database manag er as its back end and which is accessable from OS/2 and DLR/Windows workstatio ns? We need to track course registration for up to 250 students enrolled in se veral dozen courses. PostScript printing a must. Am I dreaming? Thanks! Bill Nelson, TIUA, Salem, OR ----- OS2DBM CFORUM appended at 18:33:14 on 92/09/29 GMT (by XXNOVA24 at TORVMCOP) Subject: Student Records Database Ref: Append at 17:53:21 on 92/09/29 GMT (by IL65077 at OS2CUST) Bill, Did you considered to write one ala' Client-Server-Programming book ? Geza Szivos NOVACOR Chemicals (403)-290-6583 NHO-32 801-7th Ave Calgary, Alberta, CANADA T2P 2N6 ----- OS2DBM CFORUM appended at 18:35:20 on 92/09/29 GMT (by IL03484 at OS2CUST) Subject: A Clean Way to define SQL host vars globally across SQC Pgms Currently, we are in the process of developing an app involving GPF, PM, C and DBM environments. GPF is a CASE tool to generate GUI front end screens for PM. The underlying database is defined in DBM. To provide the actual application functionality, we need to write in C (.SQC) language, programs which exit from user screens and perform database related activities. We intend defining the required host vars for all the database elements at one place and refer (declare as externs) to these globals in all our SQC sources. I am interested in knowing a clean way to achieve this. Currently we are doing this in some inferior manner. The problems encountered are : - I am not able to include these host definitions in a header file 'cause I can not include statements EXEC SQL BEGIN DECLARATION SECTION, etc. - I am not able to include header files in the middle of EXEC statements either. in my SQC sources 'cause preprocessor can not do macro substitution - If I create a SQC source which defines all my host vars and compile this into an object and insert into an object library as an object module with an idea to resolve global hosts at link time, I am encountering a linker invalid module error. Would appreciate if somebody has an idea. THANKS. Perepa Bhargav Perepa Bhargav ----- OS2DBM CFORUM appended at 21:10:51 on 92/09/29 GMT (by ROBERT at TOROLAB4) Subject: A Clean Way to define SQL host vars globally across SQC Pgms Ref: Append at 18:35:20 on 92/09/29 GMT (by IL03484 at OS2CUST) I don't know if this help but, It is usually suggested that you create another thread to perform all DBM access, (and have only this thread access DBM data structures and host variables). This means sending messages from the Interface thread to the DBM thread. The message could include a pointer to a structure, which contains info from fields. The DBM thread could then copy this data into the host variables (the Interface thread would block on the sendmsg until this was complete). This limits the required scope of the host variables, and also makes the app more modular (and easier to test). Another useful tidbit, is that host variables can be pointers to global vars, thus the the global vars are used elsewhere in the code, and the Host vars are only referenced in the .sqc files. (Somewhere an init routine sets the host vars to point to the global vars) This isn't as modular though, and you must make sure that only one thread is updating the variables at any one time. In fact, you could expand this model by using a shared stack or pool, and have the interface thread queue requests to the DBM thread. Hope this helps somewhat, since it dosn't exactly answer the question. ps, I'm the new writer for the DBM Programming book, and I am aware of a lack of PM & DBM info. I would like to hear from anyone writing PM DBM apps. Robert Begg ----- OS2DBM CFORUM appended at 21:18:14 on 92/09/29 GMT (by UBIQUITY at AUSVM1) Subject: A Clean Way to define SQL host vars globally across SQC Pgms Ref: Append at 21:10:51 on 92/09/29 GMT (by ROBERT at TOROLAB4) If you *really* want an SQL include facility for C, you can use #include and run the programs through the C preprocessor before you run them through SQLPREP. Richard D. Hoffman ----- OS2DBM CFORUM appended at 21:32:41 on 92/09/29 GMT (by ROBERT at TOROLAB4) Subject: A Clean Way to define SQL host vars globally across SQC Pgms Ref: Append at 21:18:14 on 92/09/29 GMT (by UBIQUITY at AUSVM1) Yeah, and you could use ifdefs to avoid expanding unneeded header files the first time through, this would avoid feeding the SQL precompiler too much stuff. Robert Begg ----- OS2DBM CFORUM appended at 23:27:15 on 92/09/29 GMT (by 64937908 at TOROHON1) Subject: -3010 SQL3010N - SQLGIMP - Urgent Hello, Is there someone out there who has tryed that API from DBM under ES v1.0 ? I have 3 programs which under 1.3 were working fine. Now I've got a serious problem because they don't. I have the proper 32to16 bit header and all the other fucntions of my programs work. I'm using Cset/2 (Latest fixs), workframe and ES with Data base server. I can't see why ? Name of columns are ok, size of the fields, etc Is there someting in the structure which has changed ? Any additionnal \0 or something like that... I've just experience that with DCC/2 API's. Thanks ! Customer install date is tomorow ..... we never check that part because all the precompilation + compilation + link worked OK ! The other programs we running fine.. that was small programs. Patrice Belanger Torovm1(pbelange) 514-938-7488 tie 848-7488 ----- OS2DBM CFORUM appended at 12:28:25 on 92/09/30 GMT (by ROBERT at TOROLAB4) Subject: SQL1022C error message using RDS. Ref: Append at 19:22:02 on 92/09/28 GMT (by ROBERT at TOROLAB4) It turns out that the config parm to change is the rsheapsz. In this case increasing the value from 3 to 4 (on the server) solved the problem. The help for this parameter states that one 4K buffer is used per application, which should probably mean that at least one is used per application. Robert Begg ----- OS2DBM CFORUM appended at 12:51:09 on 92/09/30 GMT (by 75832092 at EHONE) Subject:DBM Server throught Named Pipe Is there anybody out there that have already developed a DBM Server process connected to client process using named pipe ? The client process is already connected to a database (Host) and needs some data from another database (local) using transactions over a named pipe to the server process and so for the way back. I wouldn't like to spent a lot of effort doing thing already done. Thanks in advance for any help and suggestion Tiziano ----- OS2DBM CFORUM appended at 17:42:24 on 92/09/30 GMT (by GALINM at POKVMCP2) Subject: SQLQMF to download LONGVARCHAR I WOULD LIKE TO DOWNLOAD AN SQL TABLE THAT CONTAINS A LONGVARCHAR COLUMN. THIS COLUMN IS NEVER OVER 500 CHARS LONG. THE USERS' GUIDE SAYS THAT SQLQMF DOES NOT SUPPORT LONGVARCHAR BUT WILL SUPPORT VARCHAR UP TO 4000 CHARS. IS THERE A WAY TO CONVERT THE LONGVARCHAR TO A VARCHAR FOR IMPORTING INTO THE OS2DBM USING SQLQMF???? THANKS IN ADVANCE MANNY GALINDO IBM CCP E. FISHKILL,NY. ----- OS2DBM CFORUM appended at 13:54:59 on 92/10/01 GMT (by TCC3824 at OS2CUST) Subject: Database Sizing Tool Ref: Append at 23:18:11 on 92/09/24 GMT (by SGKILPAT at NYCVMIC1) I don't know of any tool that exists by 3rd party that estimates database size. However, on page 6-57 of the OS/2 Parameter and Tuning Guide g33f-9437-00it tells how to calculate it. I just put the formulas in EXCEL and use it to estimate DASD requirements. Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 15:19:27 on 92/10/01 GMT (by UBIQUITY at AUSVM1) Subject: SQLQMF to download LONGVARCHAR Ref: Append at 17:42:24 on 92/09/30 GMT (by GALINM at POKVMCP2) DB2 LONG VARCHAR fields are just VARCHAR fields in disguise. I believe you can copy the data to another DB2 table which has VARCHAR instead of LONG VARCHAR, and then perform SQLQMF. Richard D. Hoffman ----- OS2DBM CFORUM appended at 22:36:39 on 92/10/01 GMT (by FRML075 at OS2CUST) Subject: Windows query tools I'd like to get a quick education on the available software products which allow Windows users to do ad-hoc querying/reporting against OS/2 DBM. Could anyone offer their opinions of products they've seen? A brief comparison with OS/2 Query Manager might be helpful. Thanks! Louis Rios, Farmland Industries 816/459-6176 ----- OS2DBM CFORUM appended at 20:02:22 on 92/10/02 GMT (by FRMLSPA at OS2CUST) Subject: A Clean Way to define SQL host vars globally across SQC Pgms Ref: Append at 18:35:20 on 92/09/29 GMT (by IL03484 at OS2CUST) We use Gpf and Database Manager in our shop. Some of the limitations on "clean" coding of the DECLARE SECTION for host variables are simply limitations on the precompiler which doesn't really understand or interpret the language of your app only inserts native code for the SQL functions. This means that you can't have FETCH statements referencing host variables that are not previously declared in the same source file. I've written a DBM app with Gpf which consists of several different source files (4 of Gpf's and 4 of my own user functions). I use the same block of DECLARE SECTION host variables in all of the source files. I let Gpf send and receive hv's to entry fields and such, so I initially let Gpf set up the DECLARE SECTION in its generated source files and copied them over adding additional fields and tables as needed. Since the host variables have to be global, if the hv is defined with the same name and type in multiple source files which are compiled and linked together, accessing the HV populated by a FETCH from one source file by another source file works okay. By the way, I think Gpf works really well. The app I wrote is over 20K lines of code 4/5ths of which is PM stuff Gpf generated. 70% of my code is just embedded SQL. Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 20:12:33 on 92/10/02 GMT (by FRMLSPA at OS2CUST) Subject: Tuning spreadsheet for DBM Is there or does IBM plan to produce, distribute, and maintain a spreadsheet for tuning DBM server parameters like the LANTUNE.XLS file for LAN Server which automatically calculates most of the parameters based upon some entry fields and good rules of thumb. I know the formulas are documented in the admin guide and we could put them in a spreadsheet, but I would like to see IBM own the spreadsheet and provide some good rules of thumb, tips, etc. Scott Atwell - Farmland Industries ----- OS2DBM CFORUM appended at 12:49:22 on 92/10/05 GMT (by ELLENM at RALVM0) ..... OS2DBM CFORUM modified at 15:11:00 on 92/10/05 GMT (by ELLENM at RALVM0) Append deleted by appender (wrong forum) ----- OS2DBM CFORUM appended at 14:54:17 on 92/10/05 GMT (by IL02075 at OS2CUST) Subject: C Set/2 And DARI I am migrating my applications from EE1.3 to ES2.0 using C Set/2. Everything works fine except my calls to Application Remote Interface (SQLGPROC) which allways returns -1111. The odd thing is that I ARI will work if I run the application with the old DLL files (from EE1.3 created with MSC 6.0). I suspect that I am not compiling or linking with the correct options. I have the Client/Server for 2.0 book by Orfali/Harkley and am using the same compile and link options that are used in creating a ARI DLL in chapter 31 p805. e.g. icc /C /Ti+ /Q+ /Sp1 /Sm /Gs- /Gm+ /Ge- /Gd+ /DES32TO16 LINK386 /ST:15000/SE:1024/CO/NOLOGO/NOI ... One thing is that /NODEFAULT is not specified so the linker looks for the default libraries to link with (other than sql_dyn), what libraries should I be linking with to create a ARI DLL. Note: The IBM ES 1.0 DBM Programming Guide (I only have the beta draft) says to use libcdll.lib but this is not part of C Set/2 and I really do not want to use MSC 6.0 any more. Mike Rowan, Mainline Information Systems ----- OS2DBM CFORUM appended at 19:14:22 on 92/10/05 GMT (by JHAGAN at CLTVMF) Subject: DBM index question. I have an application that uses the following SELECT statement to get information from a DBM database: SELECT A.AAA, BBB, CCC, DDD, EEE FROM A, C WHERE A.AAA IN (SELECT FFF FROM B WHERE GGG = 100 AND HHH=8) AND A.AAA = C.III Table A has column AAA defined as a primary key, but the other two tables do not have primary keys defined. All three of the tables have about 8000 rows in them. On my PS/2 Model 80 this select takes approx. 16 seconds to execute. I theorized that if I created an index on column III of table C that it should improve the performance of this SELECT since DBM would no longer have to scan the entire table C. HOWEVER, when I have this database on my Mod 80, creating this index has little or no effect. But, if I move my database to a Server machine to which I am connected creating this index decreases the time for the SELECT from 16 seconds to less than 4 seconds. My question is what could be different on the server that allows it to use the index when it appears that DBM chooses not to use it when the database is on my machine? Does one of the Database Manager Configuration parameters control this somehow? I have also moved the database to DB2 and creating the index doesn't help there either. It only makes a difference when the database is on the server machine. Any suggestions would be appreciated. Thanks, John Hagan ----- OS2DBM CFORUM appended at 20:38:31 on 92/10/05 GMT (by ROBERT at TOROLAB4) Subject: C Set/2 And DARI Ref: Append at 14:54:17 on 92/10/05 GMT (by IL02075 at OS2CUST) The manual states: "The following compiler option is required for ARI server procedures. - /Ms (ensures linkage compatability)" I'm the writer of the programming book for the next release, and would like to hear back if this works. I find problems like this are helpful in correcting the manual. (like llibcdll.lib does not come with C /set 2) The book also says to link to doscalls.lib Robert Begg ----- OS2DBM CFORUM appended at 21:58:52 on 92/10/05 GMT (by 64915273 at TOROHON1) Subject: access to a query variable from a qm procedure Question 1. Does anyone know how I can get the values returned from some queries to QM procedure vriables? More precisely, I want to have a procedure that does the following: 1. Select a1 from ta1 2. Select b1 from tb1 3. Store a1 in a procedure var. 4. Store b1 in a procedure var. 5. Do some validation on these variables 6. Display a panel in ADD or Change mode using these variables. Question 2. Is there a way to display a field in a QM panel that is not coming from a table. This field will be for example a procedure variable? Thanks. ----- OS2DBM CFORUM appended at 22:41:09 on 92/10/05 GMT (by VERSTEEG at UITVM1) Subject: access to a query variable from a qm procedure Ref: Append at 21:58:52 on 92/10/05 GMT (by 64915273 at TOROHON1) Q1: You can get query output fields into procedure variables as follows: /* main proc */ 'RUN QUERY xxx (REPORT=NO' 'SAVE DATA AS temp (REPLACE=YES CONFIRM=NO' 'RUN PANEL xxx (MODE=CHANGE' /* GET INTO GLOBAL VAR */ 'RUN PANEL yyy (MODE=ADD' /* DO THE ACTUAL DATA ENTRY */ Panel xxx is defined on the temporary table 'temp' created by save data. Use the Default panel definition and add an initial search query name that points to a query that does a SELECT * FROM temp In the panel rules add a procedure for change. This procedure is called before the panel is displayed and should do: /* TEMP proc */ 'GET CURRENT (N=FIELD1' 'SET GLOBAL (A1=N' 'QUIT PANEL' Panel ENTRY is defined on the table TA1. It should have an initial procedure for Add (in panel rules). This procedure will get control before the panel is displayed: /* Add instance rule */ 'GET GLOBAL (N=A1' /* do some validation on 'N' */ 'SET CURRENT (FIELDx=N' /* FIELDx is some field on your panel */ Q2: Except for calculated fields, all fields on your panel must correspond with a table field. Anton Versteeg - ESAT PWS CoC Uithoorn, Netherlands ----- OS2DBM CFORUM appended at 00:43:55 on 92/10/06 GMT (by IL02075 at OS2CUST) Subject: C Set/2 And DARI The /Ms Compiler option only declares all functions as system as opposed to optlink. This is not desirable as I am porting this code for a perfomance increase over EE1.3 and do not want all functions to default to system linkage (which is slower than optlink). I have considered this as a possible source of my error and defined all of my 'server' routines as SHORT APIENTRY16 which boils down to 'short _Far _Pascal' and SQLGPROC itself is taken care of by the /DES32TO16, which provides a #pragma linkage(SQLGPROC, far _seg16) for it (#pragma directives over-ride compiler options such as /Ms). The version of the IBM ES/2 V1.0 manual is from Sept 12 1991 by Lance Amundson (I am waiting on the new release) and it provides no information on C Set/2 compiles for DARI. The OS/2 Client/Server 2.0 book (chapter 31) provides incomplete information on how to create DARI programs and dlls. What I need to know is: 1. How 'Server' functions should be declared. (system, APIENTRY16, far pascal...) 2. How to compile the 'Server' object module. (compiler options etc.) 3. How to LINK386 the 'Server' object module into a DLL (LINK386 compiler options, link libraries) 4. How to do all this with C Set/2 (I know llibcdll is not included with C Set/2 but what is its replacement,.. should OS2286 be used instead of OS2386 if it is a 16 bit DLL? If anyone can help it would be greatly appreciated. I have migrated all my code except DARI calls and have customers waiting anxiously. Note: I am fairly sure the requester portion of this works because it functions properly with the old MSC 6.0 'Server' DLL modules (if I rebind them of course) Another question: Is IMPLIB necessary? I am under the assumption that it is not because my program never calls the ARI functions directly. Only the TP agent calls the ARI functions. Is this correct. Mike Rowan, Mainline Information Systems ----- OS2DBM CFORUM appended at 02:57:42 on 92/10/06 GMT (by HARKEY at SJEVM13) Subject: C Set/2 And DARI Ref: Append at 00:43:55 on 92/10/06 GMT (by IL02075 at OS2CUST) Mike, Have you made it to Chapter 33 yet? An example of a server DLL function starts on page 848. The make file on page 805 depends on the compile flags to indicate the correct libraries to the linker. Tell the compiler what you want (in this case a DLL using a multithreaded, dynamically linked runtime that allows migration extensions) and the right libraries are pulled in. IMPLIB is not needed as the only thing calling your DLL is the database manger. Dan Harkey ----- OS2DBM CFORUM appended at 12:08:27 on 92/10/06 GMT (by DMCINNIS at TOROLAB3) Subject: DBM index question. Ref: Append at 19:14:22 on 92/10/05 GMT (by JHAGAN at CLTVMF) John Just the fun of it, try issuing a RUNSTATS and rebind your application. The optimizer may not be recognizing that the index exists, but doing a runstats will update all of the control tables. Dale McInnis / Toronto Canada (:->) Workstation Database Development VM/PROFS: TOROLAB3(DMCINNIS) ----- OS2DBM CFORUM appended at 12:54:31 on 92/10/06 GMT (by JHAGAN at CLTVMF) Subject: DBM index question. Ref: Append at 12:08:27 on 92/10/06 GMT (by DMCINNIS at TOROLAB3) Dale, I have tried running RUNSTATS, but it didn't help. The application is written in Smalltalk/V PM using the Digitalk Database Interface product which (I believe) does a dynamic bind each time you connect to the database. Smalltalk DBI only supports dynamic SQL if that could have anything to do with it. John Hagan ----- OS2DBM CFORUM appended at 14:45:31 on 92/10/06 GMT (by MALKEMUS at TOROLAB3) Subject: DBM index question. Ref: Append at 19:14:22 on 92/10/05 GMT (by JHAGAN at CLTVMF) John, Are the stats for the tables involved identical on both systems? Are the buffer pools the same size? Differences in any of these could make a difference in the chosen access path. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 16:44:30 on 92/10/06 GMT (by TCC3824 at OS2CUST) Subject: C Set/2 And DARI Ref: Append at 14:54:17 on 92/10/05 GMT (by IL02075 at OS2CUST) I have this same problem. There is a bug with C SET/2 and DBM 2.0 ARI. The IBM problem # is 926x9. I will call today and get a status. I have left all my DBM code in 16bit for right now but is running on 2.0 Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 18:42:06 on 92/10/06 GMT (by JHAGAN at CLTVMF) Subject: DBM index question. Ref: Append at 14:45:31 on 92/10/06 GMT (by MALKEMUS at TOROLAB3) Tim, The databases at both the server and on my machine have been REORGed and had RUNSTATS run against them and since they contain identical table definitions and data I would assume that the stats are the same, but I don't know for sure. As for the buffer pools, initially they were set to the defaults for client on my machine and server on the server, I have tried changing my configuration to match the server's configuration but it didn't help. Is there a way that I can verify that the stats are identical? Thanks, John Hagan ----- OS2DBM CFORUM appended at 20:11:06 on 92/10/06 GMT (by MALKEMUS at TOROLAB3) Subject: DBM index question. Ref: Append at 18:42:06 on 92/10/06 GMT (by JHAGAN at CLTVMF) Try the following queries on each system: select creator, name, card, npages, fpages, overflow from sysibm.systables where creator=user /* or whatever the qualifier is */ and name in ('A', 'B', 'C') select tbcreator, tbname, name, colcard, avgcollen from sysibm.syscolumns where tbcreator=user /* or whatever the qualifier is */ and tbname in ('A', 'B', 'C') select tbcreator tbname, creator, name, colnames, nleaf, nlevels, clusterratio from sysibm.sysindexes where tbcreator=user /* or whatever the qualifier is */ and tbname in ('A', 'B', 'C') High2key and low2key in syscolumns aren't applicable in this case. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 13:08:32 on 92/10/07 GMT (by TCSC086 at HONE84) Subject: C Set/2 And DARI Ref: Append at 16:44:30 on 92/10/06 GMT (by TCC3824 at OS2CUST) Kevin, I am in the midst of developing with ARI. What is the bug you encountered?? Dan Lundy Time Customer Service Tampa Fl ----- OS2DBM CFORUM appended at 14:47:35 on 92/10/07 GMT (by JHAGAN at CLTVMF) Subject: DBM index question. Ref: Append at 20:11:06 on 92/10/06 GMT (by MALKEMUS at TOROLAB3) Tim, I ran the three queries you suggested against each database and there are some differences. In the SYSTABLES info the values for columns NPAGES and FPAGES are 112 on my machine and 114 on the server. In the SYSINDEXES information the value in NLEAF is 26 on my machine and 29 on the server. In the SYSCOLUMNS information several of the values in AVGCOLLEN are higher on my machine than on the server, but neither one appear to me to be correct average lengths for the data that is in those columns. Are these differences the cause of problem? And if so what do I do to correct them? John Hagan ----- OS2DBM CFORUM appended at 16:51:55 on 92/10/07 GMT (by MALKEMUS at TOROLAB3) Subject: DBM index question. Ref: Append at 14:47:35 on 92/10/07 GMT (by JHAGAN at CLTVMF) Were all the index definitions the same on both systems? Did you check the buffer pool sizes? The small differences in the stats that you mention probably aren't enough to alter the paths chosen, but it's possible. I'd be interested in seeing the Explain reports for the two versions. Can't do that with dynamic SQL, though, so you'd have to put the queries in static SQL in a program and precompile/bind it. Something you might try is recoding the query to get the same results: SELECT A.AAA, BBB, CCC, DDD, EEE FROM A, B, C WHERE A.AAA = B.FFF AND B.GGG = 100 AND B.HHH=8 AND A.AAA = C.III This will be the same *only* if FFF is unique in table B, at least after qualifying B rows on GGG and HHH. If it isn't, you'll get duplication of rows in the result that you didn't get with the original. (Or more duplication than you got.) Use SELECT DISTINCT if that's appropriate. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 20:21:42 on 92/10/07 GMT (by TCC3824 at OS2CUST) Subject: CALL DBM -> ruturn code How do I get a return code from the following? /* */ call dbm 'start using database' rc does not give me the result. If I look the trace it does display the return code. How do I get it into a variable? Kevin McConnell 512-338-7457 Continuum Austin Tx ----- OS2DBM CFORUM appended at 20:50:06 on 92/10/07 GMT (by FCOC079 at OS2CUST) Subject: CALL DBM -> ruturn code Ref: Append at 20:21:42 on 92/10/07 GMT (by TCC3824 at OS2CUST) The SQLCODE should be in the Rexx variable called "RESULT". Dave Boll ----- OS2DBM CFORUM appended at 07:14:48 on 92/10/08 GMT (by IL02075 at OS2CUST) Subject: C Set/2 And DARI Thank you Mr Harkey (Sorry I misspelled your name in my original question). The bottom line is that the Server Dlls must be linked with the migration libraries. Is there any way to use the standard libraries, or must I wait until 32BIT ES is available?. And what are the implications of this if I wanted to use DDCS or DRDA? Does DARI work with these? I have some customers who would like to use say an AS/400 for their server. For those of you wanting to use DARI with C Set/2 I am at syslevel CS00000 on C Set and, other than the migration library question, have had no problems with the DBM API. To Mr Harkey: thank you for your book it is invaluable. To Anyone Writing DBM code: BUY IT (....trust me) Mike Rowan, Mainline Information Systems ----- OS2DBM CFORUM appended at 13:21:48 on 92/10/08 GMT (by WZ00533 at LINK21) Subject: DOS Embedded SQL Support Ref: Append at 07:14:48 on 92/10/08 GMT (by IL02075 at OS2CUST) I have some programmers who would like to write DOS Microfocus COBOL programs to access an OS/2 Database running on an OS/2 server. Can we do that? If so what pieces are required. Dave Ferrey - Bethlehem Steel Corp. Bethlehem PA. ----- OS2DBM CFORUM appended at 21:25:01 on 92/10/08 GMT (by SDRYAN at DALVM3) Subject: DDCS/2 To DB2 Distributed Education DISTRIBUTED DATABASE - If you're interested in learning about DDCS/2 to DB2 distributed database, AND you'd like plenty of hands on lab experience, then U4120 is the course for you! The course objectives for U4120 - Distributed Database Workshop, OS/2 to DB2, are the following: - Successfully install and configure SAA Distributed Database Connection Services/2 (DDCS/2) - Assess DRDA requester and DRDA server communication definitions and DB2 communications database entries - Configure NETBIOS and APPN clients - Implement security between the server and the requester - Explain application programming considerations in an OS/2 to DB2 distributed environment - Preprocess and bind an OS/2 application that accesses distributed relational data on the DB2 DRDA server. - Discuss the tools available for DB2 to OS/2 distributed database problem determination SECTION CLASS START END START NUMBER LOCATION DATE DATE TIME BUILDING ------- ---------------- -------- -------- ------ -------- Y432 ARLINGTON, VA 11/10/92 11/13/92 08:30A F18 Y433 IRVING, TX 12/14/92 12/17/92 08:30A F11 Z153 SAN FRANCISCO 01/19/93 01/22/93 08:30A Z155 IRVING, TX 03/02/93 03/05/93 08:30A Course duration: 4 days Tuition: $1600 Enroll today by calling 1-800-IBM-TEACh. If you have questions regarding course content, contact Sherry Ryan at 1-214-550-4282 ----- OS2DBM CFORUM appended at 22:37:25 on 92/10/08 GMT (by HARKEY at SJEVM13) Subject: C Set/2 And DARI Ref: Append at 07:14:48 on 92/10/08 GMT (by IL02075 at OS2CUST) Mike, Don't worry about the name. You should see what can be done with Orfali. :-) I don't see why migration libraries are required if you don't code any of the migration functions in your DLL? You might check and see if that is the case in your code. Take a look at the part of Chapter 27 starting on page 651. There is a comparison of the various SAA DBMSs. You'll find that DARI is "an advanced construct that goes beyond SAA" and is available only on OS/2. Thanks for the endorsement. Dan Harkey ----- OS2DBM CFORUM appended at 00:18:16 on 92/10/09 GMT (by FSENSE at RALVMM) Subject: Using a symbolic variable for a character string The answer my question is probably in one of the OS/2 DBM manuals, but our I/S group doesn't make them available so can someone please give me a hand on this one? I have an application using Query Manager that runs a simple select like this: SELECT * FROM ORG WHERE NAME = &NAME When this query is run from a menu, the user is prompted to enter the value for &NAME and must enter it in the format: 'SMITH' including the apostrophes. It's easy to forget them and I'd like to be able to have them enter just the name characters without the apostrophes. Anyone have a simple solution? Second, is there some way to disable the case sensitivity so that a name could be entered without the first letter in caps and still get a hit on a column in the database containing that name beginning with a capital letter? Floyd Sense, Networking Systems, RTP (FSENSE at RALVMM) ----- OS2DBM CFORUM appended at 12:38:20 on 92/10/09 GMT (by JHAGAN at CLTVMF) Subject: DBM index question. Ref: Append at 16:51:55 on 92/10/07 GMT (by MALKEMUS at TOROLAB3) Tim, the latest thing I tried was to backup the server database to diskette and restore it on my machine so that the databases are identical. I ran the three selects that you gave me to verify that the statistics were the same and they were. But I still get the big difference in time between the server machine and my machine. Next I will try putting the selects in a C program so I can run Explain against them. I'm not exactly an expert C programmer so it might take me a while to get it done. I'll send you the results when I get them. Thanks for all of your help. John Hagan ----- OS2DBM CFORUM appended at 12:51:10 on 92/10/09 GMT (by DMCINNIS at TOROLAB3) Subject: DBM index question. Ref: Append at 12:38:20 on 92/10/09 GMT (by JHAGAN at CLTVMF) John Is the hardware for the server the same as your machine? The difference between SCSI and ESDI drives can account for a large difference. Is there anything else running on the systems? Are you using cache on 1 but not the other? If you backed up the database from the server onto your machine and it is still slower then it is not the database which is slowing you down. Dale McInnis / Toronto Canada (:->) Workstation Database Development VM/PROFS: TOROLAB3(DMCINNIS) ----- OS2DBM CFORUM appended at 15:38:58 on 92/10/09 GMT (by PMS7508 at MARTLINK) Subject: WorkFrame/2 Support I would like to see the SQLPREP and SQLBIND commands enabled for the WorkFrame/2 environment. This includes the ability to invoke the SQL preprocessor (SQLPREP) and SQL postprocessor (SQLBIND) from the Actions selection of the WorkFrame/2 menu, and the ability to set default options for the commands from the Configure selection of the WorkFrame/2 menu. Are there any plans in place to provide these capabilities ? John Baker, Policy Management Systems Corporation ----- OS2DBM CFORUM appended at 15:53:06 on 92/10/09 GMT (by PMS7508 at MARTLINK) Subject: SAA PL/I Package/2 Support Will the Database Manager be enhanced to support embedded SQL in PL/I ? John Baker, Policy Management Systems Corporation ----- OS2DBM CFORUM appended at 15:57:19 on 92/10/09 GMT (by FCOC079 at OS2CUST) Subject: DOS Embedded SQL Support Ref: Append at 13:21:48 on 92/10/08 GMT (by WZ00533 at LINK21) Yes you can write DOS MicroFocus Cobol programs which access an OS/2 DBM database server. It uses the standard DOS client support stuff (which is in the \DBDRQLIB directory when you install DBM on the server, if you requested DOS client support). Your Cobol program has to do the 'Start Using Database' (SQLGSTRD) and 'Stop Using Database' (SQLGSTPD) calls. When calling DBM routines from MicroFocus Cobol programs, the parameter order in Cobol is the reverse of what the DBM routines expect. To remedy this, use the Call-Convention feature of MF Cobol: / Environment Division. Special-Names. Call-Convention 3 Is OS2API. You can then code your DBM routine calls with parameters listed in the same order as they are documented in the DBM programming reference: Call OS2API 'SQLGSTRD' Using By Value Loc-Spare1 By Value Loc-Dbase-Name-Len By Value Loc-D-Use By Reference SqlCa By Reference Loc-Spare2 By Reference Loc-Dbase-Name Once you've got your program coded and compiled (I'd use MicroFocus' SQL precompiler, if you have at least release 2.5.51, or thereabouts, rather than SQLPREP), you have to link your object code with PCDRSTAT.LIB and (last I knew) certain 'C' runtime libraries. These are static links (which can make your .EXE pretty good sized). Basically copy the whole \DBDRQLIB directory to your DOS client workstation. In there, you have to do some setup to catalog the databases at your server. And you have to setup the DBDRQLIB.CFG file to correctly reflect where the DOS client support stuff was put. RSVP if ? Dave Boll ----- OS2DBM CFORUM appended at 18:10:53 on 92/10/09 GMT (by FRMLSPA at HONE84) Subject: DOS Embedded SQL Support Ref: Append at 13:21:48 on 92/10/08 GMT (by WZ00533 at LINK21) Yes you can. You have to do the SQLPREP and SQLBIND from an OS/2 machine. You probably want to refer to IBM's Personal Systems/Issue 4, 1991 which has an article describing how to set this up and make it work. It takes a fair amount of memory on the DOS workstation. Scott Atwell - Analyst Programmer - Farmland Industries, Kansas City, MO ----- OS2DBM CFORUM appended at 21:09:00 on 92/10/09 GMT (by KDROMREL at SFOVMIC1) Subject: WorkFrame/2 Support Ref: Append at 15:38:58 on 92/10/09 GMT (by PMS7508 at MARTLINK) I can not speak for official IBM direction on futures. BUT, there was a flash released that explained how to add SQLPREP (and SQLBIND ain't much different) as a tool under the WorkFrame. Basic instructions are: 1) Select Configure 2) Select Tools, then NEW 3) Add Program Title = whatever you want Path and filename = x:\SQLLIB\SQLPREP.EXE (note the path is optional) Startup Directory = . Invocation string = %a%z /B (I also add /M=SQLPREP.MSG 4) You can prompt for the database name or put it in the invocation string. Look at the SQLPREP and SQLBIND syntax diagrams to see if there are other options you might wish to use. You will need to select the .SQC file and then select the Tool off of the Tools pull down menu. You can tweak with the Command Prompt and Foreground and Background options to see how you prefer it to work (whether a screen with the output is left visible or not, etc). Kelvin D. Romrell ----- OS2DBM CFORUM appended at 00:34:10 on 92/10/10 GMT (by VCHOLUIG at SYDVM1) Subject: A few questions 1. Can we used REORG and RUNSTATS through RDS? Will the actual work be done on the Server or the Requester? 2. REORG work file Using RDS, will the work file parameter relate to the client or the Server? 3. What locks are taken by REORG? I expect a Table lock??? 4. Does Referencial integrity has any impact on REORG performance? 5. What lock is taken by RUNSTATS? Can it impact a program running in parallel? 6. What lock taken by SQLBIND? Can we re-bind a program while it is running? Thanks, Gerard Holuigue ----- OS2DBM CFORUM appended at 01:19:02 on 92/10/10 GMT (by IL02075 at OS2CUST) Subject: Apostrophe in Query What does one do when an apostrophe is part of the search criteria when doing dynamic SQL. E.G. SELECT ID FROM PEOPLE WHERE LASTNAME = 'O'Malley' This returns sqlcode -104 An unexpected token "MALLEY" was found following ... any other machine?Every DARI call (SQLGPROC) returns -1109 which means it cant find the DLL. I know forsure that the DLL's Mike Rowan, Mainline Information Systems Tallahassee Fl ----- OS2DBM CFORUM appended at 18:53:50 on 92/10/11 GMT (by FCOC079 at OS2CUST) Subject: Apostrophe in Query Ref: Append at 01:19:02 on 92/10/10 GMT (by IL02075 at OS2CUST) Just double up the instance of the delimiter, wherever it occurs: SELECT * FROM PEOPLE WHERE NAME = 'O''MALLEY' Dave Boll ----- OS2DBM CFORUM appended at 09:20:10 on 92/10/12 GMT (by VERSTEEG at UITVM1) Subject: Using a symbolic variable for a character string Ref: Append at 00:18:16 on 92/10/09 GMT (by FSENSE at RALVMM) The answer to the first question is easy. Change the query to: SELECT * FROM ORG WHERE NAME = '&NAME' To answer your second question. If you are using Extended Services you can change the query to: SELECT * FROM ORG WHERE TRANSLATE(NAME) = '&NAME' Note that this query will return 'smith', 'SMITH', 'Smith', 'sMITH' etc. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 11:57:48 on 92/10/12 GMT (by WZ00533 at LINK21) Subject: DOS Embedded SQL Support Ref: Append at 15:57:19 on 92/10/09 GMT (by FCOC079 at OS2CUST) Thanks for your response. Does the information in your response apply to Extened Servies DBM only, or does it apply to OS/2 1.3 EE DBM? We will be moving to Extended Services, but... you know how these migrations go, it may be awhile. Thanks again Dave Ferrey - Bethlehem Steel Corp. Bethlehem PA. ----- OS2DBM CFORUM appended at 11:58:09 on 92/10/12 GMT (by WZ00533 at LINK21) Subject: Forcing off users. Ref: Append at 15:57:19 on 92/10/09 GMT (by FCOC079 at OS2CUST) We ran into a problem the other day. Scenerio: User is logged on (using RDS) to a OS/2 1.3 EE DBM. His PC 'locks up' so he reboots. He then logs on to DBM again. He now is now logged on to DBM twice! The first logon has locks!!! and others are being affected. Is there a way to force a single user out of DBM. Thanks, Dave Ferrey - Bethlehem Steel Corp. Bethlehem PA. ----- OS2DBM CFORUM appended at 17:10:27 on 92/10/12 GMT (by JBRAUER at STUTVM3) Subject: Forcing off users. Ref: Append at 11:58:09 on 92/10/12 GMT (by WZ00533 at LINK21) Dave, - sorry, under OS/2 EE 1.3 there is no official way to do this. - under ES 1.0, a new API is offered within DBM (SQLEKILL) which allows to kill the ENTIRE Database Manager on a system. This one could be utilized to reset a db server system (involving shutting off ALL users accessing this particular server) in cases of zombie locks. Ask your IBM representative to get the SQLEKILL documentation. In case of you having configured the RDS connections to go via APPC (not SQLLOO), you could maybe try to go into CM's (Communication Managers) Subsystem Management -> Session Services and look whether you can deactivate eventual zombie sessions resulting from a previous logon attempt of the offending client workstation. However, I don't know whether this one works... ____________________________________________________________ Joachim Brauer, IBM I/S Applications M&S, Ehningen (Germany) ----- OS2DBM CFORUM appended at 18:24:02 on 92/10/12 GMT (by FRMLSPA at HONE84) Subject: Using a symbolic variable for a character string Ref: Append at 00:18:16 on 92/10/09 GMT (by FSENSE at RALVMM) Yes. Not that I'm aware of. You can easily remedy your first delima by putting tick marks around your variable: SELECT * FROM ORG WHERE NAME='&NAME' DBM is case sensitive and I don't know a way around case sensitivity at an SQL level only (not involving a program to do translation). Scott Atwell - Analyst Programmer - Farmland Industries, Kansas City, MO ----- OS2DBM CFORUM appended at 22:06:40 on 92/10/12 GMT (by MROACH at BOSTON) Subject: Loading null data. I am trying to load data that may be null into fields defined as smallint and date. It ain't working! We are using the import/export facility of DBM as well as inserting through the CLI. Is there a way around this? We don't want to corrupt the data just to get it loaded. Any help would be appreciated. Mark Roach Norwalk, CT ----- OS2DBM CFORUM appended at 00:33:25 on 92/10/13 GMT (by WYATTDP at SYDVM1) Subject: the meaning of beep We have an applicatication that uses DBM. The application is not behaving correctly on one particular machine. We notice that, on this machine, we only get 1 beep when we STARTDBM instead of the normal 3 beeps. DBM seems to be running. Can anyone tell me what is the meaning of the beeps and what it means if you only get 1 of them? Thanks in advance, - David Wyatt ----- OS2DBM CFORUM appended at 07:02:51 on 92/10/13 GMT (by LX0037 at SYDVM1) Subject: SQL0805N error on PREPARE via REXX - recovered database. Folks This is a repeat of an entry in the oS2SQL forum because this forum seems more appropriate. I have built a database on a standalone DBM machine - using os/2 2.0 and ES 1.0. Program interface is via REXX dynamic SQL and works fine. Now have to instal the database and programs in the production machine which was constructed from the same OS/2 2.0 and ES 1.0 but it does have a comms manager component for 3270 access. This is the only difference in configuration which is all defaults all the the way. I dumped the database to diskettes and restored up onto the production machine. All OK and QM lets me see the tables and SQL queries via QM all work fine. When I run the REXX program, the first attempt to invoke a PREPARE via SQLEXEC results in an error SQL0805N saying that package "NULLID.SQLAC1A0 not found". I used a QM query of "SELECT * FROM SYSIBM.SYSPLAN" to look at the package names in both systems and they are identical in every respect. There is a package SQLAC1A1 but no package called SQLAC1A0. Questions : 1. Why is the SQLEXEC looking for a different package now ? 2. How do you relate the name of the package back to the bind options etc to see what it is that is different. Obviously SQLEXEC has some methodolgy but what is it ? 3. Since REXX does not really need binding according to the good books how come it is so sensitive ? 4. What OS/2 parameters get get involved in this ? Code Page ? Isolation level (default assumes CS) ????? 5. I am going to rebind the three REXX isolation level bind files but I would like to get the systems identical and need to understand what it is that I have to correct, even if it means a rebuild. Ian Logan Lexmark International Sydney Australia ----- OS2DBM CFORUM appended at 11:05:53 on 92/10/13 GMT (by VCHOLUIG at SYDVM1) Subject: EE 1.3 - Moving Database accross disk drives Short of exporting every Database object, is there a simple way to move a databse from the D: drive to the E: drive???? An surgent solution is required for a "critical situation". Gerard Holuigue ----- OS2DBM CFORUM appended at 13:56:01 on 92/10/13 GMT (by EYERMAN at DALHQIC2) Subject: the meaning of beep Ref: Append at 00:33:25 on 92/10/13 GMT (by WYATTDP at SYDVM1) The three beeps are for the activation of each DBM Netbios thread. In order to use Netbios, all three threads need to be active. I image that there are not enough netbios resources defined on your machine. The netbios resources can be increased by changing the sessions, NCBs, and names parameters found in the NETBEUI_nif section of the protocol.ini file. The file is located in the ibmcom subdirectory. I do not know of any hard and fast rule for increasing the resources, but there are my settings: sessions = 70 NCBs = 140 Names = 31 HOWEVER, my machine is a database server and DDCS/2 gateway. The numbers will be lower for a client machine. David Eyerman Software Vendor Systems Center ----- OS2DBM CFORUM appended at 13:58:24 on 92/10/13 GMT (by DMCINNIS at TOROLAB3) Subject: EE 1.3 - Moving Database accross disk drives Ref: Append at 11:05:53 on 92/10/13 GMT (by VCHOLUIG at SYDVM1) You can back it up, drop the original, then create a new database on the drive of your choice and restore. Dale McInnis / Toronto Canada (:->) Workstation Database Development VM/PROFS: TOROLAB3(DMCINNIS) ----- OS2DBM CFORUM appended at 07:04:56 on 92/10/14 GMT (by WYATTDP at SYDVM1) Subject: the meaning of beep Ref: Append at 13:56:01 on 92/10/13 GMT (by EYERMAN at DALHQIC2) Thanks David, we had checked these resources but will check again. - David Wyatt ----- OS2DBM CFORUM appended at 07:07:02 on 92/10/14 GMT (by JWILK at SYDVM1) - Subject: Products supporting ES DBM from OS/2 Windows or DOS Does anyone have a list of Products (& vendors) that support ES DBM either from OS/2 itself or via DOS or Windows Requesters. I'm interested in both End User and Programmer tools !!!! Thanks John Wilkinson ----- OS2DBM CFORUM appended at 07:29:57 on 92/10/14 GMT (by LX0037 at SYDVM1) OS2DBM CFORUM appended at 17:02:51 on 92/10/13 EST (by LX0037 at SYDVM1) Subject: SQL0805N error on PREPARE via REXX - recovered database. Folks | Ran DBM BIND @SQLUBIND.LST TO DATABASE mydatabase and it created | three additional package files SQLAC1A0 SQLAR1A0 SQLAU1A0 which | match the SQLAC1A1 SQLAR1A1 and SQLAU1A1 I already have. Problem | solved but how come my REXX program runs OK at home without the | -0 suffix files ? What factor triggers the -0 suffix ? This is a repeat of an entry in the oS2SQL forum because this forum seems more appropriate. I have built a database on a standalone DBM machine - using os/2 2.0 and ES 1.0. Program interface is via REXX dynamic SQL and works fine. Now have to instal the database and programs in the production machine which was constructed from the same OS/2 2.0 and ES 1.0 but it does have a comms manager component for 3270 access. This is the only difference in configuration which is all defaults all the the way. I dumped the database to diskettes and restored up onto the production machine. All OK and QM lets me see the tables and SQL queries via QM all work fine. When I run the REXX program, the first attempt to invoke a PREPARE via SQLEXEC results in an error SQL0805N saying that package "NULLID.SQLAC1A0 not found". I used a QM query of "SELECT * FROM SYSIBM.SYSPLAN" to look at the package names in both systems and they are identical in every respect. There is a package SQLAC1A1 but no package called SQLAC1A0. Questions : 1. Why is the SQLEXEC looking for a different package now ? 2. How do you relate the name of the package back to the bind options etc to see what it is that is different. Obviously SQLEXEC has some methodolgy but what is it ? 3. Since REXX does not really need binding according to the good books how come it is so sensitive ? 4. What OS/2 parameters get get involved in this ? Code Page ? Isolation level (default assumes CS) ????? 5. I am going to rebind the three REXX isolation level bind files but I would like to get the systems identical and need to understand what it is that I have to correct, even if it means a rebuild. Ian Logan Lexmark International Sydney Australia ----- OS2DBM CFORUM appended at 11:28:28 on 92/10/14 GMT (by 75832092 at EHONE) Subject:Cloning a View definition from AS/400 to PS/2 I've a database on AS/400 with some views defined on it. Is there any way to replicate these views on a PS/2 database without redefine it any time they change ? What i'm locking for is a way to get the view definition from AS/400 and replicate it on PS/2. I'm using DDCS/2 on the PS/2 station. I know that in the SYSVIEWS table i can find for each view some records with the SQL CREATE command used to build the view. If i EXPORT the view than data are coming down. Any suggestion ......... Thanks Tiziano ----- OS2DBM CFORUM appended at 14:56:08 on 92/10/14 GMT (by MALKEMUS at TOROLAB3) Subject: A few questions Ref: Append at 00:34:10 on 92/10/10 GMT (by VCHOLUIG at SYDVM1) >1. Can we used REORG and RUNSTATS through RDS? > Will the actual work be done on the Server or the Requester? Reorg, yes. Runstats, I think so (anyone know for sure?). The work would be done on the server. >2. REORG work file > Using RDS, will the work file parameter relate to the client > or the Server? The server. >3. What locks are taken by REORG? I expect a Table lock??? An exclusive table lock. Nobody else may read the table. >4. Does Referencial integrity has any impact on REORG performance? No. RI constraints are not checked or processed in any way during a reog. >5. What lock is taken by RUNSTATS? > Can it impact a program running in parallel? The share level parameter controls this. "Reference" gets a shared table lock, allowing others to read the table but not change anything. "Change" gets an IS (intent shared) table lock, letting others to read and change the table. In the latter case, the runstats utility will be getting row locks, so performance will suffer. >6. What lock taken by SQLBIND? > Can we re-bind a program while it is running? Bind will get various locks on rows in the catalog, some shared (e.g., on SYSIBM.SYSTABLES rows for tables mentioned in the static SQL statements), some exclusive (e.g., added or replaced rows in SYSIBM.SYSPLANS). While the program is running, the runner will be holding shared locks on some of the rows the binder needs exclusively. The binder will wait until all the current runners have committed. Then the bind will proceed. Those attempting to run the program during this time will have to wait until the bind is done, so their shared locks can be granted. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 15:20:23 on 92/10/14 GMT (by VERSTEEG at UITVM1) Subject: A few questions Ref: Append at 14:56:08 on 92/10/14 GMT (by MALKEMUS at TOROLAB3) Yes, RUNSTATS can be run remotely. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 17:43:38 on 92/10/14 GMT (by AMRI040 at OS2CUST) Subject: Roll-forward problems I am having a problem implementing roll-forward recovery. I have created a database and changed configuration to log_retain=yes and backup the database. I then add several records and do another backup. I then restore the first backup and attempt to roll-forward to the end of the log files. When I check the database (through Query Mgr.) the records I added after the first backup are not present. Since Loghead is what was present at the first backup, and all log files are present in the log path I should be able to apply all committed changes. Is there something I'm missing? I have read the Guide to DBM section on Recovering a Database several times now. Bruce Clarke ----- OS2DBM CFORUM appended at 10:15:40 on 92/10/15 GMT (by VERSTEEG at UITVM1) Subject: Roll-forward problems Ref: Append at 17:43:38 on 92/10/14 GMT (by AMRI040 at OS2CUST) Bruce, It is working fine for me. Are you sure your updates were committed? Roll forward will leave the database in a consistent state, so any transactions that were not complete (committed) will be rolled back. Did the timestamp of the last committed transaction in the Roll Forward status on the Recovery window indicate that your updates were included? Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 22:43:41 on 92/10/15 GMT (by LX0037 at SYDVM1) Subject: SQL0805N error on PREPARE via REXX - recovered database. OS2DBM CFORUM appended at 17:02:51 on 92/10/13 EST (by LX0037 at SYDVM1) Folks My problem has been resolved ( Thanks Anton). The supposedly identical OS/2 installations were not in fact so. My base system at home was pure GA 2.0 but the office production system had been bumped up to the 2.01 beta ( 2.0 + patches). This caused the CSD level as seen by SYSLEVEL to increment. When the ES SQLEXEC constructs package names it uses the CSD level in the formulation so as a result it looked for a different package name to the one that I had restored from the backup of the 2.0 GA system. Bottom line : If you are dumping and restoring a database from one machine to another, and you are using REXX it is advisable to rebind the SQLEXEC REXX routines to create the required packages. DBM BIND @SQLUBIND.LST TO DATABASE xxxxxxx where xxxxx is your database name. This builds the three isolation level packages for CS RR and UR. Since we will see a formal 2.01 shortly this may be an issue for more of us in future. Ian Logan c/- Lexmark International Sydney Australia ----- OS2DBM CFORUM appended at 13:49:53 on 92/10/16 GMT (by RUECKER at MUNIVM4) Subject: Object Table Maintenance Ref: None When in Query Manager, choosing Tools, there is an Option called: 'Object Table Maintenance'. Using Help, it states that you should run this once in a while. We would like to do this remotely, using REXX SQL statements, but we don't know which SYSIBM Tables are effected by this 'Object Table Maintenance' Does someone know which tables are meant ?? ----- OS2DBM CFORUM appended at 19:45:22 on 92/10/16 GMT (by NAAO3IY at HONE85) Subject: Object Table Maintenance Ref: Append at 13:49:53 on 92/10/16 GMT (by RUECKER at MUNIVM4) Object Table Maintenance goes against the semi-undocumented table with a funny name I can't remember offhandthat Query Manager uses as a repository for its own objects (queries, forms, procs....). It just does a reorg, etc., against that table. John Kennedy, Hoechst Celanese (The OS/2 Hobbit) ----- OS2DBM CFORUM appended at 20:39:55 on 92/10/16 GMT (by 63146635 at RIOVM1) Subject: Pruned lines.. This CFORUM has just been pruned. Where can I find the pruned lines ? Archived some place ? Maybe the forum header could tell.. Thanks for any help. A. Lomboglia IBM Brazil - FSC AD/Cycle Support ----- OS2DBM CFORUM appended at 00:19:19 on 92/10/17 GMT (by VCHOLUIG at SYDVM1) Subject: A few questions Ref: Append at 14:56:08 on 92/10/14 GMT (by MALKEMUS at TOROLAB3) Thanks Tim. About the bind locks.. Are the locks held by the running program held only while it starts? Or are they held while it is running? I am dealing with a program which runs 7 days a week.. ----- OS2DBM CFORUM appended at 09:24:11 on 92/10/19 GMT (by VERSTEEG at UITVM1) Subject: Object Table Maintenance Ref: Append at 19:45:22 on 92/10/16 GMT (by NAAO3IY at HONE85) That table is QRWSYS.QRWSYS_OBJECT. It is possible to REORG this table (and RUNSTATS as well) remotely via a REXX program for instance. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 12:18:39 on 92/10/19 GMT (by BDJESSUP at CLTVM3) Subject: Dos Database Client support Documentation Help Well, I have been playing around with this for about a week now and have just about had enough. Is there a Red book or something like it on the DOS Client support. The Docs for the database manager leave you alittle short. I also noticed a few other people trying to figure this out a while ago and they must have had help off line as I never saw any real help on the forum. I have a P70 set up as a server with CLient support installed. I have another PC with DOS 5.0, PCLP, and a DBDRQLIB directory. I have started the database manager on the server and have no problems doing anything on the server database. I get a 1042C when I run the STARTDRQ pgm from the requester ??? I would love to talk to someone who made their way through this successfully. Or even better I would love to see a real step by step through the process of setup, catalog and running a program from a DOS workstation. Regards... Brian Jessup Charlotte ----- OS2DBM CFORUM appended at 17:00:09 on 92/10/19 GMT (by 70617676 at EHONE) Subject: NUM-CHAR conversion for SQL DBM Is there a solution to convert in CHAR a character string with only numeric characters (example: var = '100') ? My requirement is to be able to transfer a Data Host variable of a SQLEXEC statement with only numeric characters in a Character(Fixed) column of a DBM table. Currently, I have the following message : SQL0301N The value of a host variable in the EXECUTE or OPEN statement cannot be used because of its data type. Thank you for your help. Michel Myc ----- OS2DBM CFORUM appended at 17:31:14 on 92/10/19 GMT (by IL46290 at OS2CUST) Subject: SQLPREP & DM authority PROBLEM The SQL precompile process using Database Services, under OS/2 Version 2 with Extended Services/2 is not recognizing indirect (group) authorities. BACKGROUND We are developing DB2 applications on OS/2 workstations using AD/Cycle facilities and the OS/2 Database Manager (DBM 2.0). Our workstations are all OS/2 LAN connected and we use one machine as a remote database server. We use the Micro Focus COBOL/2 Workbench, which has a customized SQL precompiler, to assist in writing compatible applications. DETAIL In order to simplify DBM security administration, we choose to grant table privileges (query, add, change, delete) to the PUBLIC group ID. However, when programs are precompiled, we get an SQL0551N error: "<authid> does not have the privilege to perform operation". A quick check proved that it is not a Micro Focus Workbench problem because we get the same error if we use the OS/2 SQLPREP command to precompile the program. Our only solution, so far, has been to grant direct authority to each of our application developers, but this is not a desirable option because we are moving all of our developers down to the workstation platform. So, has this problem been reported before? Is there a quick fix, or will it have to wait for the next release? Is it in the next release? Elizabeth Parker, University of Florida Information Systems ----- OS2DBM CFORUM appended at 17:58:20 on 92/10/19 GMT (by BDJESSUP at CLTVM3) Subject: Dos Database Client support Documentation Help Well, I have been playing around with this for about a week now and have just about had enough. Is there a Red book or something like it on the DOS Client support. The Docs for the database manager leave you alittle short. I also noticed a few other people trying to figure this out a while ago and they must have had help off line as I never saw any real help on the forum. I have a P70 set up as a server with CLient support installed. I have another PC with DOS 5.0, PCLP, and a DBDRQLIB directory. I have started the database manager on the server and have no problems doing anything on the server database. I get a 1042C when I run the STARTDRQ pgm from the requester ??? I would love to talk to someone who made their way through this successfully. Or even better I would love to see a real step by step through the process of setup, catalog and running a program from a DOS workstation. Regards... Brian Jessup Charlotte ----- OS2DBM CFORUM appended at 20:51:09 on 92/10/19 GMT (by HOPKINS at AUSVM8) Subject: Pruned lines.. Ref: Append at 20:39:55 on 92/10/16 GMT (by 63146635 at RIOVM1) Soon to come; we're building the archival processor now; shouldn't be too long before the header will reflect IBM Internal and External access. Ken Hopkins, OS/2 Software Service and Support ----- OS2DBM CFORUM appended at 21:22:02 on 92/10/19 GMT (by RHARBUS at TOROLAB3) Subject: Dos Database Client support Documentation Help Ref: Append at 17:58:20 on 92/10/19 GMT (by BDJESSUP at CLTVM3) I am not sure which Database documents you have looked at ... Have you looked at "IBM Extended Services for OS/2 - Guide to Database Manager Client Application Enablers"? It is document number S04G-1114-00. Bob Harbus ----- OS2DBM CFORUM appended at 21:34:19 on 92/10/19 GMT (by MALKEMUS at TOROLAB3) Subject: A few questions Ref: Append at 00:19:19 on 92/10/17 GMT (by VCHOLUIG at SYDVM1) A running program will hold at least a shared lock on each row in SYSPLANS for each plan it is using. These locks will be released at commit but reacquired on first use of each plan after commit. Bind doesn't get along well with running applications. My previous append may have painted the picture a bit too rosy. In theory, with a simply, one-plan application that does frequent commits, you should be OK. But with complications, such as multiple plans, unpredictable commits, etc., you could get into trouble. Try to do your binds during slow times, at least. By the way, our lock manager is "fair" in its lock waiting/granting method. That means someone (the binder, in this case) asking for a lock that's incompatible with existing locks will cause new requesters of compatible (with existing) locks to wait. So a steady stream of S-lock holders and requesters will not cause a binder to wait forever. An X-lock will be granted as soon as all the *current* holders of S-locks have released them at commit time. Tim Malkemus, Toronto Lab ----- OS2DBM CFORUM appended at 13:59:45 on 92/10/20 GMT (by ROBERT at TOROLAB4) ..... OS2DBM CFORUM modified at 16:45:39 on 92/10/20 GMT (by ROBERT at TOROLAB4) Subject: Deleted append ----- OS2DBM CFORUM appended at 14:26:54 on 92/10/20 GMT (by FCOC079 at OS2CUST) Subject: SQLPREP & DM authority Ref: Append at 17:31:14 on 92/10/19 GMT (by IL46290 at OS2CUST) You are experiencing a "feature" of DBM: it doesn't (seem) to honor group con- nections at Precompile (or Bind) time. That is, you're right, the prepper/ binder has to have explicit privileges on objects at prep/bind time, regardless of what privileges may exist via group connections and group privileges. Dave Boll ----- OS2DBM CFORUM appended at 16:33:46 on 92/10/20 GMT (by IL02075 at OS2CUST) Subject: DARI DLL Sharing I have been having trouble using the SQLZ_HOLD_PROC return code in ruturning from my ARI functions. It seems that if an application calls an ARI procedure and returns using the SQLZ_HOLD_PROC return code any other application trying to access that ARI DLL module will crash (no sqlcode or message.. just CRASH). SQLZ_DISCONNECT_PROC on the other hand is 1. very slow for an application that makes a number of calls to the ARI module. 2. eventually returns sqlcode -1111 if an application makes a number of calls in rapid succession to tha ARI module (say.. 175) Could this have something to do with the 16bit code segments (or 16bit Data segments) not being shared. I have appends on both the C/Set2 and Toolkt20 forums about the warnings I receive when trying to link386 my ARI DLL modules. Is this the same problem?? I have tried many combinations in my module definition file in terms of SINGLE/MULTIPLE SHARED/NONSHARED data segments. It seems that I am unfortunatly left with the grim choice of by which method my applications can fail. Does anyone have their ARI code working under ES. (using C/Set2, LINK386, OS/2 2.0)?? This is urgent so please feel free to contact me: Mike Rowan, Mainline Information Systems (904) 422-0741 or (904) 599-4204 Mike Rowan, Mainline Information Systems Tallahassee Fl ----- OS2DBM CFORUM appended at 16:51:47 on 92/10/20 GMT (by ROBERT at TOROLAB4) Subject: SQLPREP & DM authority Ref: Append at 17:31:14 on 92/10/19 GMT (by IL46290 at OS2CUST) Try GRANT BINDADD ON DATABASE TO authid This will grant authid (which may be a group or PUBLIC) bind and create package privilege on the currently connected database. This is described in the command reference pg 5-27. I will verify that groups work as documented. Robert Begg ----- OS2DBM CFORUM appended at 17:22:52 on 92/10/20 GMT (by ROBERT at TOROLAB4) Subject: SQLPREP & DM authority Ref: Append at 14:26:54 on 92/10/20 GMT (by FCOC079 at OS2CUST) I verified that the grant bindadd command does work for groups. (refer to my other append). Sorry, this isn't a 'feature'. but, ... you get CONTROL authority also, which you keep, even if BINDADD is revoked. Robert Begg ----- OS2DBM CFORUM appended at 22:40:18 on 92/10/20 GMT (by KUSTERER at MANVM1) ..... OS2DBM CFORUM modified at 18:47:46 on 92/10/26 GMT (by KUSTERER at MANVM1) Subject: Dos Database Client support Documentation Help Ref: Append at 17:58:20 on 92/10/19 GMT (by BDJESSUP at CLTVM3) All right, you asked for a step by step procedure for getting DOS DataBase clients up and running. I just went through all the steps on two clean machines (server & requester) and got everything to work. I wrote down everything that I just did and here's the procedure. WARNING: this is a long append, so if you don't care about the DOS Clients, just skip on to the next one. |added new step 11, renumbered steps, reordered STARTDRQ & LOGN, |changed printf statement in TEST1. ============ DOS DataBase Client Cookbook ====================== 1. Install Extended Services with DataBase Server. Remember, there are two flavors of Extended Services, one with the server and one without. Obviously, you need the one with. When it asks for the Workstation Name, for our example here, we'll use AAAAAAAA. You can put in whatever applies to your situation as long as it's unique. Shutdown and reboot your machine once you're done installing. 2. Go into User Profile Management, logon with an adminstrator ID (for our example, we'll use the USERID/PASSWORD combination that is shipped as the default). Add a regular user type ID/PASSWORD combination (we'll use JOEUSER/ZZZZZZZZ). 3. Start the DataBase Manager using the DBM Command Line Interface. When it is starting, make sure that the machine beeps three times. THIS IS VERY IMPORTANT. If it doesn't beep, it means that there are not enough Names,Sessions,etc. available for it to talk on the network. The READ.ME file on the first ES diskette has instructions for fixing this in the section DATABASE MANAGER AND LAN RESOURCES. 4. Create the SAMPLE database by typing SQLSAMPL. Once this completes, start using the database by entering the following: DBM START USING DATABASE SAMPLE 5. Create a small C program called TEST1.SQC containing the following: =========== cut here =========== #include <stdio.h> #include <string.h> #include <sqlenv_.h> EXEC SQL INCLUDE SQLCA; EXEC SQL BEGIN DECLARE SECTION; char Statement[254]; char Name[10]; char Job[6]; EXEC SQL END DECLARE SECTION; main() { char DataBase[9]; strcpy(DataBase,"SAMPLE"); printf("Connecting Database..."); sqlestrd(DataBase,SQL_USE_SHR,&sqlca); printf("\nStart DB: SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); if(SQLCODE == 0) { strcpy(Statement,"SELECT name,job FROM userid.staff"); EXEC SQL PREPARE s1 FROM :Statement; printf("\nPrepare: SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); EXEC SQL DECLARE c1 CURSOR FOR s1; printf("\nDeclare: SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); EXEC SQL OPEN c1; printf("\nOpen : SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); while (SQLCODE == 0) { EXEC SQL FETCH c1 INTO :Name,:Job; if (SQLCODE == 0) printf("\n%s %s",Name,Job); } EXEC SQL CLOSE c1; printf("\nClose : SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); EXEC SQL COMMIT; printf("\nCommit : SQLCODE = %ld (%s)",SQLCODE,sqlca.sqlerrmc); } } =========== cut here =========== 6. Prep, compile, & link the program by entering the following commands: sqlprep test1.sqc sample /p /b cl -c /AL /FPa /Zp test1.c link /NOD /NOE test1.obj,,,pcdrstat+llibcar+graphics; 7. Give our regular user the necessary privileges by entering the following commands: DBM GRANT CONNECT ON DATABASE TO JOEUSER DBM GRANT ALL PRIVILEGES ON TABLE ORG TO JOEUSER DBM GRANT ALL PRIVILEGES ON TABLE STAFF TO JOEUSER DBM GRANT EXECUTE ON PACKAGE TEST1 TO JOEUSER 8. Create another small C program called CATALOG.SQC containing the following: =========== cut here =========== #include <stdio.h> #include <string.h> #include <sqlenv_.h> EXEC SQL INCLUDE SQLCA; main() { EXEC SQL BEGIN DECLARE SECTION; char Statement[80]; EXEC SQL END DECLARE SECTION; char DataBase[9]; char Alias[20]; char DBType; char NodeName[9]; char DBDrive; char DBComment[20]; char CmtCodePage; strcpy(DataBase,"SAMPLE"); strcpy(Alias,""); DBType = '1'; strcpy(NodeName,"AAAAAAAA"); DBDrive = '0'; strcpy(DBComment,""); CmtCodePage = '\0'; sqlecatd(&DataBase,&Alias,DBType,&NodeName,DBDrive,&DBComment,CmtCodePage,&sqlca); printf("\nCatalog Return Code: SQLCODE = %ld",SQLCODE); } =========== cut here =========== 9. Prep, compile, & link the program by entering the following commands: sqlprep catalog.sqc sample /p /b cl -c /AL /FPa /Zp catalog.c link /NOD /NOE catalog.obj,,,pcdrstat+llibcar+graphics; 10. Now we leave the server machine and go to the requester machine that has the DOS Client Application Enabler stuff installed. Make the directory called DBDRQLIB the current directory. Don't forget to bring along a copy of the CATALOG.EXE and TEST1.EXE files that we just created. 11. Make sure that NETBIOS is up and running on the requester machine. For DOS machines, this means making sure that the device= dxm????? lines are present in the CONFIG.SYS (dxmt0mod.sys being the important one as it's the NETBIOS). For OS/2 2.0 machines, the DOS VDMs must have the NETBIOS Virtual Device Driver (VDD) set up. To do this, make \IBMCOM the current directory and enter SETUPVDD. This will add the VDD lines to CONFIG.SYS. Shutdown and reboot. 12. Edit the file DBDRQLIB.CFG and change the SQLNAME to equal our requester workstation name (we'll use BBBBBBBB). Also make sure that SQLLIB points to the right drive letter. 13. To catalog the database, just run the catalog program we created by entering the following: catalog The displayed return code should be 0 meaning everything is ok. Also, a subdirectory called SQLDBDIR should have been created. 14. Logon by entering sqllogn2 and then entering JOEUSER for the ID and ZZZZZZZZ for the password. 15. Start the Database requester by entering startdrq. 16. Now, run our test program by entering TEST1 and you should see the names and jobs of everyone in the SAMPLE database scroll by on the screen. 17. That's all there is to it !!! ============ End: DOS DataBase Client Cookbook ================= Joe Kusterer ----- TEAM OS/2 Northern VA ----- FSC Manassas ----- OS2DBM CFORUM appended at 14:09:25 on 92/10/21 GMT (by PHOONFCB at HKGVM8) Subject: Cannot open database in os/2 DBM through the Query Manager Everything works fine before today. However, now I get an error QRW0384W from the Query Manager when I try to open a database. The message indicates that the database is damaged and a recovery is necessary. When I select "YES" to recover, it jumps to a System Error SYS1943 and dumps me a list of register values. What should I do? Thanks. Franklin Phoon ----- OS2DBM CFORUM appended at 03:55:11 on 92/10/22 GMT (by IL02075 at OS2CUST) Subject: How did they Link What compiler and linker did TOROLAB use to write ES 1.0? Surely not LINK386 & C/Set. Where can I get it. Mike Rowan, Mainline Information Systems Tallahassee Fl ----- OS2DBM CFORUM appended at 10:10:07 on 92/10/22 GMT (by 75824726 at EHONE) Subject:sum(column) over 2 joined tables. I'm developing a C program working with a complex database (more than 40 tables ) (Obviously I work with a team ) As the database will reside over AS/400 and will be accessed through DDCS/2, some columns have the data type DECIMAL(5,1). DECIMAL type does not exist in C language, so i have employed 'double' type host variable. All is working fine but, debugging the program, i observe the following bug. I have the following SQL Statement imbedded in C code : EXEC SQL SELECT SUM ( RTCTB ) INTO :H_VICPB FROM GRIDT01L,GCAFI02L WHERE ( (GCAFI02L.CFCFI = GRIDT01L.RTCFI) AND (GCAFI02L.CFTPC = 'PA' ) AND (GRIDT02L.RTNAV = 'SF1') ) ; RTCTB has type DECIMAL(5.1),H_VICPB is double. H_VICPB is then loaded in the column VICPB of the table GVIAG00f whose type is still DECIMAL(5,1). After the program has executed I observe that : 1) if the table GRIDT01L has a little number of rows involved in the join (e.g. less than 10 ) the sum is correct and the value retrieved from GVIAG00F is right. 2) if the table has 16 rows joined, the sum isn't right, but the DBM seams forget a row, i.e. the value retrieved from GVIAG00F is the right sum less the value of a row. The strange thing is that the same query executed offline with CLI yields the right values in both cases. Another strange thing is that no SQL error arise nor from program nor from CLI. I do not know if this is a CSET/2 problem ( I have not installed the fixes ) or a DBM problem. Has anyone a suggestion ? Thanks| ----- OS2DBM CFORUM appended at 11:01:05 on 92/10/22 GMT (by F080593 at ORYVM4) Subject: About the format "SPECIAL DATA". Extended Services OS/2 v2.00. I created a column with the format "SPECIAL DATA". I want to know if it's possible to insert a variable length binary file ( an image file ) into this column ? F080593 at ORYVM4 LEFEBVRE,St{phane ========================================================================= ----- OS2DBM CFORUM appended at 12:58:35 on 92/10/22 GMT (by VERSTEEG at UITVM1) Subject: About the format "SPECIAL DATA". Extended Services OS/2 v2.00. Ref: Append at 11:01:05 on 92/10/22 GMT (by F080593 at ORYVM4) Special Data, or LONG VARCHAR in DBM terms, can be used to store binary data like image data. One field can contain up to 32K bytes, but you can define more than one LONG VARCHAR per table, if you want to store more than 32K in a row. The theoretical maximum is somewhere between 100 and 200 LV columns per row. Of course it is also possible to spread the image over multiple rows, rather than columns, by adding some kind of sequence number to the key. This would be a bit more open-ended and perhaps a bit faster,. for large images. A couple of restrictions apply to LV though. QM doesn't support them. You would have to write a program to load and retrieve them from the database. Or use a utility like Import/Export. You cannot do any searches, joins etc. on LV data. Anton Versteeg - ESAT PWS CoC Uithoorn, NL *** 1,000,000+ OS/2 2.0 *** ----- OS2DBM CFORUM appended at 14:04:02 on 92/10/22 GMT (by AMRI040 at OS2CUST) Subject: Force user off Does anyone know of a way to force users off of DBM to perform a backup. There must be some way of doing this since BACKUP DATABASE will not run with anyone attached to the database. Any help is appreciated. Thank You. Bruce Clarke (American Re-Insurance) ----- OS2DBM CFORUM appended at 14:16:51 on 92/10/22 GMT (by RHARBUS at TOROLAB3) Subject: How did they Link Ref: Append at 03:55:11 on 92/10/22 GMT (by IL02075 at OS2CUST) ------------------------------------------------------------------------ This is probably more that what you wanted, but here it is anyway: 1. You are correct, for the ES1.0 database product set LINK386 and CSET/2 were not used. 2. Here is the breakdown of which compilers/linkers/assemblers were used for the various products in the ES1/0 database family: Product Compiler Linker Assembler ======================================================================== Database Manager IBM C/2 V1.1 16-bit OS/2 Version 1.3 MASM/2 compiler. MASM386 Query Manager same same MASM/2 DDCS/2 same same MASM/2 Database Administrator tools same same MASM/2 PC DOS Requester Microsoft 6.0 Microsoft 5.1 MASM/2 ------------------------------------------------------------------------ Bob Harbus IBM Corporation Lab - Toronto Workstation Database Development ------------------------------------------------------------------------ ----- OS2DBM CFORUM appended at 14:41:35 on 92/10/22 GMT (by RDSMITH at AUSVM1) Subject: How did they Link Ref: Append at 14:16:51 on 92/10/22 GMT (by RHARBUS at TOROLAB3) ...and one minor :-) clarification. It wasn't done in TOROLAB. It was done in the Austin Personal Systems Programming lab before the personal systems database development mission was transferred to Toronto. Roy Smith ----- OS2DBM CFORUM appended at 16:24:29 on 92/10/22 GMT (by G3035 at HONE84) - Subject: Dos Database Client support Documentation Help Ref: Append at 22:40:18 on 92/10/20 GMT (by KUSTERER at MANVM1) Joe, Thank you very much for the instructions. I am trying to use them to test access from a DOS session on the same workstation as the database. The machine name on the database server is T0000808. My SQLNAME in DBDRQLIB is P0000808. When I execute STARTDRQ or SQLLOGN2, I get: SQL1042C An unexpected system error occurred. Do you (or any lurkers) have any ideas of what might be wrong? Andy F. Miller, GPU Service Corporation ----- OS2DBM CFORUM appended at 13:33:19 on 92/10/23 GMT (by KUSTERER at MANVM1) Subject: Dos Database Client support Documentation Help Ref: Append at 16:24:29 on 92/10/22 GMT (by G3035 at HONE84) Andy, I was just able to duplicate your problem (SQL1042C). On the machine I had set up as the server in my previous example, I cataloged the SAMPLE database and tried running SQLLOGN2 and STARTDRQ in a DOS VDM and got the same 1042 error. To fix it, it looks like I need another step in my procedure something like the following: 10a. Make sure that NETBIOS is up and running on the requester machine. For DOS machines, this means making sure that the device= dxm????? lines are present in the CONFIG.SYS (dxmt0mod.sys being the important one as it's the NETBIOS). For OS/2 2.0 machines, the DOS VDMs must have the NETBIOS Virtual Device Driver (VDD) set up. To do this, make \IBMCOM the current directory and enter SETUPVDD. This will add the VDD lines to CONFIG.SYS. Shutdown and reboot. Once I ran the SETUPVDD and rebooted, I was able to successfully complete the rest of my procedure. Joe Kusterer ----- TEAM OS/2 Northern VA ----- FSC Manassas ps. If this fixes the problem for you, append back here letting me know and I'll update the "procedure" append to add step 10a. ----- OS2DBM CFORUM appended at 15:04:06 on 92/10/23 GMT (by MDBC020 at OS2CUST) Subject: QRW2273W ERROR MESSAGE IN QUERY MANAGER I'M getting a QRW2273W when I am running a query in query manager on a local database. The message is "The disk is full. Clear some space on the 'C' drive or specify a query that results in less data. The database is on the E: drive which has 300m free, the C: drive is the system drive and only has about 10M free. Why would running a query that is a select fill up the C: drive, and how do I redirect it to another drive so I won't fill up the C: drive. The query is not that big of a query! Thanks. KIRK KNESS ----- OS2DBM CFORUM appended at 15:53:00 on 92/10/23 GMT (by F010753 at MOPVMA) Is there anyway to execute an OS2 command file from SQL procedure under an OS2 2.0 DBM environment? Example under host VM environment it could be: 'CMS myexec ...' anyone got an idea| Thanks Alain Tremolet (TREMOLET at MOPPROFS) ----- OS2DBM CFORUM appended at 16:32:40 on 92/10/23 GMT (by GCHIN at NYCVMIC1) Subject: Visual Basic Interface Ref: Append at 15:04:06 on 92/10/23 GMT (by MDBC020 at OS2CUST) Doe anyone know if there is an Visual Basic Interface to DBM. ----- OS2DBM CFORUM appended at 16:44:18 on 92/10/23 GMT (by FRML075 at OS2CUST) Subject: Force user off Ref: Append at 14:04:02 on 92/10/22 GMT (by AMRI040 at OS2CUST) We obtained a package from IBM's OS2TOOLS disk called KILLDBM2. It contains a program (KILLDBM2.EXE) which disconnects all users from all databases on the server, then performs a STOPDBM. We use this program to do just what you describe: forcibly disconnect all users so that backups can be taken. According the accompanying documentation, KILLDBM2 requires Extended Services and it uses an undocumented, unsupported API call called SQLEKILL. Louis Rios, Farmland Industries 816/459-6176 ----- OS2DBM CFORUM appended at 19:08:42 on 92/10/23 GMT (by SC025203 at AUSVM8) Subject: QRW2273W ERROR MESSAGE IN QUERY MANAGER Ref: Append at 15:04:06 on 92/10/23 GMT (by MDBC020 at OS2CUST) Kirk, Perhaps your Database log files are being placed on "C". See the "Guide to Database Manager" (S04G-1013-00), Chapter 9 for Database Configuration Parameters, specifically the "logpath" and "newlogpath" parameters to check where the log files are going and how to change if it you need to. Hope this helps some. Stephen Poole OS/2 Service and Support - IBM Austin, TX ----- OS2DBM CFORUM appended at 19:16:00 on 92/10/23 GMT (by SC025203 at AUSVM8) Subject: Executing an OS/2 Command File from SQL Ref: Append at 15:53:00 on 92/10/23 GMT (by F010753 at MOPVMA) Alain, Executing an OS/2 command file is not really a function of SQL or the Database Manager. What language are you using? There is probably a language construct or "system call" available to do what you want. Are you using REXX, "C", COBOL, or FORTRAN? Stephen Poole OS/2 Service and Support - IBM Austin, TX ----- OS2DBM CFORUM appended at 18:37:24 on 92/10/26 GMT (by KUSTERER at MANVM1) Subject: Dos Database Client support Documentation Help Ref: Append at 16:31:22 on 92/10/26 GMT (by G3035 at HONE86) That's great, Andy. I've gone ahead and modified the "Cookbook" to incorporate your suggestions. Joe Kusterer ----- TEAM OS/2 Northern VA ----- FSC Manassas ----- OS2DBM CFORUM appended at 20:13:51 on 92/10/26 GMT (by IL04688 at HONE85) Subject: Query Manager Landscape-style Reports Ref: Append at 18:37:24 on 92/10/26 GMT (by KUSTERER at MANVM1) Has anyone been able to get Query Manager reports to come out in landscape mode under OS/2 2.0 base, ES 1.0, LAN Requester 2.0, with an IBM 4019 LAN-attached printer thru a 4033 connection ? I thought I had read something along these lines, but a forum search using "landscape" came up blank. Thanks. Leo Tornow, Northwest Pipeline, SLC UT ----- OS2DBM CFORUM appended at 20:23:13 on 92/10/26 GMT (by MDBC020 at OS2CUST) Subject: QRW2273W ERROR MESSAGE IN QUERY MANAGER Ref: Append at 19:08:42 on 92/10/23 GMT (by SC025203 at AUSVM8) The log files are on the E: drive, which has 300m free. Also , this is a read only query, why would the log file fill up in thsi situation. Thanks Kirk Kirk Kness ----- OS2DBM CFORUM appended at 22:06:30 on 92/10/26 GMT (by NAAO3IY at HONE83) Subject: Query Manager Landscape-style Reports Ref: Append at 20:13:51 on 92/10/26 GMT (by IL04688 at HONE85) Query Manager's printing support is abysmal. "Print" to disk and then do something with the result. John Kennedy, Hoechst Celanese (The OS/2 Hobbit) ----- OS2DBM CFORUM appended at 13:13:14 on 92/10/28 GMT (by UDSS013 at HONE82) Subject: DDCS/2 To DB2 Distributed Education Ref: Append at 21:25:01 on 92/10/08 GMT (by SDRYAN at DALVM3) | The course objectives for U4120 - Distributed Database Workshop, OS/2 to | DB2, are the following: I attended one of the workshops in Irving last spring. It was taught by a very talented guy by the name of Rick Weaver. If you are doing DDCS, it will be money well-spent. I highly recommend it. ----- OS2DBM CFORUM appended at 22:10:47 on 92/10/28 GMT (by ERICKSON at TDCSYS3) Subject: No Clocky - No Talky ! SQL1042C We ran into the SQL 1042 C Error problem in our lab yesterday. After OS/2 R2.0 with ES/1 had been running our application for awhile, we shut it down normally and also shut down OS/2 through the CTL-ALT-DEL prompt. When we restarted OS/2 and our application, we got an immediate SQL1042C error. Attempts to contact DBM through Query Manager failed in the same way. I followed the advice to replace the NET.ACC files in \MUGLIB\ACCOUNTS \IBMLAN\ACCOUNTS and \IBMLAN\INSTALL (it seems that they are interlinked and must all be in sync) and still had the same error message. We've been doing some hardware testing on this PS/2 80 8580-071 and had recently cleared out the CMOS memory. Our developer forgot to reset the clock, and we were running as if the platform were at 1/1/80. When I reset the clock to today's date and time, QM ran like a champ and we were able to bring our application back up after what appeared to be some recovery activity. Does a bogus clock end up killing DBM through invalid LOGs or some other mechanism? Would it be possible to give a more concise error message on this kind of problem. SQL1042C doesn't lead you to anything except suggesting a trace. Marc R. Erickson ----- OS2DBM CFORUM appended at 18:39:48 on 92/10/29 GMT (by WZ00885 at OS2CUST) Subject: Database Mgr backup I need to do an unattended backup of a database at night. If there is an existi ng backup, running DBM BACKUP DATABASE DBNAME TO DRIVE prompts me if I want to overwrite it. I would like to generate automatically the answer to the question and proceed with the backup. I thought about using an input file but it does no t seem to work probably because the actual backup is a subprocess of DBM BACKUP p BACKU P. Does anyone know how to get around this ? Thanks Charly Sorin. Applied ID and Information Systems ----- OS2DBM CFORUM appended at 20:36:50 on 92/10/29 GMT (by UDSS013 at HONE83) Subject: Loading null data. Ref: Append at 22:06:40 on 92/10/12 GMT (by MROACH at BOSTON) | I am trying to load data that may be null into fields defined as smallint | and date. It ain't working! We are using the import/export facility | of DBM as well as inserting through the CLI. Is there a way around this? | We don't want to corrupt the data just to get it loaded. Any help would | be appreciated. I just got done doing a comma-delimited ASCII import of a table with NULL data for both dates and smallints. In the case where there was a NULL, the imported file had two commas in a row. For example: 1,"A String",19921008 2,,19921009 3,"A String", ,"A String,19921010 shows NULL values for strings, dates, and smallints. If you are doing the data vis INSERTs from the CLI, use a value of NULL for the column that contains the null value. INSERT (ID, STR, START_DATE) INTO TBL VALUES(NULL, "A String", "10-08-1992") ----- OS2DBM CFORUM appended at 21:45:23 on 92/10/29 GMT (by KDROMREL at SFOVMIC1) Subject: Changing OS/2 DBM Configuration Ref: Append at 16:18:04 on 92/10/26 GMT (by ZEGGERT at ENDVM1) The only way you can change whether you're standalone, client, server, etc. that I'm aware of us to use REINST (or Add or Remove Features in your Extended Services Folder). The reason for this, is you will need different/additional code that wasn't loaded when you did your initial installation/configuration. You shouldn't lose anything when you do this. DB Mgr keeps track of your Databases, even across a reinst. It's always wise to back up your databases, though, just in case there is any problem. Kelvin D. Romrell ----- OS2DBM CFORUM appended at 22:07:43 on 92/10/29 GMT (by KDROMREL at SFOVMIC1) Subject: Force user off Ref: Append at 16:44:18 on 92/10/23 GMT (by FRML075 at OS2CUST) SQLEKILL is no longer undocumented nor unsupported. To get the documentation just send a note to: Customer and Vendor Enablement c/o IBM Canada Ltd. 1 Park Centre 895 Don Mill Road North York, Ontario, CANADA M3C 1W3 It is available to anybody upon request. The only warning associated with it, is that the function could change in future releases, which could require programs using the SQLEKILL interface to be changed. Kelvin D. Romrell