• exception join

    SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either invalid plan...

    Meenac0 pointsBadges:
  • Visual basic project , outer joins, flat files, sql commands

    I need to output a flat file in sql plus and visual basic , the information is coming from oracle, where the files looks as follow's; v.12 1800123456789 gibbons alex a test test the v.12 has to automatically come in while the rest of the information is coming from tables. but they must be specific...

    Alex88090 pointsBadges:
  • Sql ( I think i am almost there)


    Alex88090 pointsBadges:
  • sql

    how do i create a counter on the header level that will bring up a count of lines on flat file. Also how do i use a Pipe delimiter | to break a line.

    Alex88090 pointsBadges:
  • sql-2

    how do i remove punctuation and # characters from data being pulled from table into flat file. for example name contains DELL.JR i need this to just show as DELL JR

    Alex88090 pointsBadges:
  • Select Statement Question- Using Minus or Except

    A table has the following columns and values Plant, Empname, Post,Salary (Det,Jade,Manager,3000) (Tex,Jack,Manager,5000) (Mia,Marr,Analyst,2040) (Det,John,Sr Analyst,1500) (Tex,Jamie,Sr Analyst,5000) (Mia,Erin,Analyst,2040) (Det,Carl,Analyst,1500) I have to write a select statement which returns...

    Kmarur0 pointsBadges:

    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:

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.