• Restoring patch from 8.1.7.4 to 8.1.7.2. Verify steps

    Hi all, just need to verify if restore is required after a successful patch upgrade from 8172 to 8174, what are the steps? 1. restore the old oracle binaries 8.1.7.2 only. Will this work? Does the patch upgrade change header information, and oracle dictionary. If this is the case, then binary...

    Dannyl0 pointsBadges:
  • tuning

    I have a program which is run on an ad-hoc basis....the database is mainly a read only dB, i.e. not much inserts/updates/deletes. The process basically reads tables, then creates temporary oracle tables, creates indices on these tables and then does some inserts. The temporary oracle tables are...

    Fitzdp0 pointsBadges:
  • Creation of a new schema in Oracle

    My DBA insists that there isn't a role or privillige for create schema, from the research gathered so far there's clear indication that there should. What is the snytax for creating a new schema? The DBA isn't that he can only create a user not a schema

    Mnm1870 pointsBadges:
  • SqlDumpExceptionHandler Error Message In MS SQL Server 7.0

    I am trying to restore a database in MS SQL Server 7.0. I keep getting the following error message. Backup or restore operation terminating abnormally. SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. I...

    Bkr0963c0 pointsBadges:
  • Moving Log Files in Oracle 9.2.0

    Hi there i have 5 log groups in oracle 9.2.0. (running on win2k) my 3 log groups are all created under D: drive as i used oui to install my db. i had 16 hard disks,and the senior dba had asked me to move the 2 log groups to other hard disk. the configuration for my log groups (each w 3 mbrs) are as...

    Mayleong0 pointsBadges:
  • The UNIX Idiot

    Hi everybody i'll be attending the Oracle10g upgrade course @ Oracle Corporation next week. I need some help with UNIX commands that a DBA could use(i was trained in Win mode for Oracle). Just abt 5-10 will do, coz i just need to survive the 5-day course. The Senior DBA at my company suggest that i...

    Mayleong0 pointsBadges:
  • cics internet web interface question

    Good day, We are in the process of changing the CICS internet login protocol from basic to form based authentication. This requires placing a token inside the HTML referencing the item '&QUERY_STRING' as defined on page 80 of the CICS Internet Guide. Nothing is mentioned concerning the format of...

    Jeffer0 pointsBadges:
  • Querying GIS Data

    I have GIS dataset which i want to query for finding intersections. The data goes like this: ID Street1 Street2 Intersection 1 407 HWY 407 RAMP 407 HWY & 407 RAMP 2 407 HWY 410 HWY 407 HWY & 410 HWY 3 407 HWY 427 HWY 407 HWY & 427 HWY 5 407 RAMP 410 HWY 407 RAMP & 410 HWY 6 407 RAMP AIRPORT RD 407...

    RPandya0 pointsBadges:
  • CICS transaction paramter for lower case

    Can you please tell me what parameter to set in order to allow a CICS transaction the use of lower-case letters?

    MartyP0 pointsBadges:
  • Extracting SAP R3 data in custom DW

    We are in the process of building a custom data warehouse (SQL with Business Objects Universe for reporting) - this is continuing the existing company strategy. The difference this time is that we need to extract data from SAP R3 to feed into the warehouse. What I'm not sure about is the best...

    Jroth730 pointsBadges:
  • ASE Trigger

    select @command = 'INSERT INTO tablename SELECT * FROM inserted' execute(@command) Hi all, i am building a dynamic SQL Command inside a trigger, i received an error message that table inserted is not found. (i am using ASE 12.5.1) thanks,

    Ghassanhaith0 pointsBadges:
  • Unable to create new records in other database using local form (writing background agent)

    Hi, I am trying to create an agent in a database that creates a new document in the local address book using its local form (Person). Debug shows that all is fine except that it does not save (the flag value is -1). What am I missing? Here is my code: Sub Initialize Dim s As NotesSession Dim...

    Arnaud660 pointsBadges:
  • Should you ever consider creating a fresh database for a user’s e-mail?

    On our Domino server, there is one mailbox that keeps generating errors. It is flagged in STATREP.nsf daily because documents can't be created or mail rules are problematic. I am unable to view the Rules in the database, and in Domino Administrator, it's the only mail file that doesn't show a...

    DKoch675 pointsBadges:
  • Secure File Transfer for Mainframe systems

    I would like to transfer files from Unix machine to Mainframe system (using Unix machine as client). The transfer process need to be secure (ie. data sent thro network should be encrypted using 128-bit encryption algorithm). I came to understand that SFTP server is not available for Mainframe...

    Tsdnesh0 pointsBadges:
  • small doubt

    Hi, I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions: - in the RJNE0200 format, there are...

    Pprasad1230 pointsBadges:
  • Help needed with sending a mainframe file to users in CSV format

    Hi, My program is creating a delimited flat file on the mainframe. I want to send this file to various users using either IEBGENER or IBMFTP as a CSV file. My problem is that although the file is sent successfully as a .CSV file but when the user opens the CSV file he finds that for some of the...

    DonQuixote0 pointsBadges:
  • 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.

    Meenac0 pointsBadges:
  • 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...

    Neilm1m0 pointsBadges:
  • Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields

    I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each...

    Lstephan0 pointsBadges:
  • Calculation at database level

    Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the case with...

    Meenac0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following