Database Management Systems

Oracle Forms

Is there a way to use a Oracle Form to Upload a file to a specific folder and store the filename in the database? I know how to do this through HTML/ASP/VBS, but my company wants it through Oracle Forms. Also, how would I make a hidden field appear when a LOV Item is selected and when it appears...

IT Tech Assistant/No Admin Rights

I have hired a new IT support person, and I wanted to give him access to restart services ex: Print services, in my absense which occasionally needs resetting. Is their a way to give someone strict access to only restart services?

Oracle Forms Developer/Builder for Oracle 9

I have two questions. The first is, how would you go about changing the applet size when running a form? Or, is there a way? The other question is, how can you use Forms Builder to upload a file/document to the database? I need to load a filepath but I'm not quite sure how I need to get the file...

What are the requirements for oracle10g Real Application clusters using ASM?

Dear sir, what are the software reqiurements for configuring Oracle 10g real application clusters?

BOBJ Business Objects XI

We are considering implementing "BOBJ Business Objects XI" in our company. My question is can anyone offer a critique of the product. i.e. from a implementation & post imp point of view. Thanks in advance.

function to subtract 200 days from date

I need to write the filter condition in cognos as follows: YRMOSDOS between (&YRMOSDOS - 200) AND (&YRMOSDOS) where YRMOSDOS is in date form. How do I achieve it? The database is in db2. Decimal function does not work. Please help. Thanks a lot.

Number Crunching Machines

I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I'm not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc. What concerns me though is that I have worked on AS400's now for...

Changing the statement heap parameter on iSeries

Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

SQL Clustering

SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active...

help me!!

hi! i m a beginner in java programing ... i need to create a database using java .... the data are in the form of tables .... plzz guide me how to do it or where can i get the help???? how shud i get started ??

reusedlt *yes

Hi, Has reusedlt *yes behavior changed with V5R3? When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one. Anyone run into this before? Thanks, Luis

Spaces in Linux is getting Interpreted as '@'

Hi All Need some help. I use the BCP out command to transmit data from SQL Server database table and send it to flat files. The spaces (varchar datatype in table) gets transmitted as spaces only. When I use Linux command to get these files, out of 20,000 spaces , 1 space got interpreted as '@'. ...

Automatically Force User Disconnects via Scheduled Script

Greetings all ... What is the most efficient automated script-based approach to terminate user connections for "particular" databases? Where: 1. Know name of database(s) 2. Know name of user(s) 3. Do not know name of user(s) 4. Server must always remain in production and user(s) must not be...

Restoring a dtaq in iseries.

I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included. When i do that, the dtaq is empty. If someone knows how to do that, please tell me. Thanks.

Transfer Report from AS/400 to PC

Is there any utilities/tools that can help me to create a program on AS/400 (CL program) to transfer the reports that are created at a certain output queue on AS/400, transfer them automatically to a specific folder at PC side so as to be opened with any application at MS Windows, keeping the...

Oracle 9i Query Time

What would be an expected time to run a query that will extract 1.4 million records? There are two tables involved. Customer and Address. And No Condition.

Inserting data into a vargraphic data type field

How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES('TEST') This gives a SQL error Please let me know how I can acheive it.

Folders on AS/400

Whenever I try to access folders on the AS/400 using the WRKFLR command I get an MCH3601 error message. I need to be able to access the data in the folders to process the data in a PC application.

DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G

Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed on...

I am sending some zipped files to a server, using IBM FTP CS V1R4(exec pgm=ftp). Is it possible to FTP a file in PDF format or some other more printable format than text?

I am sending some zipped files to a server, using IBM FTP CS V1R4(exec pgm=ftp). I am executing cobol and ftp programs...Is there any possibility of returning the reports as PDF files (or some other more printable format than text). I mean when a user opens a zipped file they want to see PDF file,...