• Partitioning a large financial table

    i hv a large table (GL details that is abt 30-50mb) that contains financial data. i want to partition it by these fields 1) company code 2) Quarter (based on the financial periods) 3) Year Eg, data Select GLCO, GLYEAR, (TO_CHAR(GLYEAR) ||'/'||TO_CHAR(GLMNTH)) As Yrmth, GLMNTH, GLAMT FROM GLPGL;...

    Mayleong0 pointsBadges:
  • Oracle Developer 6i and 9i database connection problems

    I cannot connect to a 9i database patched to 9.2.0.6 (I can if the server is patched to 9.2.0.5) from a 6i Developer client on XP. Tnsping80 is OK but not SQL. I get kicked out of SQL and the error report references ora805.dll. When I install the 9i client I can connect with it but still cannot...

    6to4to30 pointsBadges:
  • read only user

    I've got an Oracle 9.2.0.5 database and I need to create a read only user that can view any table, view, package, etc. I've created the user but I can't figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I...

    Skovac0 pointsBadges:
  • Educating database users

    Database administrators must always be prepared to handle users' database problems and concerns -- even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don't understand the work involved...

    RobynLorusso230 pointsBadges:
  • problem related paper size (Crystal Report 9)

    My project (in VB & Crystal Report 9) needs different shaped bills (10?X12?, 6?X12?, 15?X12?) to print through DMP. But I am facing problem to control paper size through code.

    Sahanil0 pointsBadges:
  • VS COBOL-II (FILES)

    HI, Suppose i have a sequential file containing 1 lakh records. i want that after retreiving every 5000 records a message to be displayed that file is being processed. thank you.

    Programming440 pointsBadges:
  • Old Approach App in XP

    Hello, Have an older Lotus Approach '97 DB App here that I have been asked to see what it would take to get back working in our XP enviroment. This is about 10 Approach Databases in an relational type of setup with about 2000 records and 150 or so custom layouts. Have messed with it a bit and for...

    R8escjohn0 pointsBadges:
  • Print Numbers in words

    By using a single SQL Query Is it possible to print numbers in words. Example : To print "5,550 Dollars" in words Expected Query result : "Five Thousand Five Hundred and Fifty Dollars Only" Is it Posssible by a single query

    Sanmails0 pointsBadges:
  • ORA-01000 error even if all statements and resultsets are closed in finally

    I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to...

    DeveloperJava0 pointsBadges:
  • 64 bit Oracle

    Hi, I'd like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM's Power servers are tempting, even with the added expense of...

    Gabopagan0 pointsBadges:
  • Working Storage – Reusability

    Hello, here is the question... I want to create a sub-module (cobol DB2) that will be called at initialization time by the load driver (either TP ou Batch). That sub-module will load technical information in its working-storage after accessing DB2 tables. That module will be called dynamically...

    ReneRFID0 pointsBadges:
  • Oracle HA Database Architecture on Linux

    Are there any high availability database architectural issues/options to be conscious of on Linux?

    Whit1000 pointsBadges:
  • Question about a frequently changing column as primary key

    Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance...

    Paulachen0 pointsBadges:
  • Outlook – creating Contact Lists under one main List

    I'm using MS Outlook 2000 SP3 (9.0.0.6627). My company has about 1,000 customers/offices that we support. I'm working on a project and need to keep track of my contacts at each office. I first need to put all of the offices I contact into one large group. Each office is different. Some have one...

    Drew65220 pointsBadges:
  • Procedure Error

    Hi Friends, would appreciate if someone could let me know the error in the Stored Procedure. It doesn't compile successfully right now and feel there is a mismatch between the 'Begin' and 'End' keywords. Pl. confirm. Thank You, Friend33 Create or replace procedure proc_name IS Pwd varchar2(8); user...

    Friend120 pointsBadges:
  • Remore RS232 Control

    Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a PC in another room or...

    Jondean0 pointsBadges:
  • Procedure Compilation

    Hi Friends, Have a small glitch and hence hope you will spare me a moment. Have a small procedure and it is not compiling. Could you just have a look and let me know why ? Thank You, :) Friend33 PROCEDURE Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email...

    Friend120 pointsBadges:
  • C program call to COBOL / DB2

    Can a C program in a mainframe environment call a COBOL program or a DB2 stored procedure. If so is any sample code available.

    Kps2300 pointsBadges:
  • iSeries any beyond

    I'll start by introducing myself and my background and then hopefully explain what information i'm looking for. I'm a COBOL developer for an insurance company based here in Ireland. I'd like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have...

    ITnavan0 pointsBadges:
  • How to solve lock problem in Oracle 9i on Linux

    Hi DBAs I have foundPersistent Lock in my database Suggest me how to solve this error.

    Murtujakhokhar0 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