• Security/ Audit Check list for DB2

    Hi, I'm in the process of hardening the DB2 in Linux and I'm looking for a checklist to help me make sure I don't miss anypoint. Since I'm not an expert on DB2 I would like to have a starting point. I'm looking to make sure I don't leave open doors and also I want ot make sure I don't get an Audit...

    Josec990 pointsBadges:
  • How do you do LIMIT in DB2 for iSeries?

    We currently have a table of more than 50,000 records and we're trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write "LIMIT 0,10000" at the end of the query, it will bring you that record. How can you do it in DB2 for iSeries? Thanks!

    ITKE829,015 pointsBadges:
  • SQL and OPNQRYF

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

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

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

    ITKE829,015 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...

    CharlieBrowne62,280 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...

    hussain22juzer530 pointsBadges:
  • SQL Server 2000 Database Table Limit?

    Is there a limit to how many tables a single database can hold in SQL 2000?

    Xarly25 pointsBadges:
  • Software to automate backups for SQL Server 2008 databases

    I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

    Phrathepmali30 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 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:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 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:
  • Connecting to SQL Server 2005 after installing PowerBuilder

    I have installed PowerBuilder 11.1 and I am trying to access SQL Server 2005 from my system. I use SQL Native Client for connecting to SQL Server 2005, but I am receiving the error, "Could not connect to Data Source". However, I am able to connect to that server using ODBC and SQL Server Management...

    SQL Server Ask the Experts2,585 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:

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