Files-Sqlrpgle
******************************************************** C                   READ      OUTSRC               C                   EVAL      MBR  = mlname         C/EXEC SQL                                         C+ SELECT * FROM LIB/:MBR                          C/END-EXEC                                        ********************************************************* In above code MBR contains the file name. Is it possible to have Host variable for FILE NAME in above query?? In that above code Host variable for File name is not working… plz guide me [...]

Answer Question   |  March 17, 2012  5:40 AM
SQLRPGLE

i want to upgarde my os v5r4 to v7r1 ,
please explaim me the whole procedure and requirment like , ASp , memory

Answer Question   |  March 19, 2012  9:30 PM
AS/400 upgrades, V5R4 Upgrades, V7R1

Upload multiple text files to iseries via ftp
How to upload multiple text files via FTP: I have a folder SP in my PC which contains 10 text files Path D:SP I have to upload all the 10 text files to my iseries QDDSSRCGOVIN where QDDSSRC – source physical file and GOVIN – library Start->RUN->CMD->FTP Open (my IP address) – username & password [...]

Answer Question   |  March 17, 2012  6:26 AM
AS/400, FTP

Improve performance for SQL query reading file having milions of recods (AS/400 – SQLRPGLE program)
I am fetching only 14 records each time from a customer file(physical file)  having milions of records. This file has 46 fields. Fetch is done in the follwoing manner, but it takes longer time - SELECT * FROM  CUSTOMER A WHERE A.CLINM1 LIKE ‘B%’ AND (CLINM1 <> ” OR  CLIPR1 <> ”) ORDER BY A.CLINM1 ASC, A.CLIPR1 ASC [...]

Answer Question   |  March 17, 2012  5:23 AM
AS/400, AS400 - SQL Queries, SQLRPGLE

User Profile Creation Date
How can I get the User Profile Creation Date for all my user profiles in one report?   I would be nice if this was in the same report as my DSPUSRPRF report which has all the other parameters I need, but Audit want to see when they were created . . . Don’t you [...]

Answer Question   |  March 17, 2012  2:53 PM
AS/400 user profiles, V5R4

SQLRPGLE
C/EXEC SQL C+ SELECT DISTINCT(CTP),COUNT(*) INTO :$Ctp,:#Ctotl FROM CUSTPF C+ GROUP BY CTP C/END-EXEC CTP is CustomerType in Customer File Here actually i am getting 3 records as output. But i dont know how to write those 3 records into a printer file. Can anybody explain me how to write the output of a select [...]

Answer Question   |  March 19, 2012  10:30 AM
AS/400, AS/400 output files, SQL commands, SQLRPGLE

Data Structure Arrays
I have a “page at a time” subfile and in order to store multiple pages of options I have created arrays to store the options and the PF record RRN and Key Fields. This process Stores and reloads the options seamlessly. It all works beautifully except that the options are executed in the order they [...]

Answer Question   |  March 19, 2012  9:36 AM
RPGLE Program

OUTQ
How does system pick the OUTQ when the job is executed ?

Answer Question   |  March 17, 2012  8:53 AM
OUTQ, outqueue

FTP & SAVF
1.How to download a savf to pc from iseries: 2.How to upload a savf from pc to iseries: Hi Gurus, I have added all the files from my source physical file “QDDSSRC” to a save file “SAVF1″ in the library GOVIN using the folowing command. SAVOBJ OBJ(QDDSSRC) LIB(GOVIN) DEV(*SAVF) SAVF(GOVIN/SAVF1) Now How i will download [...]

Answer Question   |  March 17, 2012  7:16 AM
AS/400, FTP, SAVF

how to handle Cursor progression in a mixed display file
I have a mixed DSPF (a combination of RECORD & SFL) Diagram is like: ——————————- Customer screen——————— from date :____                                                Print: _(Y/N) to date :____ opt             description … _         ___________ _         ___________ _         ___________                                                                             bottom ———————————————————————— My question is : I want that on tabbing,cursor should go from ‘from date [...]

Answer Question   |  February 28, 2012  6:18 AM
DSPF, FLDCSPPRG, Subfile Control, Subfile Display

snddst- in RPG
i am trying to use the SNDDST command in an RPGLE program. It works to one email (*PRI), i want to do a (*BCC) to another user but i get an errro. anyone have any code sample to do this operation? thanks

Answer Question   |  March 17, 2012  9:15 PM
AS/400 email, RPG ILE, RPGLE, SNDDST

Notepad++ Regex to delete a line
Well I’ve put in a lot of time, effort, energy & it’s a complete bust. Using Notepad++ Regex, does anyone know how to “delete any line containing 1 and only 1 slash (/)”? Here is a sample file… 1. C;Directory1 2. C;Directory1Filename 3. C;Directory2 4. C;Directory2Filename 5. any text In the above sample, lines 1 [...]

Answer Question   |  March 17, 2012  8:18 PM
as/400 data

usage of figurative constant *loval with Setll
I got a compilation error  “*RNF7055 30      1 Factor 1 is not valid for the specified operation.” for the following piece of code Filename    if   e             disk    *loval        setll     Filename   For the same code when i changed the F spec specifying the file as keyed (K) it dint throw any error …just [...]

Answer Question   |  March 17, 2012  5:15 PM
AS/400, AS400 RPGLE, Settl *loval usage

How to get the list of files in a library to a outfile
How to get the list of *file of attribute PF in a library in an outfile

Answer Question   |  March 17, 2012  10:03 AM
DSPOBJD, MS

as400 objects
How many object types in v5r3?

Answer Question   |  February 28, 2012  5:53 AM
AS/400 objects, as400 v5r3

CPF Errors
Whats the difference between CPF0000 and CPF 9999

Answer Question   |  March 17, 2012  4:22 AM
CPF errors, CPF0000, CPF9999

can we send email through AS400
is it possible to compose and send email to any secial network e.x (gmail, yahoo, aol… etc) using AS400

Answer Question   |  March 30, 2012  3:31 PM
AS/400

PCOMM’s file transfer protocol
Hi all. I want to know what file transfer protocol that the PCOMM(Personal Communications ) has used to transfer files with an AS/400 (excepts FTP). I want to write a program which has a file transfer function similar to the following PCOMM’s actions: - Send file to host. - Receive file from host. Thanks,

Answer Question   |  March 19, 2012  10:06 AM
AS/400 Transfer

how to use as-tran (port 8478) to transfer data from AS/400 to PC ? (Like PCOMM)
I try connect with server by port 8478 to get data but i don’t know as-tran work how ? I hope have any help

Answer Question   |  March 19, 2012  9:05 AM
AS/400 Transfer

Looking for IBM System i (V5R4) logging mechanism that records all status changes for a spool file.
For IBM System i (V5R4), is there such a thing as a system log that records all status changes for a spool file, specifically who held or released a hold and when? I know about attaching a data queue to an out queue, but that only “triggers” an entry when a spool file is set/changed to ready [...]

Answer Question   |  March 19, 2012  11:29 PM
change log, Spool file, status, System i