• complexity for shell script migration

    we have approx 700 shell script which is written for sybase ASE. and we have to make them compatible to work for SQL SERVER 2014 as we are migrating our database from SYBASE ASE 15.7 to SQL SERVER 2014. could you please tell me what should be my checklist in every shell scripts?

    mayurigupta915 pointsBadges:
  • How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 pointsBadges:
  • MS Access split database link to MS Query

    I have a Microsoft Access database which I would like to split. I also have Excel spreadsheets with Microsoft queries set up to pull information from queries in the Access database.When I tried splitting the database my Excel queries stopped working. If I tried to link them to the front end of the...

    Angelsfear5 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN20006,360 pointsBadges:
  • Martin

    Software user but with some database development experience

    jtaservices15 pointsBadges:
  • Microsoft Outlook error occurred.

    Microsoft Outlook must be closed because an error occurred. Any unsaved work may be lost. what do I do it comes up every time i am in outlook. It seems to be trying to send 2 items but I can't find them.

    Corisa5 pointsBadges:
  • Acess servers

    list of access servers used by different isp??

    hareem5 pointsBadges:
  • How to fill Combo Box at runtime in VB 6.0 …I’ve used RecordSet object but rec.count of rs obj returns (-1).I hv enough data in the DB

    [Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox...

    Spartanx5 pointsBadges:
  • We are trying to make database of membership

    We're looking to create a database for our membership (particularly searching for an Excel sheet).

    jagdishchandrajoshi5 pointsBadges:
  • Corrupted log file on Exchange still needs to be restored.

    How would you recover Exchange server when the log file is corrupted?

    Karl Gechlik9,860 pointsBadges:
  • Having issues connecting DB2 with .NET

    I'm trying to connect to a DB2 database (an iSeries version) using .NET by referencing a .DLL and not installing software on my server. I currently have IBM.Data.DB2.iSeries.dll installed as part of iSeries access for Windows. Is there an easy way to connect from .NET to DB2 by referencing a .DLL...

    ITKE54,910 pointsBadges:
  • Send group invitation on Outlook 2010

    I have a group list i made. But i keep getting an error that says "Only users with SMTP email addresses can be invited" Does anyone know what this means or why it is happening?

    MediaMaverix5 pointsBadges:
  • About Creating Standby Database in Oracle.

    Hello,Can anyone please tell me the steps to create the physical standby database in Oracle 11g.I want to create it using the dos prompt. And please mention what I have to do regarding control files and the datafiles.

    Jeethu5 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,520 pointsBadges:
  • SOA web service calls on DB2 RPG stored procedures

    I'm trying to centralize our business logic so that it calls up our web services (SOA architecture run on Spring HttpInvoker) from DB2 RPG stored procedures. I can't get it to work, so is what I'm trying to do actually possible?

    ITKE54,910 pointsBadges:
  • Need some help with queries in DB2

    Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.Search the entire database that look for tables with a column called "Remarks"Search...

    ITKE54,910 pointsBadges:
  • save all listbox items to access DB

    Trying to save all items from a listbox, ListBox1, to an access db named CalcDB when a button is clicked, "Save To DB"

    Enumerate5 pointsBadges:
  • I’m having trouble with a simple query in DB2 for AS/400

    I know I'm an amateur when it comes to AS/400. I have this "easy" query but I still can't do it. Here's what I have:A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1And this is how I want it returned:A B C 1 1100 10 2 1200 8 3 1300 6I tried this but it's only...

    ITKE54,910 pointsBadges:
  • how to set gridview column width to auto

    I put together a simple vb program, or so I thought. I am accessing DB2 tables and trying to pull the data in using a DB2 reader. What I'd like is to have the columns be set to width=auto. The number of columns depends on the DB2 table. I'm getting an error "Index was out of range. Must be...

    ToddN20006,360 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE54,910 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