• How to download data from DB2/400 table

    Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

    smlegacy15 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • Linking tables in databases that change each month

    The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

    cyberGirl19665 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Incrementing a key field without autonumber

    I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?

    HNDstudent5 pointsBadges:
  • Database

    Special database object can not be located?

    trust5 pointsBadges:
  • and IIf statement in a query

    How do I write an IIF statement in a query, that does the following: if date1 - date2 is less than or = to 0 then Y else if greater than 0 then N

    Raleigh35 pointsBadges:
  • Want to move into Technical Side

    Hi, I have done my B.Sc in Chemistry and then MBA in HR. Presently I am working with consultancy as IT Recruiter and having around 3 yrs exp. Now i don't want to continue with Recruitment and want to sift into Technical side. I am thinking to do DBA or Datawarehousing course. Can anyone guide me...

    Hrakhilesh10 pointsBadges:
  • Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • 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,380 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,710 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:

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