• Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • SQL7919 Data conversion error

    Hi, I have an embedded SQL program in which I generate an XML element as a VARCHAR(256). This is done via: select xmlserialize( xmlelement(NAME "Name", 'Something') as VARCHAR(256) ) as XmlResult from sysibm/sysdummy1 The SQL statement is run via sqlcursor and I fetch the result into a RPGLE...

    mathypaesen10 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE407,235 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE407,235 pointsBadges:
  • How to substring and cast in select where statement on iSeries with RPG free

    Hi. I'm relatively new to free form RPG and I rewrote a program to be RPG free and SQL. I'm having problems with my where clause. I'm trying to substring the second byte on a 2 digit packed field. I've tried to use the CAST statement to convert the packed field to CHAR and then do the SUBSTRING on...

    raynesnf65 pointsBadges:
  • Duplicate record deletion using SQL/400

    Hi, How do I delete duplicate records using SQL/400 with SQL query please? Thanks!

    6r1,715 pointsBadges:
  • How can I change SQL language and date format?

    I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much

    ITKE407,235 pointsBadges:
  • Should I run a SQL view in my SQL Server database?

    For SQL Server, should I run a SQL view in my database? My friend told me to just run a stored procedure but I would rather run a view for security purposes. What should I do?

    ITKE407,235 pointsBadges:
  • Online report missing data that is in PDF

    When we view a report on Report Manager it shows 5 rows and a group count of 10. If you spool the report out to PDF or print it, it shows 10 rows and a count of 10. If you search online, the data in rows 6-10 cannot be found but they are there in the PDF and the printed version. Why is the data...

    AndreaFl15 pointsBadges:
  • SQL split column into multiple rows.

    I'm going nuts.. I have a table with 30+ columns. One of the columns has a string with serial numbers that are comma separated. What I'm trying to do is create a new temp table with the identityID and the serial number. This way I can add each parsed out serial number value to our production data...

    ToddN200043,865 pointsBadges:
  • RUNSQLSTM command failed

    I have created one member with SQL table type under which I have written create table query. But when I tried to compile program using RUNSQLSTM, it's showing RUNSQLSTM command failed. I am using pub1 demo server.

    nabamita75 pointsBadges:
  • Using Count in SQL database

    I have a database with students results, for test and assignments also examination final marks so I want to count the number of student who wrote a certain test, count the number of those who passed and those who failed. How can I implement that in SQL?

    EllyodM5 pointsBadges:
  • Can we use neverfail for data replication between SQL Ent and SQL Standard version?

    Does anyone know if we can use neverfail for data replication between SQL Enterprise and SQL Standard versions?

    qaziaamir5 pointsBadges:
  • TOP SQL statement not working

    I am running a simple SQL query on toad SELECT TOP 2 HRS_OFF_ID FROM PS_HRS_OFFER but it keeps on telling me that 'FROM' keyword not found where expected. What wrong am I doing here?

    ashwin255 pointsBadges:
  • SQL query: Fetch all records from date field

    Hi, How to fetch all records from the date field less than current date's records provided date field format is centuray(C):YY/MM/DD Thanks.

    6r1,715 pointsBadges:
  • Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 pointsBadges:
  • Receiving SQL error message: ORA-01722

    In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it? INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES...

    ITKE407,235 pointsBadges:
  • How to get unique values from column without using Distinct keyword in Oracle?

    I have a table in which the column has duplicate values in it. If i need to get unique value from that column without using distinct keyword then what will be the query?

    Sheeldk5 pointsBadges:
  • How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)

    How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)? Can anyone help me?

    Nurwarsame5 pointsBadges:
  • File size more than 180 GB for the data extracted from an internal table

    If I'm getting a file size more than 180 GB for the data extracted from an internal table. How do I resolve this issue?

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following