Search results for query: *

This should be a trivial question, but it is causing problems as our DBA has left. The DBA was also the UNIX administrator. User FRED has a v8 database on AIX to use for testing. We have a new developer BERT, and we wish to give him a copy of the database. Bert has DBA authority, so he runs...

I frequently have to write queries such as: select a.custno,a.payref,a.payamt from tab a where a.payref = (select max(b.payref) from tab b where b.custno = a.custno and b.paytype = 1) This query should give details of...

Is it possible to allow complex freehand SQL when querying against DB2. I am trying to use the 'WITH' structure to create a temporary table repeatedly used in a long query containg about 10 UNIONS. The error message says that I am only allowed to use SELECT statements. Thanks Brian

Hi, Our DBA has just left, so we are very short of expertise at the moment. We run DB2 v8 on AIX. Each evening, we copy the logfiles to the disaster recovery machine (about 100 logs) and 'roll forward to end of logs'. This seems to work OK. At period end, we copy the logs as usual, but...

DB2 v8 on AIX Table A contains CUSTNO, which is indexed as Unique Table B contains ORDNO and CUSTNO , both indexed seperately with ORDNO being unique,and CUSTNO being a foreign key Table C contains ORDNO, CUSTNO and ITEMNO each indexed seperately, with ITEMNO being unique, and CUSTNO and...

The idebug tool for AIX can theoretically access a core dump file and provide useful information. What I cannot find is a a method of relating the information given back to a cobol source line. Does anyone know of any documentation to help in this area? Thanks in advance Brian

Recently, we have seen intermittant batch program failures: IWZ995S SIGILL signal received. The location could not be determined. IWZ901S Program exits due to severe or critical error. program status = 134 When I copy the suspect records into a development database, the program appears to...

Is there a difference between these words, or are they 100% interchangeable? A colleague suggested the Inquiry was only used when trying to find a fault or analyse an eror, and Enquiry is for more general queations. Brian

Using AIX v5.3 and Cobol2 we are trying to use IDEBUG. Everything seemd to be fine until we come to a COBOL ACCEPT statement, getting parameters piped in from a text file. The program seems to hang almost indefinately. Has anyone come across a similar problem? tnaks brian

I have several objects which are the components of an address (e.g. ADDR1, ADDR2, ADDR3, POSTCODE). The address table includes a record type: 1=CURRENT 2=TEMPORARY. I now wish to design objects which will give me fields from the temporary address, but if there is no temporary address to...

(BO v5.1.7) This works fine: select f1,@prompt('MonthEnd ','D',,,) from T1 This fails: select f1,@prompt('MonthEnd ','D',,,) - 1 months from T1 from cbsinfo Does this mean that it is impossible to manipulate prompts in freehand SQL, or is there some special syntax required? Thanks for...

Hi, DB2 v8 on AIX Has anyone had success with Compressed Backups? Our normal full backup takes an hour. The compressed backup took 5 hours, and a subsequent incremental backup took 50 minutes. Please point me in the direction to look for the reasons, because surely 5 hours is more than just...

I have a recurring need to drive ad-hoc one-off enquiries with a list of customer identification codes. There are too many customer numbers to put them in a 'where' clause, so I need to put them into a temporary table and use this as a joined table or a sub-query e.g. select...

Does anyone know of any documentation which explains the functional differences and the licensing issues between these products? We currently use Full Client (5.1.7) and now need to open up queries (or query results) to the outside world. Business Objects has changed over the past few years...

Although the Cobol documentation describes the 8 UPSI switches, defined in Special Names, I can find no way of using them in the AIX documentation. On other platforms I have been able to run a cobol program and communicate with the program by setting one of the switches. For example a...

Has anyone successfully used BO 5.1.7 with DB2 V8.2 (actually V8.1 patche level 7). I am having trouble with repository connections and universe domain validity when setting up a test area.

I have been using Cobol for nearly over 35 years, and I am still amazed at the short-sightedness of the language developers. (My biggest gripe has always been the handling of dates - by now there should be a field type for dates, and data arithmetic). My current problem is the creation of a...

I have a query which normally runs OK against a v8.1 UDB database, but gives wrong results when I run it against a federated database, though it points to the same physical tables. The problem is almost certainly due to a CASE statement which contains a sub-query: select col_a, case...

We are using BO full client (Supervisor / Designer / Reporter)on Windows 2000. Our infra-structure people want to move towards Windows XP Pro. What is the latest position with BO on XP, most messages I can find are too old, too Webi or too specific? Any help could earn a Star. Brian

The customers pay weekly, usually by small amounts. I am trying to get details of how much each customer has paid up to the end of each month, effectively a running sum reset at change of customer, with a row being output for each customer/month. The obvious answer is OLAP, but I can find no...