• 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:
  • 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,815 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:
  • Error with SQL

    I am trying to use a SQL statement in an RPGLE program to select a group of records. I have verified that all of the files used in my SQL statement is in the file. I keep getting the errorsSQLCOD=-000000206 SQLSTATE = 42703. Here is my statement:C/EXEC SQL + DECLARE C1 CURSOR FOR C + SELECT WOCSCD,...

    lrgronewold25 pointsBadges:
  • Change number in SQL Server

    How do I convert an English number to an Arabic number in SQL Server?

    elenahasooni5 pointsBadges:
  • How can I stop the export process in SQL Developer

    I apologize in advance if this is a stupid question but does anyone know how to stop the export process in SQL Developer? Thanks!

    ITKE1,011,420 pointsBadges:
  • SQL Select for Multi Format File

    I need to select and update fields in an iSeries file with multiple formats. How do I specify the member I want to work with?

    Roycer775 pointsBadges:
  • How to update tables in SQL

    In SQL, I'm trying to update my tables using the update query. Here's my code so far: update tb1 set class='X' and SUB_CLASSIFICATION='XX' where id=12345 and loc='0250' and TYPE='I' and CLASSIFICATION='B10' Would this work? Thank you.

    ITKE1,011,420 pointsBadges:
  • SQL code for deleting Microsoft Access database rows

    I need to delete all of the content in several rows on a Microsoft Access database. How can I setup SQL to do this? I found this but I'm not sure if this works: Dim SqlQuery As String = "DELETE * FROM QuestionResults WHERE Quizname = " & txtQuizName.Text & ";" Can anyone help?

    ITKE1,011,420 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