• Track SQL Statements run by a specific user through ODBC Connection

    There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this...

    Haaiderali215 pointsBadges:
  • Select substring from clob-field with sql

    How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this...

    DanTheDane2,555 pointsBadges:
  • SQL/400 commands

    Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto

    SILVARB440 pointsBadges:
  • VERY slow server startup and shutdown

    Hi everybody! We have a problem on our Exchange 2003 server thats been getting worse and worse. We have a Dell PowerEdge 2850 server, and every time we try to shutdown or restart it, it take 10 to 20 minutes just to shut down and another 20 to startup. Sometimes we have to force shut it down...

    Shestopalov55 pointsBadges:
  • Limit the number of record in a table

    I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks.   I would i to have a clause or something that might help my to prevent users from exceeding the number of tracks available...

    Astre88m5 pointsBadges:
  • Order column in pivote table from vba

    I need help to make this, i try with PT4.PivotFields("Category").AutoSort xlDescending, "Ventas" but not sorting. Please helpme,          With ActiveSheet.PivotTables("PivotTable5").PivotFields("Ventas")        .Orientation = xlDataField        .Position = 1       ...

    Emoraleshn5 pointsBadges:
  • Insert values into database from form VB.NET

    Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • Quick Test Professional

    I have installed QTP 10.0 in windows 7 Home Premium 64 bit OS. But it is not recognizing the objects neither in Internet Explorer 9 nor in Internet Explorer 8. So, how to make it work with web objects?

    Badri25 pointsBadges:
  • School Project-setting up a network from the ground up for a real estate business that has 10 satellite offices. $125,000 budget.

    Help! I'm a IT/Networking student who is in a Network Management class where I along with 2 other classmates are working in a group to set up and configure a network for a real estate company consisting of 80 employees. There's a main office which consists of a CEO, 2 legal support people (lawyer...

    Rookiebear0 pointsBadges:
  • Internet explore not opening when I open QTP

    Hi, I have installed the QTP 10.0 Whenever I am opening QTP that time if any open Internet Explorer I was getting message (Internet Explorer has encountered a problem and needs to close. we are sorry for inconvenience caused) and same way new browser also not opening. If you have any idea please...

    Ssrujana15 pointsBadges:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Question on how to code REXX

    I am trying to learn REXX and I am learning on my own.  What I want to do is make a wildcard for the end of FWEBSRV to either an "I" or an "M". I have looked at some other code and it looks like people have used a "namer" and "rname" in the code.  Do I need to do this?  "TRAP ADD(OWWEBERR)",...

    Patticlarke0925 pointsBadges:
  • Error when running any program in Oracle JDeveloper 11g

    Error occurred during initialization of VM Could not reserve enough space for object heap kindly give me an idea to solve this problem. thanks in advance

    69598410 pointsBadges:
  • charset problem

    I'm devloping RESTful web services using jersey in NetBeans 6.0. I'm accessing the services through Ajax javascript. In each request i'm sending an xmlString which is then parsed at the service level and stored in the database. This is working fine. For the same service i'm trying to access from...

    Idiva5 pointsBadges:
  • MS SQL query to update a table with the last entry in another table.

    Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is a...

    GPNel200675 pointsBadges:
  • Access 2003 SQL Query for grouping

    Team... I need your help... SELECT Pickerid, Sum(Currentweight) AS TotalWeight, IIf(pickerhours=0,0,TotalWeight/pickerhours) FROM mergeddatabase WHERE ((Currentdate) between [Enter First Date Required:] and [Enter Last Date Required:]) GROUP BY pickerid, pickerhours; I have a access database (2003)...

    witsendestate225 pointsBadges:
  • as400 not working in windows 2008 server

    my script is working in windows xp, but not in windows 2008 server. I just fetch the records from as400 through php. if i run that page means iy says the page is not available. if i disable the as400 odbc connection means it will run and say no connection but i enable the code means it says the...

    PHPAS40015 pointsBadges:
  • SQL WKS SELECT COMMAND

    Thanks for your response. Actually i am using Oracle 7.3.1 with Devloper 2000 I want to get information from a table name ‘bilmst’ having column name ‘a/c no.’ and ‘enterdate’ i want to collect information as follows fy 01-07     No of A/Cs to 30-06 2005-06        1500...

    23523523595 pointsBadges:
  • vb.net 2008 login using ms access

    hi guys,ive been working on trying to create a login form. ms Access side: -used a logininfo.mdb database with columns :username,password,job vb 2008 side: -login form with clerk rad button,manager rad button,username text box,password textbox and login button now the challenge im having is that...

    Dissector5 pointsBadges:
  • What criteria would you use in selecting a life-cycle model for the Project?

    You are a software engineering consultant and have been called in by the vice president for finance of a corporation that manufactures and sells boots. She wants your organization to build a product that will monitor the company’s stock, starting with the purchasing of the leather and keeping...

    Ashindya10 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