List objects owned by named user in iSeries
How can I list all objects on a system owned by named user. (I am trying to track where a certain user has made changes in the past (years ago..), and I want this to be part of the analysis. I would like to have a parameter ‘OWNER’ on the DSPOBJD command, but its not there. System [...]

Answer Question   |  April 28, 2011  7:53 AM
DSPOBJD, IBM, Object authority, System i, V6R1

Using MGET FTP command
Does anyone know how may I get files with the same beginings as abc*.* in different directories inside of the main directory using mget. Any help would be appreciated

Answer Question   |  December 14, 2010  2:38 AM
FTP, General Directories, MGET

Colored CL Source
How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?

Answer Question   |  April 9, 2012  10:00 PM
CL programming, CL programs, Programming Languages, SEU, SEU Editor

Accessing OUTQs and writers in AS/400
I have been tasked with writing a CL to accept the following incoming parameters USER NAME, OUTQ NAME, LIBRARY NAME, & RETURN CODE.

Answer Question   |  December 14, 2010  9:38 PM
AS/400, CL Program, CL programming, OUTQ

Database field in CLP
hi, I am reading a database file line by line and want to display the records in QSYSOPR. i am using CHGVAR   VAR(&A)   VALUR(B)         where &A = variable in CL, and                  B = field from database file SNDPGMMSG &A MSGQ(QSYSOPR) But the problem is i am not getting value of B rather i [...]

Answer Question   |  December 22, 2010  11:18 AM
AS/400, AS/400 database, AS/400 Database File, AS400 CLP, QSYSOPR

Saving AS/400 Libraries on tape disk
Good day to all, I am new user of AS/400. I need to know how take backup of specific libraries on tape disk, step by step procedure, how to prerequisite services end and start after taking backup. Thanks, Regards, Tahir Ali

Answer Question   |  December 25, 2010  9:12 AM
AS/400 backup, AS/400 Library, Tape Backups, Tape libraries

RPG/400 Batch Job Debugging
I have learnt through Net that Debugging a Batch job involves 1. Submit the job with the HOLD (*YES) parameter: SBMJOB HOLD(*YES) or Hold the job queue that before submitting the job by using the HLDJOBQ command. 2. Determine the job name, user, and number of the submitted job by using the WRKSBMJOB command. 3. [...]

Answer Question   |  December 15, 2010  6:02 PM
AS/400 batch jobs, AS/400 debugging, AS400 Batch job Debug, Batch debugging, RPG/400

How to remove the double quotes in CSV file in iSeries
Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e ‘s/”"//g’ file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE(‘Sed’ *BCAT ‘-e’ *BCAT +                  ‘s/”"//g’ *BCAT ‘/’ *TCAT &USER +                            *TCAT &WOUTFN [...]

Answer Question   |  December 13, 2010  11:59 AM
AS400 program, CLLE, CSV, CSV file format, iSeries, Shell commands

Exporting files via AS/400 iNavigator
I am exporting hundreds of files daily from the inavigator to our company network. When I simply drag files over to network it changes the file to a text file. If I export the file using the inavigator it defaults to My Documents, I then need to click to the network drive, then click the [...]

Answer Question   |  December 14, 2010  5:55 AM
AS/400, AS/400 File Transfer, iNavigator

Using API QC3ENCDT in encryption using RSAalgorithm under a Public key, error CPF9DDB !
Hi I have been working on Encryption/Decryption of data on AS400 v5R4. I have already done the Encryption of data using QC3ENCDT API on COBOOL. Now, I want to use the RSA Public key to encrypt my encryption key. For that I had written a test program but it is throwing one error and I [...]

Answer Question   |  December 13, 2010  8:27 AM
AS/400, COBOL, Data Encryption, RSA Adaptive Authentication, V5R4

How do I retrieve data from Visual Basic 6.0 with SQL?
how can i rertieve data in vb6.0 from sql?

Answer Question   |  December 13, 2010  4:58 AM
Retrieve Data Area, SQL, SQL Server, VB 6.0, Visual Basic 6.0

Using a variable in the LABEL ON SQL statement
Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

Answer Question   |  December 14, 2010  7:26 PM
AS/400 SQL, RPGLE, SQL, SQL Server

Boomi using JDBC to access DB2 in AS/400
Want to use Boomi to access JDE DB2 What do I need to define on AS400?

Answer Question   |  December 11, 2010  6:46 PM
AS/400 administration, AS/400 DB2, Boomi, JDBC

AS/400 Data Queue being deleted
We have 5 data queues that work fine, but one queue is being randomly deleted by QZHQSSRV. OS400 Version is 5.4. All queues are FIFO and in the same library/ASP

Answer Question   |  December 10, 2010  5:04 PM
AS/400 Data Queue, Data Queue, OS/400, QZHQSSRV, V5R4

Find missing numbers with SQL
In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

Answer Question   |  December 14, 2010  2:35 PM
AS/400 SQL, SQL, SQL Server, V6R1

How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field
My situation is….. I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the ‘Amount’Field in the file is changed to 12-char, in the new library. only this field’s name is changed in order to avoid ambiguity. Otherwise the file-name & other fields remain the [...]

Answer Question   |  December 18, 2010  5:50 PM
AS/400, AS/400 numeric fields, DB2/400, OVRDBF, RPG Program

QINTER will not go down due to keyboard error
We shut down QINTER at 3:30 AM to do a quick backup. We have 5.4. When someone leaves a terminal or PC session on with a keyboard error (last night was an “invalid F key pressed”) QINTER will not go down all the way! It sits there until the session is physically terminated at the [...]

Answer Question   |  December 12, 2010  3:13 PM
AS/400, AS/400 backup, AS/400 backup and recovery, Backup, Backup and Recovery, iSeries, QINTER

Add more than one parameter in URL called from AS400
i have a probelm which when my CLP use STRPCCMD to open the URL it pass one parameter only and when i add & to another one , it always read first parameter only, how can i add the secound parameter with using & so HTML can read it

Answer Question   |  December 9, 2010  11:48 AM
AS/400 Parameters, CLP, CLPROGRAM, STRPCCMD

Updating the column heading of a Physical File
Is it possible to update the column heading’s of PF in an RPGLE program ?

Answer Question   |  December 30, 2010  7:47 PM
AS/400, Physical File, RPGLE

AS/400 library object authority
How do I change object authority for a library

Answer Question   |  December 21, 2010  3:38 PM
AS/400 administration, AS/400 Library, Edit Object Authority, Object authority