• SQL EXCEPTION JOIN

    I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many...

    DanTheDane2,555 pointsBadges:
  • Whats the Difference Between UNION and OR clause in Oracle SQL

    I have query like Select empno,sal from employee where deptno = 10 or dept = 20 and i can also write this query in this ways also Select empno,sal from employee where deptno = 10 UNION Select empno,sal from employee where deptno = 20 Now i wanna to know which is better way between these two and...

    Goelneeraj0 pointsBadges:
  • SQL record with latest date

    if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

    Techybrains5 pointsBadges:
  • SQL Fetch

    I an joing tow files with inner join. I want all the fields from the first file and only two fields from the other file. I defined an external DS for the first file then included that DS in another DS with the two fields from the other file but program will no compile. Will not read the last DS in...

    Doctor-job20 pointsBadges:
  • Seeking Help with SQL SUBSTR Function using Host Variables in COBOL

    Hello All I am currently on version V5R2 and I am trying to make a COBOL program produce some parsed fields from one large field. I have trying to use host variables for al three arguments in the SUBSTR function. The SQL compiler will take a host variable as argument number one but not for argument...

    FCARPENTER200 pointsBadges:
  • rpg sql

    I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up...

    mcg15 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 pointsBadges:
  • SQL Join on multiple columns?

    Can I join from one file to another on more than one column? For example, join from FileA to FileB on OrderNumber.A=OrderNumber.B AND ItemNumber.A=ItemNumber.B? All examples show only one column... I am on an AS400 using RPGLESQL, I need to join from one detail file to another detail file.

    Wlakesearcher100 pointsBadges:
  • How do I find the timestamp associated with HWM of processes/sessions in Oracle 10g on AIX

    The following SQL produces a very useful report of current resource utilization at the time of the query and the HWM since the database was started. What SQL can I add to list the time of the HWM? Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit. Thanks, Bruce col...

    Csybjf15 pointsBadges:
  • AS/400 and Oracle Access Manager

    I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT .... into ..... FROM Table1 WHERE ..... return OK : 1 row as expected with my two fields filled. b....

    Technet30 pointsBadges:
  • SQL Command

    Hi friends (again), It's possible to prohibit a update option on a SQL Command to a guest user ?

    SILVARB440 pointsBadges:
  • DOT NET SQL CONNECTION TIME OUT PROBLEM

    IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

    KonguKarna5 pointsBadges:
  • Error when executing RUNSQLSTM from CL program

    I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed" Not really trying anything fancy. In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I have SELECT mstid, SUBSTR(ftxref,1,1) AS ftxref_1, SUBSTR(HEX(SUBSTR(ftxref,2,7)),1,9) AS...

    Tcwalls5 pointsBadges:
  • Need a sample code for Sql fetching multiple rows

    In Native cobol we use read PF file in a loop until EOF to fetch all records.Now i need to do the same by using Sql in cobol,eg: select * from File and show it in subfile.Can anyone help me how to do this. How to move recods from curson to screen.Thankx in advance for ur help.   supriyo B

    Supriyoas400165 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • SQL to edit last character in a field using STRSQL

    I can select the rows using this SQL how can I update? UPDATE mbmtest01/itemaster SET right (ITNBR,1) = ' ' WHERE right(ITNBR,1) = 'M'

    nitzinger385 pointsBadges:
  • Creating a stored procedure in SQL

    I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • qmqry error – Help!

    Can anyone help? I have a clp application that calls a qmqry which reads a large sales transaction file and selects and creats a small summary file of certain transactions for a certain typpe of part and date range. This sales transaction file is journaled and the file it creates becomes journaled?...

    Lnspgm15 pointsBadges:
  • SQL for Microsoft Access

    I have crated the below SQL statement. I works fine. and it gives me the required "RTCDate" I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the "1" is those product line numbers that are active...

    CompEng1,195 pointsBadges:
  • DR/HA questions with SQL Server design

    Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring on the...

    SQL Server Ask the Experts2,585 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