• 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:
  • AS400 System Information Through Data Access

    Hi, We do a lot of AS400 system checks on a number of servers. Is there a way of using ODBC/OLE DB to access information from an AS400 concerning such commands like WRKDSKSTS (After using the F11 key to determine which ones are active), WRKSBS, QSYSOPR Messages, etc. I am trying to download this...

    Rjkrawch5 pointsBadges:
  • Using %NOT in OPNQRYF

    I know that %NOT is a function available for using in the qryslt parameter of opnqryf but I can't figure out how to code it. I would like to eliminate all records with a range in the middle of the possible range, for example, select all facilities except those is the range of 600 - 699. Is this...

    CLKelly120 pointsBadges:
  • Limited capability and ability to change initial program

    We limited entering system level commands on our AS400 box by assigning initial JDE programs to user profiles. If they sign off from the applications (pressing F3 key), it kick them off from the session and gives them login screen. However we left limited capability set to *NO for all of them. Can...

    Nadavka5 pointsBadges:
  • Log AS/400 user key strokes

    I need a way to log the key strokes of an AS/400 user (on green screen). I want to know everything entered, including menu option numbers entered on

    zbbwoc95 pointsBadges:
  • DNS server resolves 2 port card incorrectly

    We recently installed a new partition with a 2 port ethernet card. Each port has its own IP address and connections through the network work fine. The problem is that both ports are known to the DNS servers by the one system name so when a DNS name lookup occurs, some users are directed to one port...

    Mike.Butler40 pointsBadges:
  • JBA Explorer 6.3.1

    Anybody using JBA Explorer build 6.3.1 with iSeries OS V5R3? We are having issues changing passwords using it...they have a command on the File menu for WRKSBMJOB, they execute it and then at the command line do CHGPWD....they get the password change screen, enter the info and when they do OK they...

    ATitus85 pointsBadges:
  • Bad date.

    I'm using the "CPYTOIMPF" to create a .csv file from a iseries database. All fields look good when opening the spreadsheet, except the date. The format of the date is MM/DD/YY 8 position char. field Here's what it looks like.ñññòð÷

    Shelties10 pointsBadges:
  • how to auto sign on using active directory lookup

    We’d like a software package (call it auto sign-on ASO) to > support the following: > 1. a user starts a secure application. > 2. the login prompt appears. > 3. user passes his/her HID prox card in front of a reader > 4. ASO authenticates user. Not sure what to do here - maybe...

    Msm5415 pointsBadges:
  • READ FROM SUBFILE

    Hi, I have a problem in reading my subfile: After loading the subfile and display that on screen, I want to read the records of subfile and write them on preint file. But inspite of managing the RRN, every CHAIN command get the last record of subfile. here is the code: C EVAL RRN = 1 C DOW RRN <...

    Leiloon15 pointsBadges:
  • opening crystal report using ISeries sql error Temp table already exists

    I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table...

    Jlav0 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