• understanding and detecting sql performance situation with abnormal 400 shutdown

    Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...

    Modiyooch540 pointsBadges:
  • query for join

    i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was...

    Rampradeep5 pointsBadges:
  • DB Instances

    Hello, In QA, aside from always having one db instance which looks like productions, should I have other DB instances created. If so, why? Regards, Peter

    Pete11565 pointsBadges:
  • CallManager and SQL Queries

    I need to gather some data from our call manager and the reporting tool that comes packaged with the server is horrible! We have Call Manager version 6.1. Is there anyway query the call detail records other then using the reporting tool? If so, please advise me. Thanks

    Jlandon5 pointsBadges:
  • Delete variable file in SQLRPG

    How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

    Samuele5 pointsBadges:
  • Populate Access 2007 object in form

    I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

    OhioPat5 pointsBadges:
  • Bulk Insert with collation change

    Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the database...

    Db23290 pointsBadges:
  • CA Database Command Center — good competitors?

    Please note: The following question was recently submitted via e-mail by a user. We're looking to use CA's Database Command Center, but I want to know if there are any good competitors we should be looking into as well.

    JennyMack4,280 pointsBadges:
  • i need MCQ’s in principle of distributed database system

    MCQ's on query processing/ MCq's on trancation managment?

    JD105 pointsBadges:
  • Rebuilding Logical Files

    What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

    Dcantwell470 pointsBadges:
  • SQL Server query

    how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

    Hodhod5 pointsBadges:
  • Connectivity between Oracle BI Publisher and Microsoft Access

    I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

    Ms123115 pointsBadges:
  • Windows ODBC driver for IBM DB2 database

    I'm looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?

    mshen27,385 pointsBadges:
  • Making two records into one

    I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail AS...

    Fscopel15 pointsBadges:
  • Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression

    Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as "Runtime Error 2147217900 (80040e14) - Syntex Error (missing Operator)in query expression "...

    RajeshP20 pointsBadges:
  • File attribute DFU

    I have come across an object whose type is *File and attribute is DFU? What does this mean?

    Niklethaldan10 pointsBadges:
  • Dymo Printer programmatically with VB.NET

    For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as IDE and MS Access 2007 as backend. Any fast help is...

    Honeyprogrammer35 pointsBadges:
  • Missing Database Name and toolbar

    Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

    LarryThompson5 pointsBadges:
  • IMPORT DATA MS ACCESS FROM PDF (VBA)

    HOW I CAN IMPORT DATA MS ACCESS FROM PDF THROUGH VBA CODE

    AnandaDebnath280 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 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