• DateAdd Function

    I have a dateadd function in a query Cdate:DateAdd("yyyy",[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that's not the problem. Now I need to run the query with the...

    AccessFlunky50 pointsBadges:
  • DB2/400 – Source Physical File Deletion?

    I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

    BibinGeorge130 pointsBadges:
  • Clustered and Non clustered composite index

    I have a database that has a clustered composite index and 2 non clustered indexes on each of the columns used in the composite index. Doesn't it just need the clustered index?

    Bleeb45 pointsBadges:
  • Call SQR (Structured Query Reporter)

    how to call sqr on aix and return spf to windows

    Gdcl5 pointsBadges:
  • Label Traxxx Client – Anyone heard of this program?

    Label Traxxx Client - Anyone heard of this program? We use this every day as one of our main databases. Does anyone know of a manual of shortcuts or how to understand this program?

    Jreifenstein001185 pointsBadges:
  • Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • empty fields in a query

    I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...

    Bananahead60 pointsBadges:
  • Update a flat file through CL

    Hi, I have copied a message from MSGQ into a CL variable. Is it possible to write that message in a flat fiile through CL.

    Cool400115 pointsBadges:
  • QYKMIMPK Usage

    Sorry if this shows up more than once, first time poster and I'm a tad confused about how to get my question to appear under a specific category. I'm trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to be...

    Toadfoot10 pointsBadges:
  • DB2 logical files

    HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

    ten20081,150 pointsBadges:
  • Access IIF Statement Not Returning All Records based on Option Group

    I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is:...

    EngTech5510 pointsBadges:
  • AS/400 data mapping with CPYFRMIMPF

    We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new expanded...

    GarySouders10 pointsBadges:
  • MySQL on AS/400 V5.3

    I need to install MYSQL for as/400 V5.3 but I don’t know how and from where and dose it free or charge or chargeable product?

    Bsd16765 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Access Course/Student Database

    I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with...

    AccessFlunky50 pointsBadges:
  • Read/Write ability to MSSQL using FoxPro 2.6 for DOS

    Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this...

    Aimtek5 pointsBadges:
  • Different Results on Insert Select than Select

    I'm struggling, along with others, where I'm getting different results when doing an Insert select verses just the select. Lots of joins to get data from various tables. Only want the first record from the uniqfield table so created the tmp_uniqfieldid table with that item fielded, creation_ts...

    Bem35 pointsBadges:
  • A report that works in Crystal Reports client does not work in CMC

    Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week's data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record....

    Alienzaway5 pointsBadges:
  • Substract two fields SmallDateTime at SQL Server

    Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = "Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder - TglDatangKembali > 7" Cm.Execute If i get the error : Arithmetic overflow...

    Suryanto5 pointsBadges:
  • Can’t use database within Workgroup with Windows XP clients

    I am in charge of 10 computers and a server, I have them all on a workgroup and i can only use the database application installed on the server on the older computers. I try to use the same program on win xp but it says that the program is outside of the local intranet or on a untrusted source so...

    Techsupport0985 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