• SQL FLAT FILE REPORT LOOPING

    I created the following report, it grabs the employee information then its medical coverage and its dependents with their information and coverage. currently the report when spooled loops. and only shows employee info and not dependents. also mny decode is not working. please help. ie. below....

    Alex88090 pointsBadges:
  • calculation at database level

    Hi! I will really appreciate help. 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...

    Meenac0 pointsBadges:
  • Create table and insert

    I have encountered a very strange situation. I have a procedure that checks if a table name exists, if it does, it drops and re-create the table, else just create it. Following is the code : SELECT COUNT(*) INTO V_TABLE_EXIST FROM USER_TABLES WHERE TABLE_NAME = 'X'; IF (V_TABLE_EXIST = 1) THEN...

    7308270 pointsBadges:
  • SQL Clustering

    SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode,...

    Krismop0 pointsBadges:
  • Please help

    Yet another question, and an example of my code. i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns. i need to connect to another 2set of tables to add further information to my first...

    Alex88090 pointsBadges:
  • Problems in DDL trigger usage

    Problems in DDL trigger usage. I have a problem in the usage of DDL trigger. I created a DDL trigger on a user schema on "AFTER CREATE" event to catch the creation script of the all database objects using the system variables ora_sysevent, ora_dict_obj_name, ora_dict_obj_type,ora_dict_obj_owner....

    Asrcmurthy0 pointsBadges:
  • Oracle query to count rows in tables

    Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike

    Mikron20 pointsBadges:
  • MSACCES to AS400

    I am currently working on a project where I need to take files from a MsACCESS and transfer them to the Iseries possibly replacing them on a daily basis. I have been able to export them to the ISERIES manually, via the export on the file menu. I have not been able to find an export sample with a...

    AS400programmer0 pointsBadges:
  • UNIQUE vs DISTINCT, what’s the difference?

    What is the difference between UNIQUE vs DISTINCT when used in a select statement? The result sets would seem to be the same, but is there a performance gain by using one over the other? If it matters, we're on Oracle 9i

    smford20 pointsBadges:
  • SQL Left Join unmatched null handling.

    I am using SQL Left Join. My null values in unmatched returns are producing the following message when I Fetch them into my host variables: (SQL0305)"A FETCH, an embedded SELECT, a CALL or a SET or VALUES INTO statement has resulted in a null value, but an indicator variable was not specified for...

    Stoogenut10 pointsBadges:
  • Recordsets resetting to NULL in Visual Basic 6.0

    Hello, I am experiencing problems with recordsets in VB, where they are losing there values, i ran through the program in break mode, if i hover my mouse over, for instance GRS!name or whatever, it pop up the correct value, but then if i move the mouse away and then return it, to refresh the pop...

    PhiliB0 pointsBadges:
  • SQL LEFT OUTER JOIN – Null handling: Indicator Variables

    I am using SQL Left Outer Join in an SQLRPGLEI Declare Cursor statement. I need indicator variables of SMALLINT type to handle my null returns in FETCH statements. How and where do these have to be defined? There are no SMALLINT fields in the tables I am joining. Thank you in advance for your...

    Stoogenut10 pointsBadges:
  • Counting Problem – SQL Server 2000

    Counting Records - SQL Server 2000 I need to count rooms sold. The problem is that a room can be sold more than once for any given trip. How can I retrieve all records including one instance where the room has been sold multiple times on a given trip? Example: Inv. Trip Room 1 A50805 201 2 A50805...

    Mpatdweb0 pointsBadges:
  • 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:

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