• 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:
  • 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:
  • Modify Hexadecimal Flat File in AS/400

    Hi, I am working on a project, but have got stuck and I need expert advice. I received a flat file from another system (probably a Windows system) in AS/400. The flat file contains the data separated with hexadecimal (x'05') . The file I am receiving is through connect direct. My requirement is to...

    As400t10 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:
  • Database trends

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

    jms8420215 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 pointsBadges:
  • Basic O & M activities for any database server

    What are the basic O & M activities for any database server

    anshu4020 pointsBadges:
  • Difference between EAI middleware and TIBCO middleware

    Plesae explain difference between EAI middleware and TIBCO middleware.Which will be better useful for integration between two ORACLE database

    anshu4020 pointsBadges:
  • Are there any Pl/Sql like features in j2me?

    I want to deveplope a mobile game in which i want to use database and all its features which is possible in pc through oracle and sql...is there any way to use them in j2me? Is rms an answer? Can i use java db.?

    hussain22juzer530 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.

Thanks! We'll email you when relevant content is added and updated.

Following