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

    ITKE971,050 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?

    ITKE971,050 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.

    ITKE971,050 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.

    ITKE971,050 pointsBadges:
  • Dump content from IBM DB2 schema into SQL text file

    For the past few days, I've been trying to dump content from a schema (that's from a IBM DB2 server) into a SQL text file. But I'm running into a dead end. What should I do here? Is there anything like mysqldump for MySQL? Thank you.

    ITKE971,050 pointsBadges:
  • DB2 table columns description

    I'm using DB2 - I need to know the description of all the columns in my table. Can I do this using SQL? Thanks so much.

    ITKE971,050 pointsBadges:
  • Types of JOINs in SQL

    What are the types of JOINs in SQL?

    vijaykumar110 pointsBadges:
  • How to use Crystal Reports with LINQ to SQL

    I know this is a broad question but this is the only way I can ask the question. I use Crystal Reports all the time. Is there a way I can use that with LINQ to SQL? At least someone can point me in the right direction, right? Thanks.

    ITKE971,050 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • How do SQL related to this program?

    Can anyone tell me how SQL is related to my program?

    nlhabal5 pointsBadges:
  • SQL: Storing data in a column

    Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.

    Raju12345 pointsBadges:
  • Access SQL: Records from the Vendors table

    For Access SQL, how do I save records from a vendor's table

    NikiaBainton5 pointsBadges:
  • SQL query for descending order

    How do I input only each product’s name and sort them alphabetically (in descending order from Z-A)?

    ProfRockhill5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 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