• My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • Output errors from SQL Server stored procedure

    I have a stored procedure using SQL Express that update a table using data from another table. All is well except that from time to time the source table might have data that causes an error. I would like to add some code to the stored procedure that will catch the error, output the details to a...

    Spionred35 pointsBadges:
  • Left outer join

    I have 5 related tables. The main table is meeting. The other tables are participant_meeting, vendor,user_id, address. I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the...

    Niveanand5 pointsBadges:
  • Easytrieve – Dynamically assigning collection id

    How do I dynamically assign a collection id to an Easytrieve program? I have an Easytrieve program which is an input parm within a mainframe Proc. My SQL works fine when the collection ID is assigned on the "PARM SSID(xxxx)" statement. How can I get this value to be assigned at run type without...

    Marsh218335 pointsBadges:
  • SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)

    Under ISDB, JOBLOG showed' Internal Error 1001 has occurred SQLCOD -901' SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’ SQLERP was ‘QSQROUTE’ - According to Manual ‘DB2 Universal Database for...

    TonyC15 pointsBadges:
  • Multiple Join Update

    Hi, my need is to update a table with a join of 2 other tables. The first table (a) has 5 columns (product_id number, ist number, plan number, plan_w number, ist_w number) The second table (b) has 2 columns (prod_group_id number, percent number) The third table (c) has 2 columns (product_id number,...

    Keltos25 pointsBadges:
  • SQL login client not admin

    it is payday and on the client side of our DB there are some login errors, where in SQL do you go to check points of failure?

    Deliverance40 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Unique ID for existing table

    I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

    Ragas60 pointsBadges:
  • Recordset clobbers asp page

    I am using Dreamweaver CS4 VBScript asp pages. I have a database sitting on a SQL server. My connection resides on the server, not my machine. I build a page with just text and I can go to it just fine and then I make a recordset using the connection to the SQLserver, point to the correct table and...

    scuzantip35 pointsBadges:
  • bolding a text field

    HI, I need to generate a letter, within the letter i want to 'bold' some of the text lines. is there a way to do that?

    Rgillespi15 pointsBadges:
  • SQLRPG MaTERIAL

    I got a task to work on SQLRPG programmes , but I am very new to this environment . Can any one send me any link about : SQL-RPG . I need from scratch. Thanks in Advance.

    Khadar90 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • How to config iSQL Plus on computer without a domain

    Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

    DerrickOra5 pointsBadges:
  • Local Security for Vista Home Premium – Network Access

    Hi there Vista Home Premium - I've been trying to configure the local security option for Network Access - sharing and security model for local accounts, to 'Classic - local users authenticate as themselves'. This PC communicates with another where an account has been created ( user and password...

    Gratch5 pointsBadges:
  • SQL 2008 Identity column values 0

    We recently migrated our application from sql 2005(32 bit) to sql 2008(64 bit). I have observed that one of our tables with an identity column is now having all values are 0. I am yet to find out the reason .Could this be related to migration??

    Swetaleena5 pointsBadges:
  • Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl69,510 pointsBadges:
  • how to capture cases in store procedure codes

    I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR...

    Josephptran15 pointsBadges:
  • spool to flat file from SQL editor

    I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?

    Daowebe20 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