• AS/400 SQL V5R2 — updating new fields in a file with values from a different file

    I added 2 fields to FileA (FldX and FldY) FileA has the key to FileB (KeyB) where these values exist. FileA: FldA, FldB, KeyB, new... FldX, FldY FileB: BKeyB, BFldX, BFldY This is probably simple for someone that composes SQL all the time but I'm having trouble coming up with acceptable syntax......

    AskDave0 pointsBadges:
  • ILE sub-procedure does not return data from a ReadE operation

    Sub-procedure is directly bound to pgm and has f-spec to read a file based on incoming keys. Handles the keys correctly and sets conditions based on found/not found in the file but the input buffer never loads into the field names for the file. Object is to return entire found record as a...

    AskDave0 pointsBadges:
  • Master-Detail query return on one row

    I have a parent-child relationship. I would like to have a query return the results where all children are on the same row as their parent. No children will have more than one parent. For instance: Table PARENT contains one column with the data: Parent1 Parent2 Parent3 Table CHILD contains two...

    Acopelan0 pointsBadges:
  • Store picture from vb to access field

    Hi, can somebody please guide me on how to link/save a picture in VB to store in an OLE field in access database?? Please let me know. In desperate need. Thanks in advance Princess8

    PRINCESS85 pointsBadges:
  • Views: One document per line?

    If I have a form containing a dialog box of 6 activities, and I fill out 6 different forms - selecting a different activity each time - Is it possible to show in a view, on only one line, my name in the first column and one of the 6 separately chosen activities in each of the following 6 columns. I...

    Ossie30 pointsBadges:
  • Urgent!Please help: TOP 3 cities only returned based on count() – result

    I have three tables: Country, City, Restaurant. I would like to have a query that first calculates how many restaurants are for each city. I would only want to return those three cities for each country which has the most number of restaurants. Country-table: countryid, countryname City-table:...

    Ronjar0 pointsBadges:
  • Adding color in SEU Editor

    Does anyone know how to add color to a comment line within the SEU Editor? For instance, blue or red other than the typical green screen. Thanks.

    Cobra690 pointsBadges:
  • Help with VBA Code for retrieving data from a table in an MS Access Database

    Hi, I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected...

    Suprababe0 pointsBadges:
  • SQL Trigger to create .csv file

    I need to create a .csv file out of table A upon the insertion of a record into table B. It seems to me that this should be easy to accomplish, but the only answer I can get from anyone is to do a scheduled DTS package, which means we are dumping this table every couple of minutes all throughout...

    Zannemarie0 pointsBadges:
  • administrative data when changing values of characteristics (2)

    Hi, I already asked the same question a few days ago. Sorry for this reply. Release 4.5B or 4.6C Materials are assigned to a class. With MM02, in the view Classification of the material info record, we can change the values of the characteristics. My question: is it possible to know who has created...

    Jpm21120 pointsBadges:
  • Library List

    How can I verify if a curtain library exists in the *LIBL?

    Cobra690 pointsBadges:
  • Reading the spool from Rexx

    Hi, I have a requirement to read the data from the spool and use it in the rexx program. The first step in my jcl will be a program which writes some output in to the spool(Let us assume that I will not be able to redirect the output into a dataset), then I need to run the rexx program which should...

    Sramki0 pointsBadges:
  • PHP on a microsoft webserver

    We have a web sever at my work a that has the company internet and intranet sites on it. We want to put up another website using php, is this possible on a microsoft webserver?

    Natethegreat0 pointsBadges:
  • Calling a subprocedure from a CL

    Can I call a subprocedure from a CL?

    Cobra690 pointsBadges:
  • Application Security

    Hi everybody. I cannot remember the name of the AS400 data file that is the list of user ID's and security PARMS. I need to validate user ID's for a project I'm working on and just cannot remember that file name. Can anybody help?? Thanks. MariusM

    MariusM0 pointsBadges:
  • Field ‘input enabled’ attribute

    I am looking to use the 'input enabled' attribute to control who is able to input data in a specific field. I have not been successful in locating any information on whether this feature is suitable for this or not. Also, what would be the type of code required to use it?

    Swami5240 pointsBadges:
  • How to use API (QMHRCVPM)

    Hi everyone... My first time to this site and I could use some help. I'm trying to use the Receive Program Message API to retrieve an error message that I want to mail to a user. Here's the scenario: Program 1 calls Program 2 calls program 3 calls program 4 Program 4 has an unmonitored message that...

    WESTDEB270 pointsBadges:
  • Webenabling of green screens

    I am trying to web enbale a sample green screen using Webfacing & WDSc. I have a written a CL program that just SNDRCVF the screen record format which consists of a sample text to display. It works fine when I call the CL program from the command prompt. I have converted this screen using Webfacing...

    Sbkhole0 pointsBadges:
  • QDLS?

    I attended an iSeries users group meeting recently and one of the participants advised against using QDLS. I don't recall the specific issue but it had something to do with QDLS not being thread-safe. It may have been a security issue. Can anyone elaborate on this issue? Our shop doesn't use QDLS...

    Dantheband0 pointsBadges:
  • Melissa virus

    Anyone have any stories about Melissa infections or other impacts caused by the virus when it ran rampant five years ago?

    ShawnaMcAlearney0 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