• Trouble with package execution after Oracle upgrade

    Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under...

    Phantomf80 pointsBadges:
  • QSAM Buffer

    We are writing to a QSAM output file which we will require in case of an abend. The problem we are faced with is - what happens if the job abends prior to all the records in the QSAM buffer being physically written to the QSAM output file. Are there any JCL statements that can force the QSAM buffer...

    Handerso0 pointsBadges:
  • Error in Select Statement

    I have connected VB to ORACLE by ADODB connection. When I am trying to access data from different schema it?s showing an error message ?[Oracle] [ODBC] [Ora] ORA-01013: User requested cancel of current operation? If I am querying by specifying the data in the field it?s not...

    AnandMah0 pointsBadges:
  • inserts through a database link

    Hello every body. Here I go again... Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to...

    carlosdl69,175 pointsBadges:
  • Capture User Name and Date

    How do I capture the user name and date of when a specific field was last edited on my form? I know how to capture when the entire form is edited and saved.

    Mike27t0 pointsBadges:
  • Difference between length and vsize functions

    Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Oracle 9i Server and XP Pro

    I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000)using Client 7i or Client 9i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i Server...

    Baumic20 pointsBadges:
  • Start-up Needed for DB design for workflow for BPO company

    Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

    Malaikanirr0 pointsBadges:
  • Capture screen w/scrolling marquee

    My company uses a 3rd party software. There's one screen that has a few graphs and a few lines that scroll across the screen. Similiar to a Screen Saver's Scrolling Marquee. They redesigned the software and this screen will no longer exist. I would like to capture this screen w/scrolling marquee....

    Drew65220 pointsBadges:
  • SQL server replication

    We have diiference in two databases which are being replicated. What may cause the difference and how to find the differences. SQL sever 2003 is tha databse. Thanks

    Anjuajay0 pointsBadges:
  • Doubts regarding speed in data access

    y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server which will read a text...

    Cmyahya0 pointsBadges:
  • Updating Access Database Structure At Run-Time

    I have an app that uses an access database for its back end. When a program update is issued someone has to manualy add the new fields, queries etc to the clients db file. Is there a way i can mimic the development database schema and update the database from the file upon installation of the...

    Middert0 pointsBadges:
  • Numeric values search from alphanumeric column of DB2

    In DB2 I have the requirement of sorting only numeric values from varchar data type column by using some range criteria. The database table contains numeric as well as alphanumeric values. For ex. `1?, `2?, `6?, `13?, `34? ,?ABC123?, `POE?, `12IUY?, `FG23RF? etc. Using range search of 1 to 20,...

    J2EEJava0 pointsBadges:
  • Zebra printer will not print CORRECTLY through Oracle application(s)

    Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held "pistol" scanner failed. Connected to a laboratory balance via Omnilink...

    Poppaman20 pointsBadges:
  • Batch FTP Question – Server to Mainframe

    I recently tested a batch FTP which gets a file from a Unix server and downloads to a flat file on an IBM mainframe. When I run this on our test box, it creates a fixed block flat file of 128 bytes. When I run the exact same batch FTP on our production box, exact same server, it creates a variable...

    DavidM920 pointsBadges:
  • IMS conversational transactions

    I am looking into IBM's IMS SOAP Gateway to expose our IMS transactions as Web Services. 98% of our IMS transactions are conversational. I am looking for possible ways of exposing them as SOAP/Web services without acquiring WebSphere or IMS Connect for Java on the Mainframe

    HariThan0 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • Database Implementation

    What is the best practice for implementation of a new Database software package (I.E. creating teams, or work with a Committee) My boss would like me to learn everyones job, is this really necessary to implement a new Database package...

    Redstang900 pointsBadges:
  • Oracle Sql Tuning

    Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let's say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write 'where' clauses putting first the join conditions and after them, the table specific...

    carlosdl69,175 pointsBadges:
  • Oracle boolean data type questions

    Greetings, Since Oracle Table structures do not support a boolean data type, there is a choice (Make it a varchar2(1) or Number(1)), with contents of 0,1 or Y,N The questions I have are: 1) From a comparison perspective, which provides better performance? Comparison of a number (1,0) or string...

    SrDataArch0 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