• 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,042,780 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,042,780 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,042,780 pointsBadges:
  • Get SMS jobs status in SQL Server 2014

    I have several SQL Agent jobs that are running on SQL Server 2014. Now, I need to get the SMS once a job has completed. This would include the job status and if went successfully through. How can I get that?

    ITKE1,042,780 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Set default value on SQL database table

    I have a SQL database that has a column with several tables. I need to create a trigger (or even a stored procedure) that would set the default value for the column in all these tables. How can I do that? Hope this question makes sense. Thanks.

    ITKE1,042,780 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