• When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    Rofnh20 pointsBadges:
  • i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that

    i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that

    Iluilu5 pointsBadges:
  • Problems witih Cisco AP Aironet 1231AG

    hello! i have done something very stupid...I erased cisco IOS image and now when i connect via com port and set up the ip address, netmask and default router, i still cannot connect to the AP i can't even ping the AP, and in order to upload other image i must be connected to it via tftp but every...

    Air1231AG5 pointsBadges:
  • how to block update command when using STRSQL ( db2/400)?

    Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

    Altino20 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Access 2003 default record locking

    I'm working with a multi-user Access system. When I change the default record locking option via Tools/Options/Advanced and then save the database, the other users still have the original setting for record locking, i.e. the change I have made is not shown on their machines. Shouldn't the change I...

    Jch0275 pointsBadges:
  • wireless roaming howto

    I have 3 routers (2 trendnet, dlink) one of trendnet (192.168.100) is connected to my proxy server and i want the other 2 acts as access point and do roaming. I did a setup using same ssid, differents channels but i can't ping to 192.168.10.100 (proxy connected ). What else should i do? Thanks in...

    Tics5 pointsBadges:
  • what is rack awareness of HDFS?

    What is reck awareness of HDFS and how can i optimize the network bandwidth using replication factor 2 ?

    79900150 pointsBadges:
  • Sql Query in AS400

    I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

    Mr. SEA130 pointsBadges:
  • database saves to new file

    Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.

    Shazzie70 pointsBadges:
  • Access Switchboard Problem

    The title of the switchboard changes to the title of one of the items. I can't figure out why.

    Tryan1225 pointsBadges:
  • Xml Reader in oledb

    how can i get ExecuteXmlReader() in OLEDB? i used sql server databse in my project. but now i want to change it to OLEDB. but ExecuteXmlReader() is not in OLEDB. what can i do to solve this? pls reply.

    Chinki10 pointsBadges:
  • Unable to restrict the display to top N records in subform in Microsoft Access 2003

    I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query "select top 10 * ...", it executes successfully in the query editor window but...

    Zafarkhurram10 pointsBadges:
  • data copy – paste from the same table not showing in a subform

    I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

    Tcharlton7920 pointsBadges:
  • Slow SQL Query

    when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

    Mxaxyogesh200230 pointsBadges:
  • Microsoft Access Audit Report

    I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...

    WayneW194720 pointsBadges:
  • External document used as an Access Form?

    I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...

    Rmason345 pointsBadges:
  • Showing a substiute value in a report if conditions are met – Access

    In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...

    Gbullo70 pointsBadges:
  • DB backup is hung

    What are the different ways to know if DB backup & archive log backup process have hung. How can we know the average run time of db backup & archive log backup ? What are the advisable checks to be performed / steps to be taken if we observe the backup is slow (determined by average) or has hung.

    Jayeshmb15 pointsBadges:
  • table from gridviewwith sql vs2008

    hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings...

    Zpupster65 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