• T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • Deleting unmatched records from a file in iseries SQL

    I'm trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100                                   WHERE SHListNo = ALL                                     ...

    PSMurray530 pointsBadges:
  • Get AS/400 FTP session to echo back data and time

    Frequently our AS/400 sends data to our bank via FTP. The bank returns a 220 welcome message in the FTP log which includes the time. We would like to also see the date from the bank's UNIX computer recorded in our log. I've tried a couple of things in our FTP script but the commands were rejected....

    WoodEngineer6,530 pointsBadges:
  • iSeries Syslogging

    We are going through a PCI audit. It was recommended that we look into iSeries Syslogging. What is it and how do I do it?

    CharlieBrowne41,380 pointsBadges:
  • iSeries Net Time

    We are going through a PCI audit and it was suggested that we implement NET Time on the AS400. How do I do that?

    CharlieBrowne41,380 pointsBadges:
  • Retrieve AS/400 Printer definition

    I would like to let my users override the printed output to a printer of their choice but I need to protect them from themselves. Is there a way that I can determine if the name they enter is a valid print device? I would like to be able to do this in an RPG program on an AS400 running V5R4.

    Oldtonew135 pointsBadges:
  • Sending iSeries spool files to a network printer

    I have a problem whereby my network printer is printing multiple copies of a spool file I have sent to it - it just keeps churning them out. The printer in question is an OCE' re-branded multi-function printer. I believe it's a VL2822C VarioPrint machine. Has anyone used these to print from an...

    Bristoldoug45 pointsBadges:
  • Cannot rename file or folder in the IFS

    Hi all I have a very odd problem with an XP laptop and our System i (9406-520 V5R4). Users (limited or admin) that are configured on this PC are unable to rename files or folders in the IFS of our System i. HOWEVER the user can create and delete files and folders in the IFS. And they have...

    Hannonj40 pointsBadges:
  • RPG and Service Programs

    I'm getting into the "MVC pattern" experience of RPG programming, thanks to Scott Klement's hints (see "A pattern for reusable code" on his site http://www.scottklement.com and "Binder Language and the Signature Debate" at http://systeminetwork.com/print/64029). After some initial difficulties, I...

    Paolo5185 pointsBadges:
  • Changing authority to access /qntc files

    Hello. i have written an rpg/iv program that allows users to maintain certain network pc files from a greenscreen. it uses the /qntc file system to access those pc files. the problem i ran across is: unless the i5 userid and password is identical to the network userid and password, the program is...

    RickMe110 pointsBadges:
  • What date is returned after midnight rollover on AS/400 job queue?

    We have nightly jobs that are queued up to release at 23:59 each night. Depending on how many are released at once, it may or may not make it into the jobq before midnight. The main CL program calls a second CL program after midnight. The called CL program uses the RTVJOBA command to get date....

    Canuhp235 pointsBadges:
  • Stop using UNICODE data type

    I repeatedly need to upload spreadsheet content and create physical files on our V5R4 iSeries box. Each time I run the create-new-file wizard, it scans the source data and, if a character is encountered in a data row, it defaults the data type to UNICODE. I want it to default to CHARACTER. Is there...

    BradBradley30 pointsBadges:
  • Debug batch job

    hi all,     how to debug batch job please give me in details... thnx

    chakramdhar60 pointsBadges:
  • Is there a way to tell who held a job queue on the AS/400?

    Our night shift discovered a job queue on hold with a number of jobs that should have run earlier in the evening. Is there any way to determine when the queue was held and by whom?

    EileenNJ20 pointsBadges:
  • Float type parameter containing incorrect value after a callp

    I'm calling a procedure from an rpg pgm(V5R4). It has several parameters with different types. Before calling, they are set to 0 or blanks. After calling, all is coming back with correct value except for 1 float(8f) field. We don't have the source for the procedure however, it's been tested in C...

    kglen0145 pointsBadges:
  • Command to track how many spool files users have

    I have certain users who never clean out their spool files. Is there any command I can run which will tell me how many spool files a user has out there? I am currently on version V5R4 of the operating system

    GHENDER190 pointsBadges:
  • Changing the member type in a source file

    I have created a cobol source in QLBLLESRC in my library. But by mistake I created it as a text file by not entering the member type as "CBLLE". How can I change the member type now...thanks

    ten20081,150 pointsBadges:
  • Serving web pages from the ILE

    In ILE Cobol I can create and XML document using the built in XML generate (and XML parse) statements. How do I go from there to serve this to a browser? I would like to use a web page IDE tool that I hope can output XSL and then merge the XML and XSL to give HTML to be served to the browser. I am...

    JohnDavids35 pointsBadges:
  • Communicate with a RS232 device in my RPG program

    I need to retrieve the weight from a scale hooked to my PC with via RS232. I need to send the device a character(P) and which will trigger the scale to send back the weight. Thanks.

    10155 pointsBadges:
  • Reorganization of V5R4 while active

    We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

    GHENDER190 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