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

    ITKE978,585 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.

    ITKE978,585 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?

    ITKE978,585 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?

    ITKE978,585 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.

    ITKE978,585 pointsBadges:
  • Mch0601 error rc 04 within SEQUEL

    Is there a SQL cleanup or reset command that I can run to avoid this space offset error? For some reason I can not run a particular sequence of SEQUEL commands. I have two separate applications. I have a script that creates a file, and then uses that file as a view. Then I have a report definition...

    Modiyooch760 pointsBadges:
  • Date field update using SQL

    I need to add 2 years to a date field using SQL.

    pugsgma10 pointsBadges:
  • Attach remote SQL database

    I have a SQL database that's stored on a remote server. Would I be able to attach it in SSMS? I tried to map it with a drive but that's not showing up as an option.

    ITKE978,585 pointsBadges:
  • Create new connection in SQL Developer

    I recently installed SQL Developer on my local machine. I noticed that no connections are appearing. How can I create a new connection? Is the first step to create a new database?

    ITKE978,585 pointsBadges:
  • Schedule a job in SQL

    I have no access to SQL Server Agent, am I able to get a SQL script run every morning 8am?

    SQL12345 pointsBadges:
  • What is the right way to write this SQL Query?

    I keep getting SYNTAX errors when I try to write this query, what is the proper way to write this query? Query question and table information is below. Return the last name and GPA of the top ten students by Cumulative GPA for students that were enrolled in at least one class during January 1,...

    dhay335 pointsBadges:
  • See SQL statements sent on ODBC connection

    We have an application that uses ODBC to connect (and possibly make changes) to our SQL database. But at the end of the day, the results are wrong. Because of that, we would like to see all of the SQL statements that were sent. Can we do that in ODBC? Thank you.

    ITKE978,585 pointsBadges:
  • SQL: Which part should I execute first in which manner?

    What should I execute first? proc sql; select distinct e.firstname, e.lastname from sasuser.flightschedule as sasuser.staffmaster as b, sasuser.payrollmaster as sasuser.supervisors as d, sasuser.staffmaster as e where a.date=’04mar2000’d and a.destination=’CPH’ and a.empid=b.empid and...

    kapil956365 pointsBadges:
  • Editing date field in SQL

    Can we edit date field in SQL select statement?

    Msatbh185 pointsBadges:
  • Converting DB2 Timestamp to UTC milliseconds

    I'll get right to my point - would I be able to convert my DB2 timestamp into UTC milliseconds? Is there a function to do this? And yes - I'm currently doing this in SQL.

    ITKE978,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.

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

Following