What is the best why to get started in DBA
I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self [...]

Answer Question   |  March 31, 2012  11:00 AM
Access, DBA training, iSeries database, SQL

Using CL Commands
Hi, How run the cl commands using rpg/400? how to use the chkobj command in rpg program? (That mean without using command line from wrkmbrpdm?

Answer Question   |  March 31, 2012  10:27 AM
AS/400 objects, CL Commands, RPG/400

Drawer selection for Lexmark T652DN
We are running V5R4 in our iSeries & we have AFP installed.  We want to automatically print to our new Lexmark T652DN from drawer 3 (plain A4), leaving drawers 1 & 2 free for pre-printed forms. The Printer has an IPDS card installed.  How do we go about achieving this?

Answer Question   |  March 31, 2012  9:12 AM
AFP, IPDS printer, iSeries, T652, V5R4

SFLRCDNBR-in subfile
what should be the value of hidden field define under keyword SFLRCDNBR when subfile is empty???

Answer Question   |  March 31, 2012  6:22 AM
AS/400 Subfiles, AS400 Data Definitions, SFLRCDNBR

AS400 vs SAP
If you are familiar with AS400/BPICs/BAMCS can you catch onto SAP easily?

Answer Question   |  March 31, 2012  6:49 PM
AS/400 administration, SAP, SAP administration

Monitor for job status DSPA
I have to reset user sessions frequently on our iSereis. The job status is usually DSPA. How can I monitor for DSPA job status in QINTER on an iSeries and automatically end the sessions?

Answer Question   |  March 31, 2012  5:19 PM
AS/400 Monitoring, AS400 Job Status, DSPA, OS/400

CPYTOIMPF
I want to copy a spool file to the IFS.  I tried ===> CPYTOIMPF FROMFILE(FILES/SPRINT198) TOSTMF(‘print/testprint.txt’) STMFCCSI D(*STDASCII) RCDDLM(*CRLF) DTAFMT(*FIXED)        and I got garbage –                               

Answer Question   |  March 31, 2012  5:15 PM
AS/400 Spool Files, CPYTOIMPF, IFS, IFS Commands

Does sFTP works for SNDDST command
Currently our business is modifying all existing interface (From IBM V5R4M0) with Windows server to replace FTP by sftp. Our Question is — whether SNDDST works even after we covert from FTP to sFTP, if there exists any issue what would be the alternate IBM command which works along with sFTP

Answer Question   |  March 31, 2012  3:33 PM
AS/400 SFTP, SFTP, SNDDST, V5R4M0

Separate SUM results on a single line
Can DB2 return separate SUMfunction within one statement. If I have : SELECT BRANCH,SUM(AMOUNT) ,COUNT(*) FROM TableA WHERE BRANCH IN (180002,180092) gives Branch,Amount,Count 180002,+100,3 can I return two SUMs – one for positive values of amount and one for negative amounts so will get :  Branch, credit, debits, Count  180002, -100,+200,3

Answer Question   |  March 31, 2012  1:41 PM
DB2, DB2 Views, SUM function, SUM statement

t-sql and AS400
I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by [...]

Answer Question   |  March 31, 2012  12:34 PM
AS/400 Query, SQL, SQL Query, T-SQL

DLTOBJ command restricted
in our concern we have restricted the command dltobj? also no user shld not delete any object without confirmation mail from secadmin?but some users delete the objects using the option 4/ how can we find that object and the user who deleted that object?

Answer Question   |  March 31, 2012  12:12 PM
AS/400 commands, DLTOBJ, Object authority

SAVF: Backing up all user libraries
i tried to backup all our user libraries  using savf, but i can’t able to give more than one library.how could i sav all the lib? ex: i have lib’s user1lib | user10lib | user16lib i have to sav all the obj init?

Answer Question   |  March 31, 2012  12:07 PM
AS/400 Library, SAVF, SAVLIB

USERPRF name
how to change user profile name? it used CHGUSRPRF cmd to change user name?but it say  Current values could not be retrieved. isthere any other way to change profile name

Answer Question   |  March 31, 2012  7:00 AM
AS/400, AS/400 user profiles, AS/400 user sessions, USRPRF

i5 Query Security
Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system.  I’m concerned that someone will save the results of [...]

Answer Question   |  March 31, 2012  7:01 PM
AS/400 Query, i5, I5 security, Query, Security

How can I retrieve multi-members List to physical files
How can i retrive the Mutli members list to a Physcial file.i tried the below command. i got the error code   DSPFD      FILE(AMLIB/DEMOPF) TYPE(*MBRLIST) +                OUTPUT(*OUTFILE) FILEATR(*PF) +                 OUTFILE(AMLIB/DEMOPF2)                   [...]

Answer Question   |  March 31, 2012  8:18 PM
AS/400 command functions, AS/400 commands, Physical Files

AS/400 PF to IFS with CCSID 935
I have a file on the as/400 which contains mixed language data.  Some fields are coded as ‘O’ to accomodate DBCS Chinese Characters.  This all works fine.  If I pull the data up in Excel using the iseries add in, it comes up great.  I need to take this file and place it on an [...]

Answer Question   |  March 31, 2012  4:20 PM
AS/400 administration, CCSID, IFS, Physical Files

AS/400 Batch job Issue
Hi One of our job, for which code was untouched from an year , has now started taking excptionally long time to complete. It used to take hardly 20 mins to complete. Now from last two days it is taking almost 7-8 hrs. The only observation i made was that it is not getting cpu [...]

Answer Question   |  March 31, 2012  3:27 PM
AS/400 batch jobs, Batch jobs, QBATCH, SBMJOB

Remote Access Client Access
I have used client access for years. I had a linksys router to a westell modem model 6100. THEN Frontier came in and swapped the westell modem for a westell model 7500 which is a modem/router combo. It has been configured for port forwarding. However, it won’t let me in from home. What changed and [...]

Answer Question   |  March 31, 2012  2:35 PM
iSeries remote access, Port forwarding, Remote access, Routers

Speed of a V5R4 processor
how to find the processor speed of an V5R4 system

Answer Question   |  March 31, 2012  10:27 AM
iSeries administration, Processors, V5R4

How to come up with storage statistics on iSeries 820
Sir: As per requirement again from our 3rd party vendor in assessing our prod iseries 820 for system performance fine-tuning:      “System storage information – Size and percentage allotted to SIBS and other system, usage, backup in the prod server.”       The main concern of the 3rd party vendor is on SIBS (Silverlake banking application) [...]

Answer Question   |  March 31, 2012  7:05 AM
iSeries, iSeries 820, iSeries Storage, V5R3