• SQL and OPNQRYF

    What we can do in SQL which we cannot do in OPNQRYF

    sunnygupta35 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • How save SQL and CL in SAVF!

    Hello, How to save CL and SQL in SAVF, while SAVLIB command these two type of members are not saved. I want to move these from V7R1 to V5R4. Please suggest!

    sgautam11105 pointsBadges:
  • Help joining data into table 1 from table 2 SQL

    I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.

    JustAnotherITguy60 pointsBadges:
  • Porting a C+ app from SQL to Citrix

    I’m running a C# application on a number of workstations through the same MS-SQL database. I've been asked to port this to Citrix.  How would one even get started on such a transition?  Does anyone know of good documentation I could access? Once the C+ app is installed on the Citrix server,...

    ITKE62,205 pointsBadges:
  • How to manage SQL queries on iSeries

    We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!

    StarTaylor15 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • How to find a specific word in a SQL table

    How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

    Boomer15 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne39,845 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 pointsBadges:
  • SQL Server trigger, insert result of multiple where clause into a variable

    Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I am...

    Jacquesvdm20 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • How to create table using a subquery in SQL Server

    Hi everybody, Everyone knows that a table can be created using a subquery in oracle. How to do the same task in SQL Server. In Oracle I tried as "create table table1 as select * from table2" My requirement is to create dynamic tables in stored procedure based on existing tables. I'm so desperate, I...

    Carbuncle0 pointsBadges:
  • SQL Server restore job fails

    I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

    TuftsDBA0 pointsBadges:
  • SQL Server date format

    Hello, I have a problem when i am inserting a string date ie 19/9/2010, which is stored in table as 9/19/2010.  i want to insert dd-mon-yyyy format. can i insert dd-mon-yy format,please replay. 

    Shamu75 pointsBadges:
  • SQL Syntax issue via Free-Form RPGLE

    I'm having difficulty with a select statement.  As below, it works .  If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements.  I'm trying to populate an output 3-char field with either Yes, No, or N/A.  The Y/N comes from the contents of a field...

    Eric Witham690 pointsBadges:
  • SQL Query

    Employee: EmpID Name Company MGR_ID Date_of_Joining 1 Bhaskar A3 3 1-Jan-13 2 Ujin A1 3 1-Jan-13 3 Rex A6 NULL 1-Jan-13 Model: ID Model_Name Company Model_Type Harddisk OS RAM 1 750 Dell PC 600 GB WIN 7 4 GB 2 650 HP LAPTOP 400 GB WIN 7 6 GB 3 350 DELL LAPTOP 300 GB WIN 7 4 GB System: ASSET_ID...

    InformaticanSQL10 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN20006,435 pointsBadges:
  • How to read transaction log in SQL Server 2014?

    I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...

    ITKE62,205 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