• DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

    Mark is looking for an alternative to trimming blanks from the end of a record. He writes: "I would like to use the CPYTOIMPF command only if I can Trim Blanks from end of Record. I found out how to do this in FTP, but would really like to stay on this path and avoid FTP using Override Inputs. I...

    MichelleDavidson435 pointsBadges:
  • CPYTOPCD filename length limitation

    Hi all, Am aware of the limitation of the filename (filename.ext) for CPYTOPCD command. eg: 12345678.123 (8chars and ext 3chars). Is there any command that I could use to have my filename as follows: AA12345678.txt or AA12345678 ? Or maybe additional step that I could insert into my CL after the...

    JechLee5 pointsBadges:
  • Entering more than 45 data Selection Values in Data Selection for Version in Version List in DreamWriter

    How do I enter more than 45 values for a field (this appears to be an upper limit - with only 45 fields (15 lines of 3 fields per line) available on the display) within Data Selection Values for a Version on Version List in DreamWriter in JDE. Thank you to anyone for helping with this. 

    TonyC15 pointsBadges:
  • Data Guard implementation for Oracle 10gR2

    I am making a standby database for dataguard on 10.2.0(windows 2003 VmWare) following this tutorial. I am confused about the standby database creation. I successfully configured the PD with these steps, but I simply ran the oradim command for the standby databae creation then mounted the database...

    ITKE357,085 pointsBadges:
  • Flash Recovery Area in Oracle 11g

    What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...

    ITKE357,085 pointsBadges:
  • Oracle acquires SUN: implications ?

    What do you think will be the implications of Oracle's Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?

    carlosdl71,130 pointsBadges:
  • About Time

    Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet  

    Checkp310 pointsBadges:
  • Send alert via email/SMS with Oracle 9i & Oracle Forms 6i

    Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly guide me...

    Binu405 pointsBadges:
  • Forms and Reports Beginners level Coding Sites

    I studied oracle forms and reports books i am developing the form through wizard only not by code but i need better site which is beginners level practise forms and reports coding i always my wishes to anyone who are helping me   Thanking You        

    Rajkumarsva25 pointsBadges:
  • MERGE using DECODE logic to control UPDATE

    MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...

    ITKE357,085 pointsBadges:
  • get a anr record from databse by using max (one Field) and orderby (one filed) desc

    Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

  • Bulk update for every 10k rown among 2L

    Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

    Praveenkc5 pointsBadges:
  • Using Multiple Oracle Homes patchset application

    Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2, patch...

    Ecv3045 pointsBadges:
  • Deploying Oracle Database

    I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I'm waiting for your help. Thanks a lot

    Girma30 pointsBadges:
  • Does Oracle 6i have a metadata repository tool set

    Does Oracle 6i have a metadata repository tool set

    Maharrison4525 pointsBadges:
  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy8,323 pointsBadges:
  • Create an Oracle database in a specified location

    how to create database at speciied location in oracle 10g

    Softie5 pointsBadges:
  • calling trigger in oracle db 10g

    hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

    Girma30 pointsBadges:
  • Most popular blog posts this week

    10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

    ITKE357,085 pointsBadges:
  • The most-watched IT questions this week: Oct. 13, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

    Michael Morisy8,323 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