• How to update in SQL using DS

    My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the...

    MMAGuy85 pointsBadges:
  • Message file

    I am using RPG II on an AS400 opererating in a system 36 enviroment. I've created a message file for our Order Entry program by making a copy of an exsiting source and adding an additional message and MIC. It was tasted using: // member user1-ntrymsg and // * 1251. The message I added was...

    Ruxx665 pointsBadges:
  • calling a C function in COBOL ILE

    In RPGLE I can call a C function like this: D sin PR extproc('sin') D parm F value C Eval mySine = sin( deg ) How do I do this in COBOL? Any examples? Thank you.

    Unknowingone195 pointsBadges:
  • Scheduling queries in AS/400

    What is the easiest way to schedule several queries to run several times throughout the day??? Will the Advanced Job Scheduler accomplish this or would writing a simple CL program be easier? Or is there any other methods?

    Johnny520 pointsBadges:
  • THIN CLIENT/ printer

    I am not a pro at as400 but i am having to do this stuff some i can get but i would like to set up a printer attached to a thin client i really need step by step if you can i also want to print to this printer every-time anyone is logged into this thin client thanks

    Itmark10 pointsBadges:
  • COBOL data appearing out of order in database

    Hi....Would you know what could be the cause of data appearing in an IMS database out of order? Access type is HIDAM, rules=(,H). The segment that is out of sort order is a child, there are 4 occurrences, and it should be sorted by effective date. Here is an example of the database in data vantage....

    123456300 pointsBadges:
  • LAN connection problem

    I have a Dell Latitude C610 (OK stop laughing), running XP Pro. I am VERY novice. My company gave me a Sprint USB wireless modem, I installed and it works well. Since installing it, I cannot get the laptop to use the onboard LAN port when I need it. I boot without the wireless, and plug my Ethernet...

    It74me5 pointsBadges:
  • Activation Groups and Open Query File use

    I am executing a CLLE program that uses an OPNQRYF to select records from file "FILE1" which is a physical file containing in excess of 1 million records. I only need records with a specific date (about 5000 records) The file is opened for share = *yes and the program calls an RPGLE program that...

    wmfsr20 pointsBadges:
  • iSeries Email using SNDDST: problems…

    Hello you all, Well I'm trying to write a small CL to inform me via email of some messages that I received on my AS/400. I've been browsing IBM site, this site... and other to find how to send email via my AS/400... but it's still not working... I'm running V5R3... and my SMTP mail server runs on a...

    PierreLG60 pointsBadges:
  • COBOL I-O-FEEDBACK area

    I'm trying to find the breakdown of the I-O-FEEDBACK structure used in COBOL/400, what information is at what offset. One might think that should be an easy piece of info to obtain, but I've just spent 2 hours at IBM sites and in IBM manuals on the web, and every manual that mentions the structure...

    Unknowingone195 pointsBadges:
  • How to check for a junk value in Numeric Field in RPGLE

    How to check for a junk value in Numeric Field in RPGLE?

    Try35 pointsBadges:
  • SQL and CL

    I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?

    Popers40 pointsBadges:
  • How can I tell what fields from what files are being used in a rpgle program?

    I need to know which fields from which files are being used in the program. The compilation listing helps but doesn't tell me which file.

    Waggom5 pointsBadges:
  • Cursor using update and order

    I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql c+ declare...

    Unknowingone195 pointsBadges:
  • Multiple record locks in a single file.

    How can I attain multiple and simultaneous record locks in a single file without using commitment control? (...in RPGLE...)

    bogeybetsy560 pointsBadges:
  • Query Question

    okay, first let me apologize for my general lack of knowledge about my computer system. We don't have anyone in house that can help so I turn to this site for hopefully an answer. I am not sure I can even communicate effectivey my question but here goes: I am trying to write a query with our AS400...

    Karen1235 pointsBadges:
  • How do I add an AS400 to a network hub

    I have an AS400 that used to belong to a network at our office. There were routers and static IP addresses. Now I have the AS400 at home and I'd like to attach it to the network hub that currently has my laptop and desktop and is also attached to the Internet via cable modem. My goal is to be able...

    Fmat520 pointsBadges:
  • SQL update question

    I'm new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I'm updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update set record = :myds but...

    Unknowingone195 pointsBadges:
  • AS400

    hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.

    AS400person0 pointsBadges:
  • How to physically attach a PC to an AS400

    Is there a way to physically attach a PC to an AS400 so that I can communicate between the 2 via client access?

    Fmat520 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