• Is RPG quicker than SQL to update ALL records

    We update a few fields in every record on a file with over 13 million records. Masking a copy of production data on a performance test environment. It is run on a two processor 595 box under OS7.1. The job runs for about 36 hours. If I wrote an RPG program, I would open the file non-keyed to...

    ShadowProgrammer15 pointsBadges:
  • Oracle SQL in TOAD

    Run a query that returns the number of trouble tickets in the VTM024… table, but only the ones created in the year 2015. Note: when setting the where criteria, use a function to extract the Year portion from the timestamp field. Using the Year function in the first answer, write SQL that shows...

    faizanahmad2320 pointsBadges:
  • Send email through procedure in PL/SQL

    Dear Team, I want to make a procedure through which I can send email to my team mail id. Actually there are number of procedures running daily in our system. So I want to send the status of each procedure means if procedure is getting success,failed or running. If the procedure is in running state...

    Biswa9215 pointsBadges:
  • SQL Join keeps failing

    Hello everyone, This question comes from one of our power users: ToddN2000. I'm trying to join 2 tables and it keeps failing. I did not create the tables and I cannot change them. One has the order defined as NUMERIC(8) the other has the order defined VARCHAR(15). I have tried using CAST, CONVERT,...

    Michael Tidmarsh56,540 pointsBadges:
  • sap training

    where is a good place to start to take sap training?

    Tsscare5 pointsBadges:
  • DB2i SQL select max(field) not using keyed access path

    I have a file that contains a timestamp field. This field is also the key field for the file. I am running a select statement in a UDF for the max value of that field, but according to the Query Access Plan: arrival sequence access was used for the file because the left-most key of the access path...

    BigKat8,925 pointsBadges:
  • How to recover deleted tables from SQL Server

    I have created tables in sql server 2005 but some how all the tables get deleted so can anyone tell me a way by which i can recover my deleted tables.

    Christinamarley5 pointsBadges:
  • SQL: Using Instead Of Update to allow updates by certain users

    I want to use an Instead Of Update to limit updates by Admins only. I have the code for the case when it is not an Admin doing the update but if the user is an Admin do I have to manually code the update for the table for every field from the inserted table?

    kul2bme5 pointsBadges:
  • Visual FoxPro Remote view

    Currently I'm doing SQL migration through remote view to my new product. In this, how to handle the following case. Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes...

    actramesh0015 pointsBadges:
  • How to fetch not null columns in Oracle

    Hi team, I have 90 fields in a table. Only 6-7 fields contain records out of 90. But I have only select not null fields in SQL without contain column name. How do I create SQL? Please advise. Thanks in advance!

    rahulrasal5 pointsBadges:
  • SQL query: Pull data in null column

    I have a table with 4 columns. Two have data in it with margin record and not mar. The other two col is null. I need to put data in null column that mar. RecA RealRecord RecB misRecors 2345 2345 2456 2346 3456 3456 4567 4568

    GK201315 pointsBadges:
  • Selecting records for the final date and the date immediately preceding it with a condition

    Hi, For the following records, there is the tracking for a particular R_ID and F_ID. Col_C = '10' means the final entry in the cycle. ENTRY = '1' means new entry and ENTRY = '2' means modifying existing entry on the same date. ENTRY = '2' means it is the most recent entry F_ID R_ID DATE ENTRY Col_A...

    Jai42725 pointsBadges:
  • SQL/400: Access to only SELECT statement

    I need to provide access to only SQL Select command in iSeries to user, is there a way to do it? User should be able to take F4 in the interactive SQL session. More specifically I will be providing a menu option to user like SQL SELECT, once user select it he should be directed to SQL interactive...

  • Crystal Reports record selection

    I have a SQL view that links my contact table to my address table. In the view there is a field signifying "address_type". It could be mailing, location, business, home etc. When I run the query I get three records for this contact because they have mailing, location and business addresses. Is...

    DQuint5 pointsBadges:
  • RPG SQL embedded

    Hi guys, I have this problem, look at this RPG code: dcl-s hostvar packed(8 : 0); dcl-s outvar zoned(8 : 0); ... EXEC SQL SELECT FIELDA INTO :HostVar FROM LIB1/FILE1 ; outvar = hostvar; EXEC SQL INSERT into LIB2/FILE2 (FIELDB) VALUES (HostVar); I get into Hostvar FIELDA that is packed(8 : 0)...

    Damiano25 pointsBadges:
  • Not clear on SQL

    I'm not clear for SQL. Can someone help?

    fikefish5 pointsBadges:
  • Not able to run update statement to update Arabic name of customer in Oracle database

    My Oracle database is Arabic enabled. If I use application UI to change name to Arabic I can store it in DB and read it. When I run a update statement like update name1 = 'للسيدات فرع م' where account_number = '0000011234' . This statement is not updating required arabic details, it is...

    asimmund5 pointsBadges:
  • SQL: Find the column name

    I don't know the column name and table name. What I know is there is a column in database that stores weights of products.

    syslkiranmai5 pointsBadges:
  • Create profile update code

    If I update my profile in project then I will not update the profile in 4 fields like name, phone number, email, ID, password and I'm using 2 tables reg and login.

    snbebyuu15 pointsBadges:
  • SQL queries

    Consider an organization “ABC” having many employees. An employee works for one department. Each employee identified by using Empid, having Name, address ( described as House_no, city, district, state, pin code) and more than one phone numbers. Department identified by using Dno, having Dname,...

    abcdefg1234567895 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.

Thanks! We'll email you when relevant content is added and updated.

Following