• Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 pointsBadges:
  • Exporting Active Directory user info to CSV

    Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they  be encrypted? Where can we find the encryption key so we can make heads or tales of them.

    Karl Gechlik9,860 pointsBadges:
  • Access 2003 – command button to show query in pivot format

    I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

    Smbecker5 pointsBadges:
  • job QZDASOINIT

    My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?

    Wasifzaheer35 pointsBadges:
  • SQL Server I/O

    Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of...

    Rick Martinez585 pointsBadges:
  • Windows go blank while running reports in 10g

    I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.

    Freestyler10985 pointsBadges:
  • Using SELECT with LIMIT clause on a physical file

    Hi - I'm new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

    jakusza30 pointsBadges:
  • Jreport problem – floating point literal

    hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

    LouIT5 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Expression Builder, Calculation confusion in Access 2007

    Ok I’m having trouble with this simple calculation.  I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or greater than...

    Phil12550120 pointsBadges:
  • Excel date format

    I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

    Tamara5 pointsBadges:
  • ID Theft and National Security

    If it turns out, as I believe, that enemies of the United States are behind a lot of the major ID thefts in the US, that would mean that a lot of money is going to our enemies. Can we therefore surmise that those who mishandle our identity information, by means of their poor stewardship of our...

    InfoSafety75 pointsBadges:
  • Migrate MYSql database to SQL 2005

    We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Visual Basic Email Script

    I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?

    Dragione5 pointsBadges:
  • Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?

    Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables? This would likely be done via a web browser interface such as Joomlah.

    Restart15 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell470 pointsBadges:
  • Get data from one MySQL datebase server to another in real time

    hi     I am useing mysql database, I want to create one more database which I want to get updated in real time from the remote mysql database server. kindly help me in this. Thanks    

    Chetanm145 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • Documentation devices in the field

    I work in field desktop support and get calls from users while I am going from issue to issue and need a way to track all the calls to open service tickets, log the issue, document the fix, start/stop end times. We use a web based program called service now. I can get it up on my blackberry but for...

    Knighteyes0075 pointsBadges:
  • How to update a row in grid view?

    how to update a row in grid view when changes made to database..

    Santu1015255 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