• Dynamic Column name in a Cursor

    My table has columns named as C1,C2,C3 so on. Each department in the has values only for a specific number of columns. That is, not all columns are used by all departments. In the code below the second cursor gets all the columns associated with a department. Since the nu,ber of column is unknown I...

    Kmarur0 pointsBadges:
  • re-writing a stored procedure as a coldfusion document.

    Hi, I was wondering if someone can help me please - i have the task of re-writing out database stored procedures as coldfusion cfc's. THing is i haven't really got much experience with coldfusion and was hoping that some kind person can help me out. I have enclosed one of our stored procedures....

    Andy119830 pointsBadges:
  • Sub-pgm is to calculate X to the power of Y and then return Z. (using RPGIV / RPGILE)

    Hello Because I am new to RPGIV (existing using RPGIII) . Recently I need to write a sub-program using RPGIV (or RPGILE ? ). This sub-program will receive two parmerter (X , Y) and output one parmeter (Z) (which are in numeric format - BTW what is the max precision for numeric format in RPGIV /...

    Vlui000 pointsBadges:
  • Problem selecting unique MAX

    We have a stored procedure that 'selects max(nvl(fieldM,0),value)+1 from table where fieldA=123 and fieldB = 456;'. This value is then inserted back into the table into FieldM as a record fieldA=123, fieldb=456, fieldM=Maxvalue, and another IDfield. After about a couple 100 of these it is over, and...

    Paralogist0 pointsBadges:
  • Sql in RPGLE

    Does anyone know how to use variable field in ORDER BY field in embedded sql in RPGLE to sort by specific order ? I don't want to hard code a field name.

    Msabsh0 pointsBadges:
  • sqlserver 2000 stored procedures

    Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

    Andy119830 pointsBadges:
  • AS/400 SQL V5R2 — updating new fields in a file with values from a different file

    I added 2 fields to FileA (FldX and FldY) FileA has the key to FileB (KeyB) where these values exist. FileA: FldA, FldB, KeyB, new... FldX, FldY FileB: BKeyB, BFldX, BFldY This is probably simple for someone that composes SQL all the time but I'm having trouble coming up with acceptable syntax......

    AskDave0 pointsBadges:
  • Master-Detail query return on one row

    I have a parent-child relationship. I would like to have a query return the results where all children are on the same row as their parent. No children will have more than one parent. For instance: Table PARENT contains one column with the data: Parent1 Parent2 Parent3 Table CHILD contains two...

    Acopelan0 pointsBadges:
  • Urgent!Please help: TOP 3 cities only returned based on count() – result

    I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table:...

    Ronjar0 pointsBadges:
  • Help with VBA Code for retrieving data from a table in an MS Access Database

    Hi, I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected...

    Suprababe0 pointsBadges:
  • SQL Trigger to create .csv file

    I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every couple of minutes all throughout...

    Zannemarie0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • Listing USER tables in DB2

    I am using QMF for DB2 and would like to know all the tables I have access to. What is the code I dould use to list all of the tables I have access to. THanks.

    Pitpug0 pointsBadges:
  • Slow PL/SQL query

    I'm running the following query against two tables residing on an Oracle 8 database. The query takes too long (over an hour) to run. Both tables are indexed - however the main table SALES.SO is HUGE. Does anyone have any suggestions as to how I could improve this query so it can execute faster....

    Appioriley0 pointsBadges:
  • Returning Multiple result sets to Excel

    I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don't ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet... Any Ideas?

    UselessOne0 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Upgrading to 10g(10.1) from 8.0.6; Oracle Forms 5.0.6.8.0 and Oracle Reports 3.0.5.8.0 and Pro*C/COBOL for v8.0.4.4

    Hi, We are researching upgrading to 10g(10.1) for database and Developer tools. The database is currently 8.0.6 and we use Oracle Forms 5.0.6.8.0; Oracle Reports 3.0.5.8.0; and precompile Pro*C/COBOL programs with the 8.0.4.4 environment. There appears to be quite a bit of information on the...

    Mbbuffett0 pointsBadges:
  • T-SQL, and cascading updates or finding constraint names

    Hi all, I have been tasked with a difficult project. My employer has a rather large database, hosted on SQL Server 2000, which is used by several thousand users across our organization, and grouped by business units. This database is evolving with each minor release, which is just about every...

    Sonotsky695 pointsBadges:
  • Session ID of User

    I want to write a select statement in a database table trigger to see who is deleting a record (User, PC name, program). V$session provides the info but I do not know how to identify the session that is deleting. Please help. Oracle 8.0.5 on NT Server

    CharlW0 pointsBadges:
  • Microsoft Access. Passing an ID/value to a subform. or between forms

    Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

    Gryphon0 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