• sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN20006,360 pointsBadges:
  • What are your favorite cloud security blogs?

    You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions?

    MelanieYarbrough6,345 pointsBadges:
  • Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Flowchart

    Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!

    melkamu15 pointsBadges:
  • Setting a username and password in SQL Server

    How do I set the username and password in SQL Server to allow connection to the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need SQL 2012 alert to run when job step fails

    I have a mutli step SQL Server job that when one of the steps fail an alert needs to be sent out, however the job can't fail on this step it needs to continue. I have tried a trigger on sysjobshistory but that has gotten kind of ugly. So for example: 3 step job step 1 completes goes to step 2 step...

    tcstl95 pointsBadges:
  • Prompt user to change password before expiration Issue

    I have a problem with only one user so far where the system will not notify them that their password will expire in 'X' days. I have the following item set in the GPO: "Interactive logon: Prompt user to change password before expiration - 5 Days" I've checked the Group Policy results and it shows...

    Kmeister0 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:
  • connect sql server with tcp/ip how can i do?

    connect sql server with tcp/ip how can i do?

    DangerM5 pointsBadges:
  • How to extract key phrases from a log file using a batch file.

    How can I  extract key phrases from a log file using a batch file.  I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file.  I don't need to pull the whole log file.  Just...

    Stretch2160 pointsBadges:
  • SQL Server on SAN

    I a two server set up. Server one for my application and server two a SAN for my SQL Server.  Should I install the SQL server on the SAN?  I have read about 10 articles and some state to install the SQL Server on the app server while others say on the SAN and yet others say it really does not...

    Needplease5 pointsBadges:
  • How to find paragraph by typing a word

    I have saved resume in SQL table. If i type any word in the resume. I need to get that particular resume (resume may have spaces & symbols).

    Swethakaranam5 pointsBadges:
  • unique next no. generation problem

    have to generate unique_number the condition is the user may or may not have system_no which is allocated by the system the user first time start the system/application and if the user format that system the same unique_no will be generated again.this no. comes to our server for user_id and...

    sukhendass5 pointsBadges:
  • SOP for cleaning Server rooms

    Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces - cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require...

    Sinead5 pointsBadges:
  • Parameter issues in VB.NET for AS/400

    I am having problems getting parameters to work within a VB.NET query written to AS/400. Any time I include a parameter in my query (ex. @MyParm) it doesn't work. I get the following error: SQL0206: Column @MyParm not in specified tables Here's my code: Dim da As New OleDbDataAdapter Dim dt As New...

    ITKE56,520 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE56,520 pointsBadges:
  • Apps built on SQL Server 2005 running in 2008?

    Will applications built in SQL Server 2005 run in a SQL Server 2008 environment

    jwover5 pointsBadges:
  • Locating default library in AS/400 with iSeries

    I'm having trouble figuring out how to boot to the default library while connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This set-up works through.NET DLL with classes similar to those in the System.Data namespace, and therefore uses its connect...

    ITKE56,520 pointsBadges:
  • I need help creating a delimitted string in DB2

    Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...

    ITKE56,520 pointsBadges:
  • Scheduling join queries in AS/400

    I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?

    ITKE56,520 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