• Refresh a SQL View in ILE

    I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

    BisonHawk25 pointsBadges:
  • Running queries causing system to hang

    A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The machine is...

    WindowsServerATE335 pointsBadges:
  • How do I write a SQL statement to get all data from a table called subscrib?

    How do I write a SQL statement to get all data from a table called subscrib?

    Thechriseco5 pointsBadges:
  • Error running an ASP.NET application in SQL Server 2005

    I have SQL Server 2005, version 9.0, installed on my system with VB.NET 2005 and IIS server running. When i tried to run an application created in ASP.NET, it showed me the following error: The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Store Procedure Codes Please help

    I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE,...

    Josephptran15 pointsBadges:
  • The XML page cannot be displayed

    I am using sql server 2005 with vb.net 2005 and IIS server installed. I tried to run the application created in Asp.net,but it showed me the following error. The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or...

    Sajad5 pointsBadges:
  • Matching External lists to your Database?

    Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

    Nik145 pointsBadges:
  • Cannot connect to SQL Server via LAN

    I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody...

    MissBelle5 pointsBadges:
  • SQL Writer library failed initialization

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Valeverger10 pointsBadges:
  • Installing SQL Server 2000 on Windows XP Pro

    How do you install SQL Server 2000 on Windows XP Professional?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring IPv4 host to IPv6 compatible in Fedora 9 Sulphur

    How do I configure the IPv4 host to IPv6 so that it is compatible in Fedora 9 Sulphur?

    NetworkingATE1,545 pointsBadges:
  • What is the difference between SQL and T-SQL?

    What is the difference between SQL and T-SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Simple SQL server question?

    I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

    Jtischler5 pointsBadges:
  • Create text file to OS400 folder by using Microsoft SQL Server 2005

    Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to...

    Sql200920 pointsBadges:
  • Error using SQL Server reports in a web application

    I have used SQL Server reports in my web application, and I can see it on the same server but we are getting a "Server Not Found" error on my user's machine.

    SQL Server Ask the Experts2,585 pointsBadges:
  • HTTP 505 calling SQL Server Web service from SAP PI 7.1 SOAP Adapter

    Hi, I have a SAP PI 71. scenario where I need to call a Web Service exposed by an SQL Server 2005 app running on widows 2003. The SOAP adapter call fails with an HTTP 505 indicating mismatched HTTP versions. it appear that sap is speaking 1.0 and sql server is speaking 1.1. Do you know of any way...

    Ziglmorf5 pointsBadges:
  • Video hosting

    I am including a video howto section to my business website. I have minimal experience in php and sql but have already created a SQL database for the information. I want this to be both dynamic and directable through the title of the video. can someone please give me direction.

    Tripodcomputerservices20 pointsBadges:
  • SQL Storage Server

    I am uploading in an SQL Server with a maximum of 1250 check images per batch with a minimum of 45KB file size (back and front) with indexes using a thrid party application. The images are temporary stored on a directory watch (7 folders) before running the import application. There are instances...

    Wackojo50 pointsBadges:
  • Sybase to SQL Server via linkserver

    I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...

    Seat15 pointsBadges:
  • SQL Server Linked Server Security Context

    Hey everyone, I'm working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use...

    Lvance16115 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