• 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:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
  • Automatically generating info into fields

    I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?

    Sunset3115 pointsBadges:
  • Send email to admin on table update in MySQL

    hi, I have to send an email every time table in DB is updated. i have to do this because my anti virus is blocking 25 port. so how it is possible to send an email without unblocking of 25 port

    Amenikk5 pointsBadges:
  • Microsoft Access database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Microsoft Access 2007 starting errors, tries to setup on each staring

    I have install Microsoft Office Pro. on a computer. Everything opens up fine except for Access. When i click on access to open it wants to install not open.

    Dwgwyther25 pointsBadges:
  • Oracle 10g process each record exactly on time multiple processes

    I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to process...

    Wileecanislatrans15 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 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