• DB2 function

    Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,

    Meenac0 pointsBadges:
  • Disconnected from SQL Server

    I'm currently making an attendance system whereas all transactions (scan in and out) are stored on an SQL Server. My problem is, how can I keep all transactions going in case the server is down? Do I need to incorporate it in my VB code?

    Trojanz0 pointsBadges:
  • Help with building an archive

    Hi! I'm trying to build an archive of files (documents, media, etc.) and need some help with the table structure and to make the archive searchable. This is what I have: File FileID FileName FilePages FileDate FileAuthor FileDescription Classification ? essay, article, joke, quote, etc. Types...

    Gfrankel0 pointsBadges:
  • Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields

    I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each...

    Lstephan0 pointsBadges:
  • 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)

    after selecting all of my columns i joined the tables as follows FROM EMPL B, HB_EMPL_PKG_ELEC D, HB_EMPL_DEP_BNFIC A, HB_EMPL_MED_DEP C WHERE B.EMPL_ID = A.EMPL_ID(+) AND C.EMPL_ID = A.EMPL_ID AND C.BEN_PLAN_CD IN ('UHCALL','UHCBASIC') AND B.EMPL_ID = D.EMPL_ID(+) AND D.BEN_PLAN_CD...

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

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