Search results for query: *

We run 4 different production instances of Ellipse here (5.2.1.6) We're having a problem with BEC job numbering in 2 of the 4 with users with very similar usernames. In one instance, whenever user WARNEM runs a job we see this: This is from programs_12666.log...

I have a user account that I want to only connect from a certain application and I want to reject logins from SQL*Plus. Is there a way to create a logon trigger to check the name of the account and the method of connection (sqlplus from Unix or SQLPLUS.EXE from Windows) and if that's true, boot...

I have inherited a java program that extracts data out of an Oracle 9i database and writes a flat file with some data. I need to make a slight modification to the name of the view that it extracts data from so we can perform some testing. Unfortunately, I know jack about Java. I'm thinking...

I have inherited a java program that extracts data out of an Oracle 9i database and writes a flat file with some data. I need to make a slight modification to the name of the view that it extracts data from so we can perform some testing. Unfortunately, I know jack about Java. I'm thinking...

I have a database in Paradox that I'd really like to convert to MySQL. I'm wondering if anyone has done it before and if there's some nifty tools that might be available. For starters, I'd like to be able to examine the table structure and create a "CREATE TABLE" and "CREATE INDEX" statements...

We are in the process at the moment of doing a very large segregation of duties among all stuff in our IT department. As a part of this, our auditors want to restrict the DBA’s access to production databases. For example (quoted from our Sarbanes Oxley Compliance Officer)...

One of the members of the application development group here currently has a job that runs periodically where the first step is to run a remsh command to invoke a script on a remote server that queries a database, writes a file and FTP's it back to the invoking server. Recently, after an audit...

I have a field in a Paradox table that is stored as an Alphanumeric. It was done this way so that values without a sign, and with signs, both "-" and "+" could be displayed without special code. Values could be: 1, 5, -2, +3 etc. Now, it's coming to bite me in the behind. I have a user of...

We are running TX-Series CICS 5.0.0.4 on HP-UX 11.11. We have about 15 CICS instances running on this server at any one time. From time to time, it appears as if one of the regions stops accepting communication from the telnet connection, even though looking at the console log and the server...

Been bringing up a new system, under CICS 5.0, on HPUX 11.11, Oracle 9.2.0.5 for Ellipse 5.2.1.4. The users are reporting that they walk away from the keyboard for 30 minutes and come back and hit enter and they get a message about the session being disconnected. I know I've seen this before...

I have a task I need to do that requires me to create several objects in a database after I do a copy of production to test or training. Basically I drop some prod objects and recreate them for test. I'd like to know how to code the following in PL/SQL, since I've never had to use PL/SQL...

I've just inherited a 7.1.6 database from another business unit whose operations we will be taking over shortly. One of their databases is 7.1.6 on HPUX 10.01. I brought it over to my 10.20 box, installed 7.1.6 (that was a find, let me tell you) and started it up. 7.1.6 came up ok. Next I...

I have a database that has a text field that holds (for the most part) a numeric value. I need to make this number be 10% of it's size. The basic SQL is easy: update table set val = val/10 where tag like 'StatusField%' But, since val is of datatype text, the statement is going to fail. I's...

We have recently converted our databases from a combination on LMT auto extent allocation and DMT to all being LMT with Uniform Extent Allocation. One of the things I need to do now, is to set up a monitor that will inform me that I have an object that can't grow to its next extent. In Oracle...

We run a COBOL Based application on one of our servers that uses IBM TX-Series (CICS) version 4.2 in combination with Microfocus Cobol 4.1.40 & Oracle 8.1.7 on HPUX 11.00. I'm getting an error when trying to run the application and on a longshot, I thought I'd post here and see if anyone is...

We run a COBOL Based application on one of our servers that uses IBM TX-Series (CICS) version 4.2 in combination with Microfocus Cobol 4.1.40 & Oracle 8.1.7 on HPUX 11.00. I'm getting an error when trying to run the application and on a longshot, I thought I'd post here and see if anyone is...

Been trying to setup a CICS instance for one of our systems (HPUX 11.0, Oracle 8.1.7, MF Cobol 4.1.40, CICS 4.2). Everything seems to run OK, until I type "MIMS" in the CICS telnet session. I get the following in the console log: /usr/lib/dld.sl: Unresolved symbol...

Hello, I've got a materialized view that's suddenly causing me grief with an ORA-01775 on the refresh. The entry in USER_JOBS looks like this: SQL> l 1* select * from user_jobs where job = 5596 SQL> / JOB LOG_USER PRIV_USER ----------...

Are there any good tips for debugging an Access Violation? I have a form with a DBGrid on it. Users can click a button, be taken to a filters form, define filters and click OK. It then presents data according to the filter specification in the grid. This part generates dynamic SQL for...

One of the Windows Admins has come and asked me for how much memory a windows server would need running Windows 2003 Advanced Server and Oracle 9i. I haven't been able to find much to help him and I'm a Unix guy to boot :) There will be ad hoc queries running against this sucker all day (It's...