• Creating JCL to execute a large merged file of SQL for DB2

    I need to create a JCL that will execute - individually - SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?

    Jonty Walker105 pointsBadges:
  • DB2 Transaction in C#.Net

    Hi, I am using C#.Net with DB2 batabase. I have installed IBM .Net Data Provider. I am facing problem with Transaction. when I execute insert query with transaction it doesn't work and without Transaction it works fine. does anybody know what's the problem am i making? remember i am using...

    Mr. SEA130 pointsBadges:
  • Data Modeling Tools for relational database & dimensional data mart

    I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction...

    Mkaukonen5 pointsBadges:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

    MarcGreen20 pointsBadges:
  • set up file not installed in other system

    Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using "Pavkge and Deployment Wizard" from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that "SET UP...

    Bipansahoo20 pointsBadges:
  • How Can i restrict the user to insert next record

    Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop up a...

    VBAccess5 pointsBadges:
  • Limiting characters in memo field

    In Access how do I restrict the number of characters a user can enter into a memo field?

    Olddog10 pointsBadges:
  • Grouping in a report

    I want to group sets of data (from a query) in a report. The report will have a static header and footer (info from another query). I want a new page generated with each new grouping.

    Kemosabe5 pointsBadges:
  • Restricting the user to insert next record

    Hai all, I have a subform which is in datasheetview mode , I have to validate the subform field s in such a way that if one of the fields is empty i will popup a msg like 'must enter a value ' then the focus should goto that field and restrict the user to insert next record till the user provides...

    Giridharrajup5 pointsBadges:
  • Embedded SQL in SQLRPGLE using JOIN on multiple files

    Greetings, In the past I've used embedded SQL in an SQLRPGLE program and on the FETCH INTO statement I specify an externally defined data structure with the definition of the file I am SQLing thus allowing me to read in the entire record's fields mapped correctly in one FETCH INTO statement... This...

    Jklipa0 pointsBadges:
  • Best authentication method

    I'm researching authentication methods, trying to determine what method is best for allowing customers to make payments online. Which, in your opinion, is best?

    Coder6270 pointsBadges:
  • Procedures for a new area.

    We are a company where we have expirience on network remote administration and now we have open a new area, The area of security. Now I need to start to make new procedures like when a new customer come to us and ask if we can handle the security for his network... I need to know if some one can...

    Millan0 pointsBadges:
  • MS Access IIF

    There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the different types of costs seperately...

    Keg5 pointsBadges:
  • Progress bar tie-in

    Hi Guys, The problem I'm having is to tie in a progress-bar to a dataBase file so that whenThe user advances through the files(or backs up), the progressBar shows the relative position of the column they're at to the dynamically sizable total # of columns in the dataBase. This should be a...

    Firedrake30 pointsBadges:
  • Paranoid about protecting my MAC address–Please read my story

    What is the easiest way to protect your MAC address against spoofing? In 2004 I was the victim of a hacker that somehow spoofed my Cable Modem Mac address and used it to cover his identity while serving copyright material thru the internet. I was unsuspecting until my ISP one day suspended my...

    DonBlake0 pointsBadges:
  • Need help reducing application downtime during updates

    I have an application which does monthly update of data in Database and also does select queries or minor updates. Monthly updates last for 24 hrs and application is down during the time. I am planning to use 2 schemas. The first one will be used for minor updates/selects. The other one will be...

    OracleATE190 pointsBadges:
  • run DBCC SQLPREF on linked server.

    I want to run DBCC command on linked server remotly

    Mangesh jadhav5 pointsBadges:
  • IT Career Path

    I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is "Database Administrator - Operations" and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to...

    D-Nel5 pointsBadges:
  • Two Applications sharing the same database

    Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question:...

    Said5 pointsBadges:
  • MS excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of excel. How do I do this with MS excel 2007?

    Geyes15 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