• How to implement a database on the users computer?

    Suppose I want to develop a database for a client/firm/user or any person. I develop the DB using SQL, now I want to display the end result or the outcome on the clients computer without displaying the coded part, i.e., he/she doesn't need to know about the codes and commands, he just manages db...

    granada15 pointsBadges:
  • AS400 Subfile session or device error

    DOW *in12 = '0' Seton 2526 Write blank Write foot1 WRITE MSGSFC Exfmt sfc01 call 'L1000C' These codes are from my program when i'm executing these pgm im getting seesion or device error. I checked with debugging , when the execution comes to the EXFMT line its showing the error.. Pls giv me some...

    Sureyz2,375 pointsBadges:
  • Question on time series

    The daily output of your company over a four week period is shown in the table below: wk 1: monday 187 tues 2203 wed 208 thurs 207 fri 217 wk 2: mon 207 tues 208 wed 210 thurs 206 fr 212 wk 3 mon 202 tues 210 wed 212 thurs 205 fri 214 wk 4 : mon 208 tues 215 wed 217 thurs 217 fri 213 (a) plot the...

    Tanvi280420 pointsBadges:
  • IBMDA400 Date Issues

    The IBMDA400 provider seems to convert dates to character values even when using keyword "Convert Date Time To Char=FALSE". This does not happen with the ODBC driver or IBMDASQL provider. I'd be okay with IBMDASQL except IBM states it only works the SQL statements. I'd be okay with ODBC driver...

    Craig Hatmaker1,705 pointsBadges:
  • Need to identify the next sequence of number in a character field in DB2

    I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found the starting...

    Dsaran2007150 pointsBadges:
  • Access to DB2 from Oracle

    I want to access the DB2 database on iSeries from Oracle 11 (read and write). What is the best way?

    andiqu15 pointsBadges:
  • If logical function in MS Access

    I have to use IF logical function in MS Access.

    administrat15 pointsBadges:
  • QMF

    USER TRYING TO DOWNLOAD QMF REPORTS GETS ERROR IKJ56712I INVALID KEYWORD

    stewarteg5 pointsBadges:
  • pb exe runtime eror – does not connect to db2 database from client machine

    I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on...

    1111111q5 pointsBadges:
  • Access 2010 Field Design View, how to set up for multiple names

    I am using Access 2010 and I am setting up a training database to show trainers names against various training modules. Now some of these training modules have many trainers against these modules, how do I set this up? I have made a table with the modules and now I need to put trainers names to the...

    apmitch5 pointsBadges:
  • Access 2003 changing the company name

    I am working in a 2003 access db that was set up by someone else. the Company name has changed. How do I change the company name so it prints out correctly on our work orders?

    bathgenie5 pointsBadges:
  • Access reports dropping data included in query

    My primary key for my database is based on phone numbers. I have created a query which includes anyone that has an outstanding balance. The query includes last names that are the same which I see. I have 3 people with the last name of Thomas, all have different first names. I created a report from...

    osbornisle5940 pointsBadges:
  • Anyone familiar with 4D front end to DB2 database

    Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I've tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting...however I can't get DB2 to maintain the formatting and I used DDS to to generate the physical...

    Gmil494365 pointsBadges:
  • Table setup

    I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date - Quote # - Customer - Cust Quote # - Part # - Part Name - Quote Due Date - Qty - Lead Time - Price...

    ValleyGirl10 pointsBadges:
  • CPYF

    Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan't any data to be copied from LF1 to PF2 (dont want to use clrpfm after copying data) Is there...

    anuppdas105 pointsBadges:
  • Deleting a Table

    I have full permissions to a DB, but I can not delete a table.

    dshafer15 pointsBadges:
  • Security

    Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.

    bgharrod5 pointsBadges:
  • Access Find the previous checkout record and add a return time

    I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record...

    TeaBone5 pointsBadges:
  • Mainframe Performance Testing

    I am doing a research and would like to get answers to the following questions, I appreciate and value your experience and time: 1) What are the different types of mainframe applications? 2) What are the general performance issues that are expected? 3) What tools are used in performance testing...

    Iluvlearning0 pointsBadges:
  • Database trends

    I am researching the following topic and need to find relevant articles. Database trends and their impacts on commerce.

    jms8420215 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