• What is Broker EventHandler Wait Event?

    I keep seeing this wait stat "Broker_EventHandler" in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?

    Rick Martinez585 pointsBadges:
  • Should I enable service broker on SQL Server 2008?

    I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?

    Rick Martinez585 pointsBadges:
  • I want to delete records from a PF outside a PGM

    I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I'm not sure how to pass variable to either idea.

    TIB5 pointsBadges:
  • SQLRPGLE Error in UPDATE Query

    Hello, I have a SQL Statement in SQLRPGLE which Updates a 3 fiels in a file with 30 fields. SQL Statement is as below. UPDATE TABLE1 SET TXDATE = :SYSDATE, TXTIME = :SYSTIME, SETFLAG = :w_Set, MSG = :w_ERR, Comment = ' ' WHERE ID = :W_ID This works fine on one iSeries server and throws...

    sim400305 pointsBadges:
  • Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • SQL failed to execute the “ROLLBACK” command

    In the process of querying i made a mistake in an UPDATE statement which affected my "UNIT" field (all UNIT changed to 500). I used the ROLLBACK but dit not work. Please help

    Okappaw55 pointsBadges:
  • CPF8361 Error after V6R1 Upgrade

    After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

    Shadow4412265 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • SQL concatenate results

    Hi Need help here:-  I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS,...

    devan390 pointsBadges:
  • Passing an array parameter from crystal reports to a sql stored procedure

    Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I'm getting duplicates. I'm not sure how to set this up in...

    Jeager6640 pointsBadges:
  • SQL statements question

    I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ..... jan Feb mar . . . Etc. Can anyone help?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Help with embedded SQL in RPG. Dang thing hates the delete statement?

     H OPTION(*NODEBUGIO:*SRCSTMT)                             *******************************************************  FWRLDSHP   IF   E             DISK                       FWRLDSHP1  O  A E           K...

    nitzinger385 pointsBadges:
  • Would like to learn SQL. Which vendor should I go for and what certification should I get?

    Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly. cheers! Jeevan

    Jeevan231015 pointsBadges:
  • un-format object viewer sql tab

    Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer's SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

  • Complex SQL query in SQL Server 2008 tables

    Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

    Itoracle5 pointsBadges:
  • SQL Server 2005 Enterprise Edition SP3 Performance

    We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the...

    Rick Martinez585 pointsBadges:
  • Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to oracle side, so I know the concept of sql and pl/sql. Relating to this I dont have a project of this. So please give me some titles of project atleast I can go through this.. regard@sadashiv

    Ingalagi5 pointsBadges:
  • SQL in CLP

    Hi, I have to create a command that permits a user to copy records from one file to another and then remove those records from the first file. We've been doing it all manually using CPYF and INCREL and then deleting the records using an SQL Delete statement. I got the idea to create a command and...

    Floyd02320 pointsBadges:
  • VIEW_TABLE_USAGE SQL 2005

    In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View "PTP__MARA_MARC" uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

    44444Dave5 pointsBadges:
  • SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 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